IF Problem

Aug 31, 2009 at 4:01 PM

Version: 1.7.0 Production

I have this formula:
=IF(C2="MT";0,51;IF(C2="AT";0,29;0,108))

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

It's wrong. Is a bug?

Developer
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?

http://phpexcel.codeplex.com/WorkItem/View.aspx?WorkItemId=10563

Coordinator
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

Awesome!!