CalcEngine and regions

[Stephen Hauck]

I want to store a formula in the database or in code like such ...  SUM(5,5) or SUM(10,5.35)

Even if I set the separators like below it does not parse correctly on non English US platforms ...

CalcQuickBase calcQuick = new CalcQuickBase();
CalcEngine.ParseDecimalSeparator = '.' ;
CalcEngine.ParseArgumentSeparator = ',';  

I want to store the formulas in english and then have the results provided in a regional format.. how do we do this ?

[Deivaselvan Y]

Hi Stephen,

Thank you for contacting Syncfusion support.

We can reproduce the reported formatting issue while parsing the formula other than English culture and confirmed it as a defect. We have logged a defect report and fix for this issue will be available in 2018 Volume 2 SP2 release which will be available on end of August 2018.

Regards,
Deivaselvan 

[Stephen Hauck]

That is AWESOME, thanks for your help in confirming the issue as well as making it possible to use the CalcEngine moving forward !

[Deivaselvan Y]

Hi Stephen,

Thanks for bringing this defect to our notice, Its pleasure to work for the utmost satisfaction of the customer.

Regards,
Deivaselvan 

[Stephen Hauck]

I was looking to test this out, is there any updated documentation about how to use regions before I start testing ?

Thansks

[Deivaselvan Y]

Hi Stephen,

We regret for the inconvenience.

Regarding issue fix

We are unable to include fix for the reported issue with the formatting while parsing the formula other than English culture in 2018 Volume 2 SP2 release due to it was delayed confirming the fix in multiple culture. However, we will include this fix in 2018 Volume 3 release without fail which is expected to be available by mid of September 2018.

Regarding Region use:

Kindly let us know whether you are requiring the details on how to set different region language by programmatic to test the patch?

Regards,
Deivaselvan