I would like to know how Aspose Cells handles formulas that were written in french, in a french version of Excel.
What we need to do is:
1) Using Aspose, open an existing workbook and gather all its formulas (which are in french and migth contain some formulas such as “Somme” instead of “Sum”)
2) Save those formulas on some database
3) Using Aspose, apply those formulas to some data that is not in excel (but know which formula to refer to)
4) Get the results and send them to the user
When we get the formulas from the workbook, will Aspose convert them from french to english? Will a “SOMME” formula be read as a “SUM” ?
If it doesn’t do the translation, how can we use aspose to re-apply the formula afterwards, considering that (from my understanding of the product), it can only process formulas in english?