All Versions
39
Latest Version
Avg Release Cycle
51 days
Latest Release
636 days ago

Changelog History
Page 4

  • v1.4.0 Changes

    August 06, 2018

    โž• Added

    • โž• Add excel function EXACT(value1, value2) support #595
    • ๐Ÿ‘Œ Support workbook view attributes for Xlsx format #523
    • Read and write hyperlink for drawing image #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 #553
    • Cell formats with escaped spaces were causing incorrect date formatting #557
    • Could not open CSV file containing HTML fragment #564
    • Exclude the vendor folder in migration #481
    • Chained operations on cell ranges involving borders operated on last cell only #428
    • Avoid memory exhaustion when cloning worksheet with a drawing #437
    • Migration tool keep variables containing $PHPExcel untouched #598
    • Rowspans/colspans were incorrect when adding worksheet using loadIntoExisting #619
  • v1.3.1 Changes

    June 12, 2018

    ๐Ÿ›  Fixed

    • ๐Ÿ‘ป Ranges across Z and AA columns incorrectly threw an exception #545
  • v1.3.0 Changes

    June 10, 2018

    โž• 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 #435
    • Expose sheet title maximum length as Worksheet::SHEET_TITLE_MAXIMUM_LENGTH #482
    • ๐Ÿ‘ Allow escape character to be set in CSV reader #492

    ๐Ÿ›  Fixed

    • Subtotal 9 in a group that has other subtotals 9 exclude the totals of the other subtotals in the range #332
    • ๐Ÿ‘ Helper\Html support UTF-8 HTML input #444
    • Xlsx loaded an extra empty comment for each real comment #375
    • Xlsx reader do not read rows and columns filtered out in readFilter at all #370
    • ๐Ÿ‘‰ Make newer Excel versions properly recalculate formulas on document open #456
    • ๐Ÿ‘ป Coordinate::extractAllCellReferencesInRange() throws an exception for an invalid range #519
    • ๐Ÿ›  Fixed parsing of conditionals in COUNTIF functions #526
    • ๐Ÿ“„ Corruption errors for saved Xlsx docs with frozen panes #532
  • v1.2.1 Changes

    April 10, 2018

    ๐Ÿ›  Fixed

    • Plain text and richtext mixed in same cell can be read #442
  • v1.2.0 Changes

    March 04, 2018

    โž• Added

    • HTML writer creates a generator meta tag #312
    • ๐Ÿ‘Œ Support invalid zoom value in XLSX format #350
    • ๐Ÿ‘Œ Support for _xlfn. prefixed functions and ISFORMULA, MODE.SNGL, STDEV.S, STDEV.P #390

    ๐Ÿ›  Fixed

    • ๐Ÿ‘ Avoid potentially unsupported PSR-16 cache keys #354
    • Check for MIME type to know if CSV reader can read a file #167
    • ๐Ÿ‘‰ Use proper โ‚ฌ symbol for currency format #379
    • ๐Ÿ–จ Read printing area correctly when skipping some sheets #371
    • Avoid incorrectly overwriting calculated value type #394
    • Select correct cell when calling freezePane #389
    • setStrikethrough() did not set the font #403
  • v1.1.0 Changes

    January 28, 2018

    โž• Added

    • ๐Ÿ‘Œ Support for PHP 7.2
    • ๐Ÿ‘Œ Support cell comments in HTML writer and reader #308
    • Option to stop at a conditional styling, if it matches (only XLSX format) #292
    • ๐Ÿ‘Œ Support for line width for data series when rendering Xlsx #329

    ๐Ÿ›  Fixed

    • ๐Ÿ‘ Better auto-detection of CSV separators #305
    • ๐Ÿ‘Œ Support for shape style ending with ; #304
    • Freeze Panes takes wrong coordinates for XLSX #322
    • COLUMNS and ROWS functions crashed in some cases #336
    • ๐Ÿ‘Œ Support XML file without styles #331
    • ๐Ÿ‘ป Cell coordinates which are already a range cause an exception #319
  • v1.0.0 Changes

    December 25, 2017

    โž• Added

    • ๐Ÿ‘Œ Support to write merged cells in ODS format #287
    • Able to set the topLeftCell in freeze panes #261
    • ๐Ÿ‘Œ Support DateTimeImmutable as cell value
    • ๐Ÿ‘Œ Support migration of prefixed classes

    ๐Ÿ›  Fixed

    • Can read very small HTML files #194
    • Written DataValidation was corrupted #290
    • Date format compatible with both LibreOffice and Excel #298

    ๐Ÿ’ฅ BREAKING CHANGE

    • Constant TYPE_DOUGHTNUTCHART is now TYPE_DOUGHNUTCHART.
  • v1.0.0-beta2 Changes

    November 26, 2017

    โž• Added

    • ๐Ÿ‘Œ Support for chart fill color - @CrazyBite #158
    • ๐Ÿ‘Œ Support for read Hyperlink for xml - @GreatHumorist #223
    • ๐Ÿ‘Œ Support for cell value validation according to data validation rules - @SailorMax #257
    • ๐Ÿ‘Œ Support for custom implementation, or configuration, of PDF libraries - @SailorMax #266

    ๐Ÿ”„ Changed

    • ๐Ÿ”€ Merge data-validations to reduce written worksheet size - @billblume #131
    • ๐Ÿ‘ป Throws exception if a XML file is invalid - @GreatHumorist #222
    • โฌ†๏ธ Upgrade to mPDF 7.0+ #144

    ๐Ÿ›  Fixed

    • Control characters in cell values are automatically escaped #212
    • Prevent color changing when copy/pasting xls files written by PhpSpreadsheet to another file - @al-lala #218
    • โž• Add cell reference automatic when there is no cell reference('r' attribute) in Xlsx file. - @GreatHumorist #225 Refer to #201
    • Reader\Xlsx::getFromZipArchive() function return false if the zip entry could not be located. - @anton-harvey #268

    ๐Ÿ’ฅ BREAKING CHANGE

    • ๐Ÿ“„ Extracted coordinate method to dedicate class [migration guide](./docs/topics/migration-from-PHPExcel.md).
    • ๐Ÿ‘€ Column indexes are based on 1, see the [migration guide](./docs/topics/migration-from-PHPExcel.md).
    • ๐Ÿ’… Standardization of array keys used for style, see the [migration guide](./docs/topics/migration-from-PHPExcel.md).
    • ๐Ÿ‘€ Easier usage of PDF writers, and other custom readers and writers, see the [migration guide](./docs/topics/migration-from-PHPExcel.md).
    • ๐Ÿ‘€ Easier usage of chart renderers, see the [migration guide](./docs/topics/migration-from-PHPExcel.md).
    • ๐Ÿ“‡ Rename a few more classes to keep them in their related namespaces:
      • CalcEngine => Calculation\Engine
      • PhpSpreadsheet\Calculation => PhpSpreadsheet\Calculation\Calculation
      • PhpSpreadsheet\Cell => PhpSpreadsheet\Cell\Cell
      • PhpSpreadsheet\Chart => PhpSpreadsheet\Chart\Chart
      • PhpSpreadsheet\RichText => PhpSpreadsheet\RichText\RichText
      • PhpSpreadsheet\Style => PhpSpreadsheet\Style\Style
      • PhpSpreadsheet\Worksheet => PhpSpreadsheet\Worksheet\Worksheet
  • v1.0.0-beta Changes

    August 17, 2017

    โž• Added

    • ๐ŸŽ‰ Initial implementation of SUMIFS() function
    • โž• Additional codepages
    • MemoryDrawing not working in HTML writer #808
    • CSV Reader can auto-detect the separator used in file #141
    • ๐Ÿ’… HTML Reader supports some basic inline styles #180

    ๐Ÿ”„ Changed

    • Start following SemVer properly.

    ๐Ÿ›  Fixed

    • ๐Ÿ›  Fix to getCell() method when cell reference includes a worksheet reference - @MarkBaker
    • Ignore inlineStr type if formula element exists - @ncrypthic #570
    • Excel 2007 Reader freezes because of conditional formatting - @rentalhost #575
    • ๐Ÿ“œ Readers will now parse files containing worksheet titles over 31 characters #176
    • Fixed PHP8 deprecation warning for libxml_disable_entity_loader() #1625

    General

    • Whitespace after toRichTextObject() - @MarkBaker #554
    • โšก๏ธ Optimize vlookup() sort - @umpirsky #548
    • c:max and c:min elements shall NOT be inside c:orientation elements - @vitalyrepin #869
    • Implement actual timezone adjustment into PHPExcel_Shared_Date::PHPToExcel - @sim642 #489

    ๐Ÿ’ฅ BREAKING CHANGE

    • Introduction of namespaces for all classes, eg: PHPExcel_Calculation_Functions becomes PhpOffice\PhpSpreadsheet\Calculation\Functions
    • Some classes were renamed for clarity and/or consistency:

    ๐Ÿ“„ For a comprehensive list of all class changes, and a semi-automated migration path, read the [migration guide](./docs/topics/migration-from-PHPExcel.md).

    • Dropped PHPExcel_Calculation_Functions::VERSION(). Composer or git should be used to know the version.
    • Dropped PHPExcel_Settings::setPdfRenderer() and PHPExcel_Settings::setPdfRenderer(). Composer should be used to autoload PDF libs.
    • โฌ‡๏ธ Dropped support for HHVM