Hi
We have a Syncfusion GridControl that contains formulae like: IF(R2<>0,100*(R3-R2)/R2,0)
These formulae work fine in the grid and the formulae calculation engine gives the correct results whatever regional settings/number formats we have on the PC concerned (e.g. English, French, Hungarian).
They also work perfectly when we use the XlsIO GridtoExcel function to create Excel files under English regional settings.
However, we get errors of the type below when we attempt to use GridtoExcel under regional settings like French and Hungarian that use a semi-colon argument separator in Excel:
Unexpected token.Unexpected token type: tNumber, string value: ,0 at position 24. Formula: IF(R2<>0,100*(R3-R2)/R2,0), Position: 26
We have tried to use the SetSeparators function, but it has no effect (as recommended in the KB article)
Any ideas on the correct approach here? Unfortunately the documentation on SetSeparators isn't too helpful here.
Many thanks
Richard