tag:github.com,2008:https://github.com/lid2000/PhpSpreadsheet/releases Tags from PhpSpreadsheet 2018-06-12T13:41:03Z tag:github.com,2008:Repository/139081267/1.3.1 2018-06-12T13:41:03Z 1.3.1: ### Fixed <p>### Fixed</p> <p>- Ranges across Z and AA columns incorrectly threw an exception - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/545">PHPOffice#545</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/545">PHPOffice#545</a>)</p> PowerKiKi tag:github.com,2008:Repository/139081267/1.3.0 2018-06-10T06:44:32Z 1.3.0 <p>1.3.0</p> <p>### Added</p> <p>- 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 - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/pull/435">PHPOffice#435</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/pull/435">PHPOffice#435</a>) <br />- Expose sheet title maximum length as `Worksheet::SHEET_TITLE_MAXIMUM_LENGTH` - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/pull/482">PHPOffice#482</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/pull/482">PHPOffice#482</a>) <br />- Allow escape character to be set in CSV reader – [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/492">PHPOffice#492</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/492">PHPOffice#492</a>)</p> <p>### Fixed</p> <p>- Subtotal 9 in a group that has other subtotals 9 exclude the totals of the other subtotals in the range - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/332">PHPOffice#332</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/332">PHPOffice#332</a>) <br />- `Helper\Html` support UTF-8 HTML input - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/444">PHPOffice#444</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/444">PHPOffice#444</a>) <br />- Xlsx loaded an extra empty comment for each real comment - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/375">PHPOffice#375</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/375">PHPOffice#375</a>) <br />- Xlsx reader do not read rows and columns filtered out in readFilter at all - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/370">PHPOffice#370</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/370">PHPOffice#370</a>) <br />- Make newer Excel versions properly recalculate formulas on document open - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/456">PHPOffice#456</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/456">PHPOffice#456</a>) <br />- `Coordinate::extractAllCellReferencesInRange()` throws an exception for an invalid range – [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/519">PHPOffice#519</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/519">PHPOffice#519</a>) <br />- Fixed parsing of conditionals in COUNTIF functions - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/526">PHPOffice#526</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/526">PHPOffice#526</a>) <br />- Corruption errors for saved Xlsx docs with frozen panes - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/532">PHPOffice#532</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/532">PHPOffice#532</a>)</p> PowerKiKi tag:github.com,2008:Repository/139081267/1.2.1 2018-04-10T03:59:54Z 1.2.1 <p>1.2.1</p> <p>### Fixed</p> <p>- Plain text and richtext mixed in same cell can be read - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/442">PHPOffice#442</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/442">PHPOffice#442</a>)</p> PowerKiKi tag:github.com,2008:Repository/139081267/1.2.0 2018-03-04T20:45:09Z 1.2.0 <p>1.2.0</p> <p>### Added</p> <p>- HTML writer creates a generator meta tag - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/312">PHPOffice#312</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/312">PHPOffice#312</a>) <br />- Support invalid zoom value in XLSX format - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/pull/350">PHPOffice#350</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/pull/350">PHPOffice#350</a>) <br />- Support for `_xlfn.` prefixed functions and `ISFORMULA`, `MODE.SNGL`, `STDEV.S`, `STDEV.P` - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/pull/390">PHPOffice#390</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/pull/390">PHPOffice#390</a>)</p> <p>### Fixed</p> <p>- Avoid potentially unsupported PSR-16 cache keys - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/354">PHPOffice#354</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/354">PHPOffice#354</a>) <br />- Check for MIME type to know if CSV reader can read a file - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/167">PHPOffice#167</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/167">PHPOffice#167</a>) <br />- Use proper € symbol for currency format - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/pull/379">PHPOffice#379</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/pull/379">PHPOffice#379</a>) <br />- Read printing area correctly when skipping some sheets - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/371">PHPOffice#371</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/371">PHPOffice#371</a>) <br />- Avoid incorrectly overwriting calculated value type - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/pull/394">PHPOffice#394</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/pull/394">PHPOffice#394</a>) <br />- Select correct cell when calling freezePane - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/389">PHPOffice#389</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/389">PHPOffice#389</a>) <br />- `setStrikethrough()` did not set the font - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/403">PHPOffice#403</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/403">PHPOffice#403</a>)</p> PowerKiKi tag:github.com,2008:Repository/139081267/1.1.0 2018-01-28T12:38:00Z 1.1.0 <p>1.1.0</p> <p>- Support for PHP 7.2 <br />- Support cell comments in HTML writer and reader - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/308">PHPOffice#308</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/308">PHPOffice#308</a>) <br />- Option to stop at a conditional styling, if it matches (only XLSX format) - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/pull/292">PHPOffice#292</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/pull/292">PHPOffice#292</a>) <br />- Support for line width for data series when rendering Xlsx - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/pull/329">PHPOffice#329</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/pull/329">PHPOffice#329</a>)</p> <p>- Better auto-detection of CSV separators - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/305">PHPOffice#305</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/305">PHPOffice#305</a>) <br />- Support for shape style ending with `;` - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/304">PHPOffice#304</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/304">PHPOffice#304</a>) <br />- Freeze Panes takes wrong coordinates for XLSX - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/322">PHPOffice#322</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/322">PHPOffice#322</a>) <br />- `COLUMNS` and `ROWS` functions crashed in some cases - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/336">PHPOffice#336</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/336">PHPOffice#336</a>) <br />- Support XML file without styles - [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/pull/331">PHPOffice#331</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/pull/331">PHPOffice#331</a>) <br />- Cell coordinates which are already a range cause an exception [<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/319">PHPOffice#319</a>](<a class="issue-link js-issue-link" href="https://github.com/PHPOffice/PhpSpreadsheet/issues/319">PHPOffice#319</a>)</p> PowerKiKi tag:github.com,2008:Repository/139081267/1.0.0 2017-12-25T01:55:36Z 1.0.0 <p>1.0.0</p> <p>``` <br /> * , <br /> _/^\_ <br /> &lt; &gt; <br /> * /.-.\ * <br /> * `/&amp;\` * <br /> ,@.*;@, <br /> /_o.I %_\ * <br /> * (`'--:o(_@; <br /> /`;--.,__ `') * <br /> ;@`o % O,*`'`&amp;\ <br /> * (`'--)_@ ;o %'()\ * <br /> /`;--._`''--._O'@; <br /> /&amp;*,()~o`;-.,_ `""`) <br /> * /`,@ ;+&amp; () o*`;-';\ <br /> (`""--.,_0 +% @' &amp;()\ <br /> /-.,_ ``''--....-'`) * <br /> * /@%;o`:;'--,.__ __.'\ <br /> ;*,&amp;(); @ % &amp;^;~`"`o;@(); * <br /> /(); o^~; &amp; ().o@*&amp;`;&amp;%O\ <br /> `"="==""==,,,.,="=="==="` <br /> __.----.(\-''#####---...___...-----._ <br /> '` \)_`"""""` <br /> .--' ') <br /> o( )_-\ <br /> `"""` ` <br />```</p> PowerKiKi tag:github.com,2008:Repository/139081267/1.0.0-beta2 2017-11-26T06:47:49Z 1.0.0-beta2 PowerKiKi tag:github.com,2008:Repository/139081267/1.0.0-beta 2017-08-17T13:18:43Z 1.0.0-beta PowerKiKi