1.10.0
版本发布时间: 2019-11-18 19:34:53
PHPOffice/PhpSpreadsheet最新发布版本:2.2.2(2024-08-08 10:45:26)
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