Category / Section
How to overcome the issue in formulas while using different region and culture settings in WinForms Spreadsheet (SfSpreadsheet)?
1 min read
Region and culture settings
The FormulaEngine class maintains the parsing and computation of formulas in Spreadsheet. By default, FormulaEngine is implemented for “en-US” region settings. While changing the region settings in the system, there may be a possibility of throwing an exception or error while computing formulas because of System separators (argument, decimal, date…), since they vary for some region.
For Example, ArgumentSeparator for “en-US” and “de-DE” culture as follows,
Separator | en-US (United States) | de-DE (German) |
ArgumentSeparator | “ , ” | “ ; ” |
In German Region settings, while computing the formulas in SfSpreadsheet, you can change the Separators of FormulaEngine like below code.
C#:
FormulaEngine.ParseArgumentSeparator = ';'; FormulaEngine.ParseDecimalSeparator = '.'; FormulaEngine.ParseDateTimeSeparator = '.';