Answer the question
In order to leave comments, you need to log in
How to implement calculation of complex formulas in PhpSpreadSheet?
I have an excel document (xltm) which has three sheets. Sheets have many formulas for calculations, many of them use references to other cells in other sheets, for example, cell E10 from Sheet2 contains the formula '=$'Sheet3 '.O3' which means that the value of this cell is taken from cell O3 of Sheet3.
When trying to get the value of this cell using PhpSpreadSheet, I use the getCalculatedValue() function, the active sheet is Sheet2 - containing a cell with a link to a formula from another sheet. But this formula is not executed by the getCalculatedValue() method.
The question is - is there any way to run this kind of functions using PhpSpreadSheet?
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question