PhpSpreadsheet v1.10.0 Release Notes
Release Date: 2019-11-18 // over 4 years ago-
🔄 Changed
- 🔄 Change license from LGPL 2.1 to MIT #140
➕ Added
- Implementation of IFNA() logical function
- 👌 Support "showZeros" worksheet option to change how Excel shows and handles "null" values returned from a calculation
- 👍 Allow HTML Reader to accept HTML as a string into an existing spreadsheet #1212
🛠 Fixed
- IF implementation properly handles the value
#N/A#1165 - 📜 Formula Parser: Wrong line count for stuff like "MyOtherSheet!A:D" #1215
- Call garbage collector after removing a column to prevent stale cached values
- 🚚 Trying to remove a column that doesn't exist deletes the latest column
- Keep big integer as integer instead of lossely casting to float #874
- 🛠 Fix branch pruning handling of non boolean conditions #1167
- 🛠 Fix ODS Reader when no DC namespace are defined #1182
- 🛠 Fixed Functions->ifCondition for allowing <> and empty condition #1206
- Validate XIRR inputs and return correct error values #1120
- 👍 Allow to read xlsx files with exotic workbook names like "workbook2.xml" #1183