Formulas in another language

Aspose.Cells Product Family
1

Hi,


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?

Thank you!
2

Hi,


Thanks for your query.

Well, Aspose.Cells has its own formula calculation engine which can calculate the formulas which are specified in US (English) style, see the document for your complete reference:
http://www.aspose.com/docs/pages/viewpage.action?pageId=123437384

If you need to replace certain french formulas to English style, you may use Find and Search options provided by Aspose.Cells. For example, you may find those formulas using the relevant Aspose.Cells APIs and then replace certain strings in the formula accordingly and finally set the updated formula back to the cell(s) again, see the document for your reference:


Thank you.