Problem with some formulas

Topics: Developer Forum, User Forum
Mar 26, 2014 at 6:04 PM
Edited Mar 26, 2014 at 6:35 PM
I'll be as detailed as possible to explain clearly the problem I'm facing.

First of all, the PHP version is 5.3.3 and PHPExcel is 1.8.

Some cells with logical operators returns an empty cell that breaks the final calculation, an example:

A specific cell has this value "=AJ11<AY16". Given that:
  1. AJ11 = 4000
  2. AY16 = "=AM16<=AJ13"
  3. AM16 = 100
  4. AJ13 = 3000
I debug this cell with the function that Mark Baker posted months ago that function named "testFormula" and it shows like that:
Formula Value is=AJ11<AY16
Expected Value is UNKNOWN
Parser Stack :-
Array
(
    [0] => Array
        (
            [type] => Cell Reference
            [value] => AJ11
            [reference] => AJ11
        )

    [1] => Array
        (
            [type] => Cell Reference
            [value] => AY16
            [reference] => AY16
        )

    [2] => Array
        (
            [type] => Binary Operator
            [value] => <
            [reference] => 
        )

)

Calculated Value is 
I'm going crazy with this problem because that calculations are crucial.