P
P
Pavel Novikov2018-09-25 12:07:49
phpspreadsheet
Pavel Novikov, 2018-09-25 12:07:49

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 question

Ask a Question

731 491 924 answers to any question