Calculation with getCalculatedValue

Topics: Developer Forum, User Forum
Oct 6, 2015 at 8:52 AM
I have a problem with my spreadsheet I need to retrieve the values ​​of a sheet that uses several sheets but all formulas are in french and I have mistakes. Should we translate all of our English formulas.
Thank you for your answers
Oct 6, 2015 at 9:13 AM
Without knowing the full details, it's difficult to say.

MS Excel (and PHPExcel) use "English" internally for formulas, and it is the MS Excel GUI that "translates" those formulas so that they appear in French when you view the cell.

But if all you're trying to do is retrieve a calculated value from a formula cell in an existing spreadsheet, then getCalculatedValue() should work
Oct 6, 2015 at 9:40 AM
Thanks for the answer.
The problem is that i must use the result of different cell to put in a var to make a xml file and i have a mistake like !! Formulas error in the php calculation.
All my formulas are in french !!.
I try to write stheet in html and i have the same mistake when I use get CalculatedValue.
If you have a solution it will be a pleasure.