circular reference in formula = infinite loop

Topics: Developer Forum
Sep 8, 2014 at 11:52 PM
Edited Sep 9, 2014 at 12:31 AM
Guys, first of all, thank you so much for the PHPExcel library. We are using it for one of our clients, on a project that would otherwise have been impossible.

It's been working really well; however, I am running into an infinite loop whenever I encounter a circular reference. I have managed to debug this to some extent, but my resulting value is not the same as in MS Excel.

Could someone please explain to me the algorithm that is used for calculating circular formulas? Is it supposed to be the same algo as MS Excel?

I very much appreciate some assistance with understanding the code. I will be happy to submit my code so far, as well as the fix, once I get it working.

I am using PHPExcel 1.8.0

Thanks in advance for your help