Changelog

All notable changes to this project will be documented in this file.

The format is based on Keep a Changelog and this project adheres to Semantic Versioning.

[Unreleased]

Added

Support for chart fill color - @CrazyBite #158
Support for read Hyperlink for xml - @GreatHumorist #223

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 issue#201

BREAKING CHANGE

Standardization of array keys used for style, see the migration guide.

[1.0.0-beta] - 2017-08-17

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

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.

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

Previous versions of PHPExcel

The changelog for the project when it was called PHPExcel is still available.