vendor/phpoffice/phpspreadsheet/CHANGELOG.md

   1 # Changelog
   2
   3 All notable changes to this project will be documented in this file.
   4
   5 The format is based on [Keep a Changelog](http://keepachangelog.com/)
   6 and this project adheres to [Semantic Versioning](http://semver.org/).
   7
   8 ## [1.2.1] - 2018-04-10
   9
  10 ### Fixed
  11
  12 - Plain text and richtext mixed in same cell can be read - [#442](https://github.com/PHPOffice/PhpSpreadsheet/issues/442)
  13
  14 ## [1.2.0] - 2018-03-04
  15
  16 ### Added
  17
  18 - HTML writer creates a generator meta tag - [#312](https://github.com/PHPOffice/PhpSpreadsheet/issues/312)
  19 - Support invalid zoom value in XLSX format - [#350](https://github.com/PHPOffice/PhpSpreadsheet/pull/350)
  20 - Support for `_xlfn.` prefixed functions and `ISFORMULA`, `MODE.SNGL`, `STDEV.S`, `STDEV.P` - [#390](https://github.com/PHPOffice/PhpSpreadsheet/pull/390)
  21
  22 ### Fixed
  23
  24 - Avoid potentially unsupported PSR-16 cache keys - [#354](https://github.com/PHPOffice/PhpSpreadsheet/issues/354)
  25 - Check for MIME type to know if CSV reader can read a file - [#167](https://github.com/PHPOffice/PhpSpreadsheet/issues/167)
  26 - Use proper € symbol for currency format - [#379](https://github.com/PHPOffice/PhpSpreadsheet/pull/379)
  27 - Read printing area correctly when skipping some sheets - [#371](https://github.com/PHPOffice/PhpSpreadsheet/issues/371)
  28 - Avoid incorrectly overwriting calculated value type - [#394](https://github.com/PHPOffice/PhpSpreadsheet/issues/394)
  29 - Select correct cell when calling freezePane - [#389](https://github.com/PHPOffice/PhpSpreadsheet/issues/389)
  30 - `setStrikethrough()` did not set the font - [#403](https://github.com/PHPOffice/PhpSpreadsheet/issues/403)
  31
  32 ## [1.1.0] - 2018-01-28
  33
  34 ### Added
  35
  36 - Support for PHP 7.2
  37 - Support cell comments in HTML writer and reader - [#308](https://github.com/PHPOffice/PhpSpreadsheet/issues/308)
  38 - Option to stop at a conditional styling, if it matches (only XLSX format) - [#292](https://github.com/PHPOffice/PhpSpreadsheet/pull/292)
  39 - Support for line width for data series when rendering Xlsx - [#329](https://github.com/PHPOffice/PhpSpreadsheet/pull/329)
  40
  41 ### Fixed
  42
  43 - Better auto-detection of CSV separators - [#305](https://github.com/PHPOffice/PhpSpreadsheet/issues/305)
  44 - Support for shape style ending with `;` - [#304](https://github.com/PHPOffice/PhpSpreadsheet/issues/304)
  45 - Freeze Panes takes wrong coordinates for XLSX - [#322](https://github.com/PHPOffice/PhpSpreadsheet/issues/322)
  46 - `COLUMNS` and `ROWS` functions crashed in some cases - [#336](https://github.com/PHPOffice/PhpSpreadsheet/issues/336)
  47 - Support XML file without styles - [#331](https://github.com/PHPOffice/PhpSpreadsheet/pull/331)
  48 - Cell coordinates which are already a range cause an exception [#319](https://github.com/PHPOffice/PhpSpreadsheet/issues/319)
  49
  50 ## [1.0.0] - 2017-12-25
  51
  52 ### Added
  53
  54 - Support to write merged cells in ODS format - [#287](https://github.com/PHPOffice/PhpSpreadsheet/issues/287)
  55 - Able to set the `topLeftCell` in freeze panes - [#261](https://github.com/PHPOffice/PhpSpreadsheet/pull/261)
  56 - Support `DateTimeImmutable` as cell value
  57 - Support migration of prefixed classes
  58
  59 ### Fixed
  60
  61 - Can read very small HTML files - [#194](https://github.com/PHPOffice/PhpSpreadsheet/issues/194)
  62 - Written DataValidation was corrupted - [#290](https://github.com/PHPOffice/PhpSpreadsheet/issues/290)
  63 - Date format compatible with both LibreOffice and Excel - [#298](https://github.com/PHPOffice/PhpSpreadsheet/issues/298)
  64
  65 ### BREAKING CHANGE
  66
  67 - Constant `TYPE_DOUGHTNUTCHART` is now `TYPE_DOUGHNUTCHART`.
  68
  69 ## [1.0.0-beta2] - 2017-11-26
  70
  71 ### Added
  72
  73 - Support for chart fill color - @CrazyBite [#158](https://github.com/PHPOffice/PhpSpreadsheet/pull/158)
  74 - Support for read Hyperlink for xml - @GreatHumorist [#223](https://github.com/PHPOffice/PhpSpreadsheet/pull/223)
  75 - Support for cell value validation according to data validation rules - @SailorMax [#257](https://github.com/PHPOffice/PhpSpreadsheet/pull/257)
  76 - Support for custom implementation, or configuration, of PDF libraries - @SailorMax [#266](https://github.com/PHPOffice/PhpSpreadsheet/pull/266)
  77
  78 ### Changed
  79
  80 - Merge data-validations to reduce written worksheet size - @billblume [#131](https://github.com/PHPOffice/PhpSpreadSheet/issues/131)
  81 - Throws exception if a XML file is invalid - @GreatHumorist [#222](https://github.com/PHPOffice/PhpSpreadsheet/pull/222)
  82 - Upgrade to mPDF 7.0+ - [#144](https://github.com/PHPOffice/PhpSpreadsheet/issues/144)
  83
  84 ### Fixed
  85
  86 - Control characters in cell values are automatically escaped - [#212](https://github.com/PHPOffice/PhpSpreadsheet/issues/212)
  87 - Prevent color changing when copy/pasting xls files written by PhpSpreadsheet to another file - @al-lala [#218](https://github.com/PHPOffice/PhpSpreadsheet/issues/218)
  88 - Add cell reference automatic when there is no cell reference('r' attribute) in Xlsx file. - @GreatHumorist [#225](https://github.com/PHPOffice/PhpSpreadsheet/pull/225) Refer to [issue#201](https://github.com/PHPOffice/PhpSpreadsheet/issues/201)
  89 - `Reader\Xlsx::getFromZipArchive()` function return false if the zip entry could not be located. - @anton-harvey [#268](https://github.com/PHPOffice/PhpSpreadsheet/pull/268)
  90
  91 ### BREAKING CHANGE
  92
  93 - Extracted coordinate method to dedicate class [migration guide](./docs/topics/migration-from-PHPExcel.md).
  94 - Column indexes are based on 1, see the [migration guide](./docs/topics/migration-from-PHPExcel.md).
  95 - Standardization of array keys used for style, see the [migration guide](./docs/topics/migration-from-PHPExcel.md).
  96 - Easier usage of PDF writers, and other custom readers and writers, see the [migration guide](./docs/topics/migration-from-PHPExcel.md).
  97 - Easier usage of chart renderers, see the [migration guide](./docs/topics/migration-from-PHPExcel.md).
  98 - Rename a few more classes to keep them in their related namespaces:
  99     - `CalcEngine` => `Calculation\Engine`
 100     - `PhpSpreadsheet\Calculation` => `PhpSpreadsheet\Calculation\Calculation`
 101     - `PhpSpreadsheet\Cell` => `PhpSpreadsheet\Cell\Cell`
 102     - `PhpSpreadsheet\Chart` => `PhpSpreadsheet\Chart\Chart`
 103     - `PhpSpreadsheet\RichText` => `PhpSpreadsheet\RichText\RichText`
 104     - `PhpSpreadsheet\Style` => `PhpSpreadsheet\Style\Style`
 105     - `PhpSpreadsheet\Worksheet` => `PhpSpreadsheet\Worksheet\Worksheet`
 106
 107 ## [1.0.0-beta] - 2017-08-17
 108
 109 ### Added
 110
 111 - Initial implementation of SUMIFS() function
 112 - Additional codepages
 113 - MemoryDrawing not working in HTML writer [#808](https://github.com/PHPOffice/PHPExcel/issues/808)
 114 - CSV Reader can auto-detect the separator used in file [#141](https://github.com/PHPOffice/PhpSpreadsheet/pull/141)
 115 - HTML Reader supports some basic inline styles [#180](https://github.com/PHPOffice/PhpSpreadsheet/pull/180)
 116
 117 ### Changed
 118
 119 - Start following [SemVer](http://semver.org) properly.
 120
 121 ### Fixed
 122
 123 - Fix to getCell() method when cell reference includes a worksheet reference - @MarkBaker
 124 - Ignore inlineStr type if formula element exists - @ncrypthic [#570](https://github.com/PHPOffice/PHPExcel/issues/570)
 125 - Excel 2007 Reader freezes because of conditional formatting - @rentalhost [#575](https://github.com/PHPOffice/PHPExcel/issues/575)
 126 - Readers will now parse files containing worksheet titles over 31 characters [#176](https://github.com/PHPOffice/PhpSpreadsheet/pull/176)
 127
 128 ### General
 129
 130 - Whitespace after toRichTextObject() - @MarkBaker [#554](https://github.com/PHPOffice/PHPExcel/issues/554)
 131 - Optimize vlookup() sort - @umpirsky [#548](https://github.com/PHPOffice/PHPExcel/issues/548)
 132 - c:max and c:min elements shall NOT be inside c:orientation elements - @vitalyrepin [#869](https://github.com/PHPOffice/PHPExcel/pull/869)
 133 - Implement actual timezone adjustment into PHPExcel_Shared_Date::PHPToExcel - @sim642 [#489](https://github.com/PHPOffice/PHPExcel/pull/489)
 134
 135 ### BREAKING CHANGE
 136
 137 - Introduction of namespaces for all classes, eg: `PHPExcel_Calculation_Functions` becomes `PhpOffice\PhpSpreadsheet\Calculation\Functions`
 138 - Some classes were renamed for clarity and/or consistency:
 139
 140 For a comprehensive list of all class changes, and a semi-automated migration path, read the [migration guide](./docs/topics/migration-from-PHPExcel.md).
 141
 142 - Dropped `PHPExcel_Calculation_Functions::VERSION()`. Composer or git should be used to know the version.
 143 - Dropped `PHPExcel_Settings::setPdfRenderer()` and `PHPExcel_Settings::setPdfRenderer()`. Composer should be used to autoload PDF libs.
 144 - Dropped support for HHVM
 145
 146 ## Previous versions of PHPExcel
 147
 148 The changelog for the project when it was called PHPExcel is [still available](./CHANGELOG.PHPExcel.md).