How to change the formula argument separator?

Hello all,

I use Syncfusion to open Excel files and it's working great. My issue however is that the Excel files use a french layout with semicolons (';') as argument separators for formulas instead of commas (','), and thus the React spreadsheet component doesn't recognize the formulas.

I've searched a lot for a way to change it and I only stumbled upon this page :

https://www.syncfusion.com/kb/8440/how-to-change-the-formula-argument-separator-in-the-spreadsheet-based-on-the-cultures

but it's for the jQuery component, and I can't find a way to access the calc engine with the React component.

Any help is appreciated


1 Reply

TS Thaneegairaj Sankar Syncfusion Team March 8, 2022 07:29 AM UTC

Hi Corentin, 
 
Currently we don’t have support for your requirement. However, we have logged this feature request and it will be available in any of our upcoming releases. You can track the status of this feature using below link from our feedback portal. We appreciate your patience until then.  
  
 
Please get back to us, if you need further assistance.  
  
Regards,  
Thaneegairaj S  


Loader.
Up arrow icon