|
FormulaEngine class maintains the parsing and computation of formulas in SfSpreadsheet. 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,
In German Region settings, while computing the formulas in SfSpreadsheet, you can change the Separators of FormulaEngine like below code.
C#:
|
| Article ID: | Published Date: | Last Revised Date: | Platform: | Control: |
| 6505 | 03/10/2016 | 08/31/2016 | WPF | SfSpreadsheet |
You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.