Case-sensitivity with string equalities about phpexcel HOT 5 CLOSED

I confirm the issue still exists and can be summed up like so:

Interestingly LibreOffice 4.0 seems to implement both modes. When creating a new document, it will be case sensitive (default behavior), but if you save it as .xlsx and re-open it, it will switch to case insensitive (Excel compatible behavior). The documentation does not mention anything though: https://help.libreoffice.org/Calc/Operators_in_Calc

My opinion is PHPExcel is not called PHPLibreOffice for a reason, and as much as it pains me to say it, I would implement Excel behavior as closely as possible.

I will have a look at PHPExcel source code and see if I can submit a PR...

from phpexcel.

I should add that Google Drive spreadsheets, behave the same way as Excel. One more argument in favor of Excel behavior for what it is worth...

from phpexcel.

I updated my original Pull Request, and it now properly support compatibility mode setting to use case sensitive for OpenOffice and case insensitive for everything else.

On a side note, I noticed PHPExcel unit tests would need a lot of love to fix them all. If I ever happen to do some of that work, on which branch should it be ? develop or develop_2.0.0 ?

from phpexcel.

The unit tests certainly need a lot of love and attention, and have been largely neglected for a long time, and I'm ore than happy to see some new work in that area. The develop_2.0.0 branch is dead for the moment; I've refactored a lot of the code to use a an object factory, and moved some of the core components to a repository common for all PHPOffice applications; and am rewriting the calculation engine significantly, and those changes won't merge cleanly with any existing branch. So any additions should be against the develop branch.

from phpexcel.

Thank you for the clarification. I was indeed wondering how you planned to
merge those very heavy changes.

from phpexcel.