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.
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.
|Article ID:||Published Date:||Last Revised Date:||Platform:||Control:|