Tags: MayuriXx/PhpSpreadsheet
Tags
1.6.0 ### Added - Refactored Matrix Functions to use external Matrix library - Possibility to specify custom colors of values for pie and donut charts - [PHPOffice#768](PHPOffice#768) ### Fixed - Improve XLSX parsing speed if no readFilter is applied - [PHPOffice#772](PHPOffice#772) - Fix column names if read filter calls in XLSX reader skip columns - [PHPOffice#777](PHPOffice#777) - Fix LOOKUP function which was breaking on edge cases - [PHPOffice#796](PHPOffice#796) - Fix VLOOKUP with exact matches - [PHPOffice#809](PHPOffice#809) - Support COUNTIFS multiple arguments - [PHPOffice#830](PHPOffice#830) - Change `libxml_disable_entity_loader()` as shortly as possible - [PHPOffice#819](PHPOffice#819) - Improved memory usage and performance when loading large spreadsheets - [PHPOffice#822](PHPOffice#822) - Improved performance when loading large spreadsheets - [PHPOffice#825](PHPOffice#825) - Improved performance when loading large spreadsheets - [PHPOffice#824](PHPOffice#824) - Fix color from CSS when reading from HTML - [PHPOffice#831](PHPOffice#831) - Fix infinite loop when reading invalid ODS files - [PHPOffice#832](PHPOffice#832) - Fix time format for duration is incorrect - [PHPOffice#666](PHPOffice#666) - Fix iconv unsupported `//IGNORE//TRANSLIT` on IBM i - [PHPOffice#791](PHPOffice#791) ### Changed - `master` is the new default branch, `develop` does not exist anymore
1.5.0 ### Added - PHP 7.3 support - Add the DAYS() function - [PHPOffice#594](PHPOffice#594) ### Fixed - Sheet title can contain exclamation mark - [PHPOffice#325](PHPOffice#325) - Xls file cause the exception during open by Xls reader - [PHPOffice#402](PHPOffice#402) - Skip non numeric value in SUMIF - [PHPOffice#618](PHPOffice#618) - OFFSET should allow omitted height and width - [PHPOffice#561](PHPOffice#561) - Correctly determine delimiter when CSV contains line breaks inside enclosures - [PHPOffice#716](PHPOffice#716)
1.4.1 ### Fixed - Remove locale from formatting string - [PHPOffice#644](PHPOffice#644) - Allow iterators to go out of bounds with prev - [PHPOffice#587](PHPOffice#587) - Fix warning when reading xlsx without styles - [PHPOffice#631](PHPOffice#631) - Fix broken sample links on windows due to $baseDir having backslash - [PHPOffice#653](PHPOffice#653)
1.4.0 ### Added - Add excel function EXACT(value1, value2) support - [PHPOffice#595](PHPOffice#595) - Support workbook view attributes for Xlsx format - [PHPOffice#523](PHPOffice#523) - Read and write hyperlink for drawing image - [PHPOffice#490](PHPOffice#490) - Added calculation engine support for the new bitwise functions that were added in MS Excel 2013 - BITAND() Returns a Bitwise 'And' of two numbers - BITOR() Returns a Bitwise 'Or' of two number - BITXOR() Returns a Bitwise 'Exclusive Or' of two numbers - BITLSHIFT() Returns a number shifted left by a specified number of bits - BITRSHIFT() Returns a number shifted right by a specified number of bits - Added calculation engine support for other new functions that were added in MS Excel 2013 and MS Excel 2016 - Text Functions - CONCAT() Synonym for CONCATENATE() - NUMBERVALUE() Converts text to a number, in a locale-independent way - UNICHAR() Synonym for CHAR() in PHPSpreadsheet, which has always used UTF-8 internally - UNIORD() Synonym for ORD() in PHPSpreadsheet, which has always used UTF-8 internally - TEXTJOIN() Joins together two or more text strings, separated by a delimiter - Logical Functions - XOR() Returns a logical Exclusive Or of all arguments - Date/Time Functions - ISOWEEKNUM() Returns the ISO 8601 week number of the year for a given date - Lookup and Reference Functions - FORMULATEXT() Returns a formula as a string - Financial Functions - PDURATION() Calculates the number of periods required for an investment to reach a specified value - RRI() Calculates the interest rate required for an investment to grow to a specified future value - Engineering Functions - ERF.PRECISE() Returns the error function integrated between 0 and a supplied limit - ERFC.PRECISE() Synonym for ERFC - Math and Trig Functions - SEC() Returns the secant of an angle - SECH() Returns the hyperbolic secant of an angle - CSC() Returns the cosecant of an angle - CSCH() Returns the hyperbolic cosecant of an angle - COT() Returns the cotangent of an angle - COTH() Returns the hyperbolic cotangent of an angle - ACOT() Returns the cotangent of an angle - ACOTH() Returns the hyperbolic cotangent of an angle - Refactored Complex Engineering Functions to use external complex number library - Added calculation engine support for the new complex number functions that were added in MS Excel 2013 - IMCOSH() Returns the hyperbolic cosine of a complex number - IMCOT() Returns the cotangent of a complex number - IMCSC() Returns the cosecant of a complex number - IMCSCH() Returns the hyperbolic cosecant of a complex number - IMSEC() Returns the secant of a complex number - IMSECH() Returns the hyperbolic secant of a complex number - IMSINH() Returns the hyperbolic sine of a complex number - IMTAN() Returns the tangent of a complex number ### Fixed - Fix ISFORMULA() function to work with a cell reference to another worksheet - Xlsx reader crashed when reading a file with workbook protection - [PHPOffice#553](PHPOffice#553) - Cell formats with escaped spaces were causing incorrect date formatting - [PHPOffice#557](PHPOffice#557) - Could not open CSV file containing HTML fragment - [PHPOffice#564](PHPOffice#564) - Exclude the vendor folder in migration - [PHPOffice#481](PHPOffice#481) - Chained operations on cell ranges involving borders operated on last cell only [PHPOffice#428](PHPOffice#428) - Avoid memory exhaustion when cloning worksheet with a drawing [PHPOffice#437](PHPOffice#437) - Migration tool keep variables containing $PHPExcel untouched [PHPOffice#598](PHPOffice#598) - Rowspans/colspans were incorrect when adding worksheet using loadIntoExisting [PHPOffice#619](PHPOffice#619)
### Fixed - Ranges across Z and AA columns incorrectly threw an exception - [PHPOffice#545](PHPOffice#545)
1.3.0 ### Added - Support to read Xlsm templates with form elements, macros, printer settings, protected elements and back compatibility drawing, and save result without losing important elements of document - [PHPOffice#435](PHPOffice#435) - Expose sheet title maximum length as `Worksheet::SHEET_TITLE_MAXIMUM_LENGTH` - [PHPOffice#482](PHPOffice#482) - Allow escape character to be set in CSV reader – [PHPOffice#492](PHPOffice#492) ### Fixed - Subtotal 9 in a group that has other subtotals 9 exclude the totals of the other subtotals in the range - [PHPOffice#332](PHPOffice#332) - `Helper\Html` support UTF-8 HTML input - [PHPOffice#444](PHPOffice#444) - Xlsx loaded an extra empty comment for each real comment - [PHPOffice#375](PHPOffice#375) - Xlsx reader do not read rows and columns filtered out in readFilter at all - [PHPOffice#370](PHPOffice#370) - Make newer Excel versions properly recalculate formulas on document open - [PHPOffice#456](PHPOffice#456) - `Coordinate::extractAllCellReferencesInRange()` throws an exception for an invalid range – [PHPOffice#519](PHPOffice#519) - Fixed parsing of conditionals in COUNTIF functions - [PHPOffice#526](PHPOffice#526) - Corruption errors for saved Xlsx docs with frozen panes - [PHPOffice#532](PHPOffice#532)
1.2.1 ### Fixed - Plain text and richtext mixed in same cell can be read - [PHPOffice#442](PHPOffice#442)
1.2.0 ### Added - HTML writer creates a generator meta tag - [PHPOffice#312](PHPOffice#312) - Support invalid zoom value in XLSX format - [PHPOffice#350](PHPOffice#350) - Support for `_xlfn.` prefixed functions and `ISFORMULA`, `MODE.SNGL`, `STDEV.S`, `STDEV.P` - [PHPOffice#390](PHPOffice#390) ### Fixed - Avoid potentially unsupported PSR-16 cache keys - [PHPOffice#354](PHPOffice#354) - Check for MIME type to know if CSV reader can read a file - [PHPOffice#167](PHPOffice#167) - Use proper € symbol for currency format - [PHPOffice#379](PHPOffice#379) - Read printing area correctly when skipping some sheets - [PHPOffice#371](PHPOffice#371) - Avoid incorrectly overwriting calculated value type - [PHPOffice#394](PHPOffice#394) - Select correct cell when calling freezePane - [PHPOffice#389](PHPOffice#389) - `setStrikethrough()` did not set the font - [PHPOffice#403](PHPOffice#403)
PreviousNext