phpoffice/phpexcel

1.8.2 Production Release

• Bugfix: (MBaker) - Fix to getCell() method when cell reference includes a worksheet reference
• Bugfix: (ncrypthic) Work Item GH-570 - Ignore inlineStr type if formula element exists
• Bugfix: (hernst42) Work Item GH-709 - Fixed missing renames of writeRelationShip (from _writeRelationShip)
• General: (umpirsky) Work Item GH-548 - Optimize vlookup() sort
• Bugfix: (MBaker) Work Item GH-554 - Whitespace after toRichTextObject()
• Feature: (MBaker) - Initial implementation of SUMIFS() function
• Feature: (MBaker) - Additional codepages
• Feature: (Tomino2112) Work Item GH-808 - MemoryDrawing not working in HTML writer
• General: (rentalhost) Work Item GH-575 - Excel 2007 Reader freezes because of conditional formatting
• Bugfix: (vitalyrepin) Pull Request 869 - c:max and c:min elements shall NOT be inside c:orientation elements
• General: (sim642) Pull Request 489 - Implement actual timezone adjustment into PHPExcel_Shared_Date::PHPToExcel

1.8.1 Production Release

• Bugfix: (goncons) Work Item GH-397 - Fix for Writing an Open Document cell with non-numeric formula
• Bugfix: (sarciszewski) Work Item GH-329 - Avoid potential divide by zero in basedrawing
• Bugfix: (ymaerschalck) Work Item GH-405 - XML External Entity (XXE) Processing, different behaviour between simplexml_load_string() and simplexml_load_file().
• Bugfix: (MBaker) - Fix to ensure that current cell is maintained when executing formula calculations
• Bugfix: (MBaker) Work Item GH-350 - Keep/set the value on Reader _loadSheetsOnly as NULL, courtesy of Restless-ET
• Bugfix: (MBaker) Work Item CP18105 - Loading an Excel 2007 spreadsheet throws an "Autofilter must be set on a range of cells" exception
• Bugfix: (MBaker) Work Item GH-388 - Fix to autoloader registration for backward compatibility with PHP 5.2.0 not accepting the prepend flag
• Bugfix: (MBaker) Work Item GH-384 - DOM loadHTMLFile() failing with options flags when using PHP < 5.4.0
• Bugfix: (MBaker) - Fix for percentage operator in formulae for BIFF Writer
• Bugfix: (MBaker) - Fix to getStyle() call for cell object
• Bugfix: (MBaker) - Discard Autofilters in Excel2007 Reader when filter range isn't a valid range
• Bugfix: (frozenstupidity) Work Item GH-423 - Fix invalid NA return in VLOOKUP
• Bugfix: (wiseloren) Work Item CP21454 - "No Impact" conditional formatting fix for NumberFormat
• Bugfix: (bobwitlox) Work Item GH-467 - Bug in Excel2003XML reader, parsing merged cells
• Bugfix: (MBaker) Work Item GH-302 - Fix for CEIL() and FLOOR() when number argument is zero
• Bugfix: (MBaker) - Remove cells cleanly when calling RemoveRow() or RemoveColumn()
• General: (MBaker) - Small performance improvement for autosize columns
• General: (frost-nzcr4) Work Item GH-379 - Change the getter/setter for zeroHeight to camel case
• General: (MBaker) Work Item GH-394 - DefaultValueBinder is too much aggressive when converting string to numeric
• General: (MBaker) - Default precalculate formulas to false for writers
• General: (MBaker) - Set default Cyclic Reference behaviour to 1 to eliminate exception when using a single cyclic iteration in formulae
• General: (MBaker) Work Item GH-396 - Some Excel writer libraries erroneously use Codepage 21010 for UTF-16LE
• Feature: (WiktrzGE) Work Item GH-404 - Methods to manage most of the existing options for Chart Axis, Major Grid-lines and Minor Grid-lines
• Feature: (frost-nzcr4) Work Item GH-403 - ODS read/write comments in the cell
• Feature: (CQD) Work Item GH-389 - Additional Mac CJK codepage definitions
• Feature: (bolovincev) Work Item GH-269 - Update Worksheet.php getStyleByColumnAndRow() to allow a range of cells rather than just a single cell
• Feature: (MBaker) - New methods added for testing cell status within merge groups
• Feature: (cifren/MBaker) Work Item GH-205 - Handling merge cells in HTML Reader
• Feature: (MBaker) - Helper to convert basic HTML markup to a Rich Text object
• Feature: (MBaker) - Improved Iterators New Column Iterator Support for row and column ranges Improved handling for next/prev
• Security: (MBaker) - XML filescan in XML-based Readers to prevent XML Entity Expansion (XEE) (see http://projects.webappsec.org/w/page/13247002/XML%20Entity%20Expansion for an explanation of XEE injection) attacks Reference CVE-2015-3542 - Identification of problem courtesy of Dawid Golunski (Pentest Ltd.)

• Bugfix: (MBaker) Work item CP19830 - Undefined variable: fileHandle in CSV Reader
• Bugfix: (MBaker) Work item CP19968 - Out of memory in style/supervisor.php
• Bugfix: (MBaker) - Style error with merged cells in PDF Writer
• Bugfix: (MBaker) - Problem with cloning worksheets
• Bugfix: (tavoarcila) Work Item GH-259 - Bug fix reading Open Office files
• Bugfix: (MBaker) Work item CP20397 - Serious bug in absolute cell reference used in shared formula Would also have affected insert/delete column/row
• Bugfix: (RomanSyroeshko) Work Item GH-267 - CHOOSE() returns "#VALUE!" if the 1st entry is chosen
• Bugfix: (Gemorroj) Work Item GH-268 - When duplicating styles, styles shifted by one column to the right Fix also applied to duplicating conditional styles
• Bugfix: (IndrekHaav) Work Item GH-212 - Fix for formulae that reference a sheet whose name begins with a digit: these were erroneously identified as numeric values, causing the parser to throw an undefined variable error.
• Bugfix: (IndrekHaav) Work Item CP16208 - Fixed undefined variable error due to $styleArray being used before it's initialised
• Bugfix: (PowerKiKi) Work Item GH-273 - ISTEXT() return wrong result if referencing an empty but formatted cell
• Bugfix: (PowerKiKi) Work Item GH-270/GH-31 - Binary comparison of strings are case insensitive
• Bugfix: (MBaker) Work Item GH-275 - Insert New Row/Column Before is not correctly updating formula references
• Bugfix: (MBaker) Work Item GH-257 - Passing an array of cells to _generateRow() in the HTML/PDF Writer causes caching problems with last cell in the range
• Bugfix: (MBaker) Work Item GH-193 - Fix to empty worksheet garbage collection when using cell caching
• Bugfix: (Jazzo) Work Item GH-248 - Excel2007 does not correctly mark rows as hidden
• Bugfix: (Roy Shahbazian) Work Item GH-299 - Fixed typo in Chart/Layout set/getYMode()
• Bugfix: (EliuFlorez) Work item GH-279 - Fatal error: Call to a member function cellExists() line: 3327 in calculation.php if referenced worksheet doesn't exist
• Bugfix: (MBaker) Work Item GH-290 - AdvancedValueBinder "Division by zero"-error
• Bugfix: (MBaker) Work Item CP20604 - Adding Sheet to Workbook Bug
• Bugfix: (MBaker) Work item CP20703 - Calculation engine incorrectly evaluates empty cells as #VALUE
• Bugfix: (MBaker) Work item CP20760 - Formula references to cell on another sheet in ODS files
• Bugfix: (MBaker) Work item GH321,GH158,CP17824 - LibreOffice created XLSX files results in an empty file.
• Feature: (amerov) - Implementation of the Excel HLOOKUP() function
• Feature: (MBaker) - Added "Quote Prefix" to style settings (Excel2007 Reader and Writer only)
• Feature: (MBaker) - Added Horizontal FILL alignment for Excel5 and Excel2007 Readers/Writers, and Horizontal DISTRIBUTED alignment for Excel2007 Reader/Writer
• Feature: (trvrnrth) Work Item GH-261 - Add support for reading protected (RC4 encrypted) .xls files
• Feature: (LWol) Work Item GH-252 - Adding support for macros, Ribbon in Excel 2007
• General: (cdhutch) Work item CP20055 - Remove array_shift in ReferenceHelper::insertNewBefore improves column or row delete speed
• General: (MBaker) - Improve stock chart handling and rendering, with help from Swashata Ghosh
• General: (MBaker) - Fix to calculation properties for Excel2007 so that the opening application will only recalculate on load if it's actually required
• General: (MBaker) - Modified Excel2007 Writer to default preCalculateFormulas to false Note that autosize columns will still recalculate affected formulae internally
• General: (dresenhista) Work Item GH-242 - Functionality to getHighestRow() for a specified column, and getHighestColumn() for a specified row
• General: (adamriyadi) Work Item GH-247 - Modify PHPExcel_Reader_Excel2007 to use zipClass from PHPExcel_Settings::getZipClass() This allows the use of PCLZip when reading for people that don't have access to ZipArchive
• General: (infojunkie) Work Item GH-276 - Convert properties to string in OOCalc reader
• Security: (maartenba) Work Item GH-322 - Disable libxml external entity loading by default. This is to prevent XML External Entity Processing (XXE) injection attacks (see http://websec.io/2012/08/27/Preventing-XEE-in-PHP.html for an explanation of XXE injection). Reference CVE-2014-2054

Production Release 1.7.9

• Feature: (MBaker) Include charts option for HTML Writer
• Feature: (MBaker) Added composer file
• Feature: (MBaker) Added getStyle() method to Cell object
• Bugfix: (Asker) Work item 18777 - Error in PHPEXCEL/Calculation.php script on line 2976 (stack pop check)
• Bugfix: (MBaker) Work item 18794 - CSV files without a file extension being identified as HTML
• Bugfix: (AndreKR) Work item GH-66 - Wrong check for maximum number of rows in Excel5 Writer
• Bugfix: (MBaker) Work item GH-67 - Cache directory for DiscISAM cache storage cannot be set
• Bugfix: (MBaker) Work item 17976 - Fix to Excel2007 Reader for hyperlinks with an anchor fragment (following a #), otherwise they were treated as sheet references
• Bugfix: (MBaker) Work item 18963 - getSheetNames() fails on numeric (floating point style) names with trailing zeroes
• Bugfix: (MBaker) Work item GH-130 - Single cell print area
• General: (kea) Work item GH-69 - Improved AdvancedValueBinder for currency
• General: (MBaker) Work items 17936 and 17840 - Fix for environments where there is no access to /tmp but to upload_tmp_dir Provided an option to set the sys_get_temp_dir() call to use the upload_tmp_dir; though by default the standard temp directory will still be used
• General: (amironov ) Work item GH-84 - Search style by identity in PHPExcel_Worksheet::duplicateStyle()
• General: (karak) Work item GH-85 - Fill SheetView IO in Excel5
• General: (cfhay) Work item 18958 - Memory and Speed improvements in PHPExcel_Reader_Excel5
• General: (MBaker) Work item GH-78 - Modify listWorksheetNames() and listWorksheetInfo to use XMLReader with streamed XML rather than SimpleXML
• General: (dbonsch) Restructuring of PHPExcel Exceptions
• General: (MBaker) Work items 16926 and 15145 - Refactor Calculation Engine from singleton to a Multiton Ensures that calculation cache is maintained independently for different workbooks
• General: (MBaker) Modify cell's getCalculatedValue() method to return the content of RichText objects rather than the RichText object itself
• Bugfix: (techhead) Work item GH-70 - Fixed formula/formatting bug when removing rows
• Bugfix: (alexgann) Work item GH-63 - Fix to cellExists for non-existent namedRanges
• Bugfix: (MBaker) Work item 18844 - cache_in_memory_gzip "eats" last worksheet line, cache_in_memory doesn't
• Feature: (Progi1984) Work item GH-22 - Sheet View in Excel5 Writer
• Bugfix: (amironov) Work item GH-82 - PHPExcel_Worksheet::getCellCollection() may not return last cached cell
• Bugfix: (teso) Work item 18551 - Rich Text containing UTF-8 characters creating unreadable content with Excel5 Writer
• Bugfix: (MBaker) Work item GH-104 - echo statements in HTML.php
• Feature: (Progi1984) Work item GH-8/CP11704 : Conditional formatting in Excel 5 Writer
• Bugfix: (MBaker) Work item GH-113 - canRead() Error for GoogleDocs ODS files: in ODS files from Google Docs there is no mimetype file
• Bugfix: (MBaker) Work item GH-80 - "Sheet index is out of bounds." Exception
• Bugfix: (ccorliss) Work item GH-105 - Fixed number format fatal error
• Bugfix: (MBaker) - Add DROP TABLE in destructor for SQLite and SQLite3 cache controllers
• Bugfix: (alexgann) Work item GH-154 - Fix merged-cell borders on HTML/PDF output
• Bugfix: (Shanto) Work item GH-161 - Fix: Hyperlinks break when removing rows
• Bugfix: (neclimdul) Work item GH-166 - Fix Extra Table Row From Images and Charts

Version 1.7.9 Release Candidate 1

Version 1.8.0 Release Candidate 4

Version 1.8.0 Release Candidate 3

Version 1.8.0 Release Candidate 2

Version 1.8.0 Release Candidate 1