IF Problem

Aug 31, 2009 at 4:01 PM

Version: 1.7.0 Production

I have this formula:

If I put MT in C2 then with ->getCalculatedValue I have 0,108

It's wrong. Is a bug?

Aug 31, 2009 at 4:46 PM

Hi, Jazzo. To me it looks like a bug. I posted it in the issue tracker. Let's see if MarkBaker has some solution?


Aug 31, 2009 at 5:51 PM

You're right, it is a bug. The _executeBinaryComparisonOperation() method in PHPExcel_Calculation wasn't handling string comparisons correctly because it wasn't stripping the quotes from the string.

Fixed and updated in SVN.

Aug 31, 2009 at 5:59 PM