PHPExcel 1.6.0 goes into production



Maarten Balliauw has a Valentine’s Day gift to the PHP community: the production release of PHPExcel 1.6.0 is available today. This release of the PHP library for SpreadsheetML documents includes an improved calculation engine as well as support for named ranges and worksheet references. Here’s the list of changes you’ll find in version 1.6.0:



  • General: (MB) Work item 3156 – Use PHPExcel datatypes in formula calculation

  • Feature: (MB) Work item 5019 – Center on page when printing

  • Feature: (MB) Work item 5099 – Hyperlink to other spreadsheet

  • Feature: (MB) Work item 5104 – Set the print area of a worksheet

  • Feature: (MB) Work item 5118 – Read “definedNames” property of worksheet

  • Feature: (MB) Work item 5338 – Set default style for all cells

  • Feature: (MB) Work item 4216 – Named Ranges

  • Feature: (MB) Work item 5398 – Implement worksheet references (Sheet1!A1)

  • Bugfix: (MB) Work item 4967 – Redirect output to a client’s web browser

  • Bugfix: (MB) Work item 5008 – “File Error: data may have been lost.” seen in Excel 2007 and Excel 2003 SP3 when opening XLS file

  • Bugfix: (MB) Work item 5165 – Bug in style’s getHashCode()

  • Bugfix: (MB) Work item 5165 – PHPExcel_Reader not correctly reading numeric values

  • Bugfix: (MB) Work item 5324 – Text rotation is read incorrectly

  • Bugfix: (MB) Work item 5326 – Enclosure ” and data ” result a bad data : \” instead of “”

  • Bugfix: (MB) Work item 5332 – Formula parser – IF statement returning array instead of scalar

  • Bugfix: (MB) Work item 5351 – setFitToWidth(nbpage) & setFitToWidth(nbpage) work partially

  • Bugfix: (MB) Work item 5361 – Worksheet::setTitle() causes unwanted renaming

  • Bugfix: (MB) Work item 5407 – Hyperlinks not working. Results in broken xlsx file.

Get more information or download the latest bits on the PHPExcel Codeplex page.