All Versions
39
Latest Version
Avg Release Cycle
51 days
Latest Release
808 days ago
Changelog History
Page 2
Changelog History
Page 2
-
v1.17.1 Changes
March 01, 2021โ Added
- Implementation of the Excel
AVERAGEIFS()
functions as part of a restructuring of Database functions and Conditional Statistical functions. - ๐ Support for date values and percentages in query parameters for Database functions, and the IF expressions in functions like COUNTIF() and AVERAGEIF(). #1875
- ๐ Support for booleans, and for wildcard text search in query parameters for Database functions, and the IF expressions in functions like COUNTIF() and AVERAGEIF(). #1876
- Implemented DataBar for conditional formatting in Xlsx, providing read/write and creation of (type, value, direction, fills, border, axis position, color settings) as DataBar options in Excel. #1754
- Alignment for ODS Writer #1796
- Basic implementation of the PERMUTATIONA() Statistical Function
๐ Changed
- Formula functions that previously called PHP functions directly are now processed through the Excel Functions classes; resolving issues with PHP8 stricter typing. #1789
The following MathTrig functions are affected:
ABS()
,ACOS()
,ACOSH()
,ASIN()
,ASINH()
,ATAN()
,ATANH()
,COS()
,COSH()
,DEGREES()
(rad2deg),EXP()
,LN()
(log),LOG10()
,RADIANS()
(deg2rad),SIN()
,SINH()
,SQRT()
,TAN()
,TANH()
.One TextData function is also affected:
REPT()
(str_repeat).- ๐
formatAsDate
correctly matches language metadata, reverting c55272e - Formulae that previously crashed on sub function call returning excel error value now return said value.
The following functions are affected
CUMPRINC()
,CUMIPMT()
,AMORLINC()
,AMORDEGRC()
. - Adapt some function error return value to match excel's error.
The following functions are affected
PPMT()
,IPMT()
.
๐ Deprecated
- Calling many of the Excel formula functions directly rather than through the Calculation Engine.
The logic for these Functions is now being moved out of the categorised
Database
,DateTime
,Engineering
,Financial
,Logical
,LookupRef
,MathTrig
,Statistical
,TextData
andWeb
classes into small, dedicated classes for individual functions or related groups of functions.This makes the logic in these classes easier to maintain; and will reduce the memory footprint required to execute formulae when calling these functions.
โ Removed
- Nothing.
๐ Fixed
- Avoid Duplicate Titles When Reading Multiple HTML Files.Issue #1823 PR #1829
- ๐ Fixed issue with Worksheet's
getCell()
method when trying to get a cell by defined name. #1858 - ๐ Fix possible endless loop in NumberFormat Masks #1792
- ๐ Fix problem resulting from literal dot inside quotes in number format masks. PR #1830
- Resolve Google Sheets Xlsx charts issue. Google Sheets uses oneCellAnchor positioning and does not include *Cache values in the exported Xlsx. PR #1761
- ๐ Fix for Xlsx Chart axis titles mapping to correct X or Y axis label when only one is present. PR #1760
- ๐ Fix For Null Exception on ODS Read of Page Settings. #1772
- ๐ Fix Xlsx reader overriding manually set number format with builtin number format. PR #1805
- ๐ Fix Xlsx reader cell alignment. PR #1710
- ๐ Fix for not yet implemented data-types in Open Document writer Issue #1674
- ๐ Fix XLSX reader when having a corrupt numeric cell data type PR #1664
- ๐ Fix on
CUMPRINC()
,CUMIPMT()
,AMORLINC()
,AMORDEGRC()
usage. When those functions called one ofYEARFRAC()
,PPMT()
,IPMT()
and they would get back an error value (represented as a string), trying to use numeral operands (+
,/
,-
,*
) on said return value and a number (float or
int`) would fail.
- Implementation of the Excel
-
v1.16.0 Changes
December 31, 2020โ Added
- CSV Reader - Best Guess for Encoding, and Handle Null-string Escape #1647
๐ Changed
- โก๏ธ Updated the CONVERT() function to support all current MS Excel categories and Units of Measure.
๐ Deprecated
- ๐ All Excel Function implementations in
Calculation\Database
,Calculation\DateTime
,Calculation\Engineering
,Calculation\Financial
,Calculation\Logical
,Calculation\LookupRef
,Calculation\MathTrig
,Calculation\Statistical
,Calculation\TextData
andCalculation\Web
have been moved to dedicated classes for individual functions or groups of related functions. See the docblocks against all the deprecated methods for details of the new methods to call instead. At some point, these old classes will be deleted.
โ Removed
- Nothing.
๐ Fixed
- ๐ Fixed issue with absolute path in worksheets' Target. PR #1769
- ๐ Fix for Xls Reader when SST has a bad length #1592
- Resolve Xlsx loader issue whe hyperlinks don't have a destination
- ๐จ Resolve issues when printer settings resources IDs clash with drawing IDs
- Resolve issue with SLK long filenames #1612
- ROUNDUP and ROUNDDOWN return incorrect results for values of 0 #1627
- ๐ Apply Column and Row Styles to Existing Cells #1712 PR #1721
- Resolve issues with defined names where worksheet doesn't exist (#1686)[https://github.com/PHPOffice/PhpSpreadsheet/issues/1686] and #1723 - PR #1742
- ๐ Fix for issue #1735 Incorrect activeSheetIndex after RemoveSheetByIndex - PR #1743
- Ensure that the list of shared formulae is maintained when an xlsx file is chunked with readFilterIssue #169.
- ๐ Fix for notice during accessing "cached magnification factor" offset #1354
- ๐ Fix compatibility with ext-gd on php 8
๐ Security Fix (CVE-2020-7776)
- Prevent XSS through cell comments in the HTML Writer.
-
v1.15.0 Changes
October 11, 2020โ Added
- ๐ Implemented Page Order for Xlsx and Xls Readers, and provided Page Settings (Orientation, Scale, Horizontal/Vertical Centering, Page Order, Margins) support for Ods, Gnumeric and Xls Readers #1559
- Implementation of the Excel
LOGNORM.DIST()
,NORM.S.DIST()
,GAMMA()
andGAUSS()
functions. #1588 - Named formula implementation, and improved handling of Defined Names generally #1535
- Defined Names are now case-insensitive
- Distinction between named ranges and named formulae
- Correct handling of union and intersection operators in named ranges
- Correct evaluation of named range operators in calculations
- fix resolution of relative named range values in the calculation engine; previously all named range values had been treated as absolute.
- Calculation support for named formulae
- Support for nested ranges and formulae (named ranges and formulae that reference other named ranges/formulae) in calculations
- Introduction of a helper to convert address formats between R1C1 and A1 (and the reverse)
- Proper support for both named ranges and named formulae in all appropriate Readers
- Xlsx (Previously only simple named ranges were supported)
- Xls (Previously only simple named ranges were supported)
- Gnumeric (Previously neither named ranges nor formulae were supported)
- Ods (Previously neither named ranges nor formulae were supported)
- Xml (Previously neither named ranges nor formulae were supported)
- Proper support for named ranges and named formulae in all appropriate Writers
- Xlsx (Previously only simple named ranges were supported)
- Xls (Previously neither named ranges nor formulae were supported) - Still not supported, but some parser issues resolved that previously failed to differentiate between a defined name and a function name
- Ods (Previously neither named ranges nor formulae were supported)
- ๐ Support for PHP 8.0
๐ Changed
- ๐ Improve Coverage for ODS Reader #1545
- Named formula implementation, and improved handling of Defined Names generally #1535
- ๐ fix resolution of relative named range values in the calculation engine; previously all named range values had been treated as absolute.
- โฌ๏ธ Drop $this->spreadSheet null check from Xlsx Writer #1646
- Improving Coverage for Excel2003 XML Reader #1557
๐ Deprecated
- IMPORTANT NOTE: This Introduces a BC break in the handling of named ranges. Previously, a named range cell reference of
B2
would be treated identically to a named range cell reference of$B2
orB$2
or$B$2
because the calculation engine treated then all as absolute references. These changes "fix" that, so the calculation engine now handles relative references in named ranges correctly.
This change that resolves previously incorrect behaviour in the calculation may affect users who have dynamically defined named ranges using relative references when they should have used absolute references.
โ Removed
- Nothing.
๐ Fixed
-
v1.14.1 Changes
July 19, 2020 -
v1.14.0 Changes
June 29, 2020โ Added
- โ Add support for IFS() logical function #1442
- โ Add Cell Address Helper to provide conversions between the R1C1 and A1 address formats #1558
- โ Add ability to edit Html/Pdf before saving #1499
- โ Add ability to set codepage explicitly for BIFF5 #1018
- โ Added support for the WEBSERVICE function #1409
๐ Fixed
- Resolve evaluation of utf-8 named ranges in calculation engine #1522
- ๐ Fix HLOOKUP on single row #1512
- ๐ Fix MATCH when comparing different numeric types #1521
- ๐ Fix exact MATCH on ranges with empty cells #1520
- ๐ Fix for Issue #1516 (Cloning worksheet makes corrupted Xlsx) #1530
- ๐ Fix For Issue #1509 (Can not set empty enclosure for CSV) #1518
- ๐ Fix for Issue #1505 (TypeError : Argument 4 passed to PhpOffice\PhpSpreadsheet\Writer\Xlsx\Worksheet::writeAttributeIf() must be of the type string) #1525
- ๐ Fix for Issue #1495 (Sheet index being changed when multiple sheets are used in formula) [#1500]((https://github.com/PHPOffice/PhpSpreadsheet/pull/1500))
- ๐ Fix for Issue #1533 (A reference to a cell containing a string starting with "#" leads to errors in the generated xlsx.) #1534
- Xls Writer - Correct Timestamp Bug #1493
- Don't ouput row and columns without any cells in HTML writer #1235
-
v1.13.0 Changes
May 31, 2020โ Added
- ๐ Support writing to streams in all writers #1292
- ๐ Support CSV files with data wrapping a lot of lines #1468
- ๐ Support protection of worksheet by a specific hash algorithm #1485
๐ Fixed
- Fix Chart samples by updating chart parameter from 0 to DataSeries::EMPTY_AS_GAP #1448
- ๐ Fix return type in docblock for the Cells::get() #1398
- ๐ Fix RATE, PRICE, XIRR, and XNPV Functions #1456
- ๐พ Save Excel 2010+ functions properly in XLSX #1461
- Several improvements in HTML writer #1464
- ๐ Fix incorrect behaviour when saving XLSX file with drawings #1462,
- ๐ Fix Crash while trying setting a cell the value "123456\n" #1476
- ๐ Improved DATEDIF() function and reduced errors for Y and YM units #1466
- ๐ Stricter typing for mergeCells #1494
๐ Changed
- โฌ๏ธ Drop support for PHP 7.1, according to https://phpspreadsheet.readthedocs.io/en/latest/#php-version-support
- โฌ๏ธ Drop partial migration tool in favor of complete migration via RectorPHP #1445
- ๐ฆ Limit composer package to
src/
#1424
-
v1.12.0 Changes
April 27, 2020โ Added
- ๐ Improved the ARABIC function to also handle short-hand roman numerals
- โ Added support for the FLOOR.MATH and FLOOR.PRECISE functions #1351
๐ Fixed
- ๐ Fix ROUNDUP and ROUNDDOWN for floating-point rounding error #1404
- ๐ Fix ROUNDUP and ROUNDDOWN for negative number #1417
- ๐ Fix loading styles from vmlDrawings when containing whitespace #1347
- ๐ Fix incorrect behavior when removing last row #1365
- MATCH with a static array should return the position of the found value based on the values submitted #1332
- ๐ Fix Xlsx Reader's handling of undefined fill color #1353
-
v1.11.0 Changes
March 02, 2020โ Added
- โ Added support for the BASE function
- โ Added support for the ARABIC function
- ๐ Conditionals - Extend Support for (NOT)CONTAINSBLANKS #1278
๐ Fixed
- ๐ Handle Error in Formula Processing Better for Xls #1267
- ๐ Handle ConditionalStyle NumberFormat When Reading Xlsx File #1296
- ๐ Fix Xlsx Writer's handling of decimal commas #1282
- ๐ Fix for issue by removing test code mistakenly left in #1328
- ๐ Fix for Xls writer wrong selected cells and active sheet #1256
- ๐ Fix active cell when freeze pane is used #1323
- ๐ Fix XLSX file loading with autofilter containing '$' #1326
- PHPDoc - Use
@return $this
for fluent methods #1362
-
v1.10.1 Changes
December 02, 2019๐ Changed
- PHP 7.4 compatibility
๐ Fixed
- FLOOR() function accept negative number and negative significance #1245
- ๐ Correct column style even when using rowspan #1249
- Do not confuse defined names and cell refs #1263
- XLSX reader/writer keep decimal for floats with a zero decimal part #1262
- ODS writer prevent invalid numeric value if locale decimal separator is comma #1268
- Xlsx writer actually writes plotVisOnly and dispBlanksAs from chart properties #1266
-
v1.10.0 Changes
November 18, 2019๐ 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