Does anyone know if the latest version of reader.php supports formula's in the Excel file?
I saw a note that says 2b (or 1.0) dont, as if to suggest versions later than 2b do. But does anyone know?
I have an Excel file that has one cell with a formula that concatenates strings from other cells, and currently it just sees this as a blank cell when it reads the Excel file from PHP.
I have written the code (in an older version) to support formulas returning strings.
You can see the code at: http://fourthlake.com/PERtext/dumpcode.php?selected_file=reader
Search for 'mmptext' to see the added portions of code.
1. the constants (e.g. Spreadsheet_Excel_Reader_Type_STRING) are now all uppercase (e.g. SPREADSHEET_EXCEL_READER_TYPE_STRING).
2. there is some debug code included that you will want to remove once the string formulas are working.