All Versions
39
Latest Version
Avg Release Cycle
51 days
Latest Release
1071 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