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