صفحهٔ اصلی گشت‌و‌گذار راهنما
ثبت نام ورود
lizhen
/
yuanshan
1
0
انشعاب 0
پرونده‌ها مشکلات 0 ویکی
درخت: 3d9bb398c4
شاخه‌ها تگ‌ها
yuanshan
/
vendor
/
phpoffice
/
phpspreadsheet
/
CHANGELOG.PHPExcel.md

CHANGELOG.PHPExcel.md 152 KB
تاريخچه خام

Changelog for PHPExcel

This is the historic changelog of the project when it was still called PHPExcel. It exists only for historical purposes and versions mentioned here should not be confused with PhpSpreadsheet versions.

[1.8.1] - 2015-04-30

Bugfixes

  • Fix for Writing an Open Document cell with non-numeric formula - @goncons #397
  • Avoid potential divide by zero in basedrawing - @sarciszewski #329
  • XML External Entity (XXE) Processing, different behaviour between simplexml_load_string() and simplexml_load_file(). - @ymaerschalck #405
  • Fix to ensure that current cell is maintained when executing formula calculations - @MarkBaker
  • Keep/set the value on Reader _loadSheetsOnly as NULL, courtesy of Restless-ET - @MarkBaker #350
  • Loading an Excel 2007 spreadsheet throws an "Autofilter must be set on a range of cells" exception - @MarkBaker CodePlex #18105
  • Fix to autoloader registration for backward compatibility with PHP 5.2.0 not accepting the prepend flag - @MarkBaker #388
  • DOM loadHTMLFile() failing with options flags when using PHP < 5.4.0 - @MarkBaker #384
  • Fix for percentage operator in formulae for BIFF Writer - @MarkBaker
  • Fix to getStyle() call for cell object - @MarkBaker
  • Discard Autofilters in Excel2007 Reader when filter range isn't a valid range - @MarkBaker
  • Fix invalid NA return in VLOOKUP - @frozenstupidity #423
  • "No Impact" conditional formatting fix for NumberFormat - @wiseloren CodePlex #21454
  • Bug in Excel2003XML reader, parsing merged cells - @bobwitlox #467
  • Fix for CEIL() and FLOOR() when number argument is zero - @MarkBaker #302

General

  • Remove cells cleanly when calling RemoveRow() or RemoveColumn() - @MarkBaker
  • Small performance improvement for autosize columns - @MarkBaker
  • Change the getter/setter for zeroHeight to camel case - @frost-nzcr4 #379
  • DefaultValueBinder is too much aggressive when converting string to numeric - @MarkBaker #394
  • Default precalculate formulas to false for writers - @MarkBaker
  • Set default Cyclic Reference behaviour to 1 to eliminate exception when using a single cyclic iteration in formulae - @MarkBaker

Features

  • Some Excel writer libraries erroneously use Codepage 21010 for UTF-16LE - @MarkBaker #396
  • Methods to manage most of the existing options for Chart Axis, Major Grid-lines and Minor Grid-lines - @WiktrzGE #404
  • ODS read/write comments in the cell - @frost-nzcr4 #403
  • Additional Mac CJK codepage definitions - @CQD #389
  • Update Worksheet.php getStyleByColumnAndRow() to allow a range of cells rather than just a single cell - @bolovincev #269
  • New methods added for testing cell status within merge groups - @MarkBaker
  • Handling merge cells in HTML Reader - @cifren/MBaker #205
  • Helper to convert basic HTML markup to a Rich Text object - @MarkBaker
  • Improved Iterators - @MarkBaker
    • New Column Iterator
    • Support for row and column ranges
    • Improved handling for next/prev

Security

[1.8.0] - 2014-03-02

Bugfixes

  • Undefined variable: fileHandle in CSV Reader - @MarkBaker CodePlex #19830
  • Out of memory in style/supervisor.php - @MarkBaker CodePlex #19968
  • Style error with merged cells in PDF Writer - @MarkBaker
  • Problem with cloning worksheets - @MarkBaker
  • Bug fix reading Open Office files - @tavoarcila #259
  • Serious bug in absolute cell reference used in shared formula - @MarkBaker CodePlex #20397
    • Would also have affected insert/delete column/row- CHOOSE() returns "#VALUE!" if the 1st entry is chosen - @RomanSyroeshko #267
  • When duplicating styles, styles shifted by one column to the right - @Gemorroj #268
    • Fix also applied to duplicating conditional styles- Fix for formulae that reference a sheet whose name begins with a digit: - @IndrekHaav #212
    • these were erroneously identified as numeric values, causing the parser to throw an undefined variable error.- Fixed undefined variable error due to $styleArray being used before it's initialised - @IndrekHaav CodePlex #16208
  • ISTEXT() return wrong result if referencing an empty but formatted cell - @PowerKiKi #273
  • Binary comparison of strings are case insensitive - @PowerKiKi #270, #31
  • Insert New Row/Column Before is not correctly updating formula references - @MarkBaker #275
  • Passing an array of cells to _generateRow() in the HTML/PDF Writer causes caching problems with last cell in the range - @MarkBaker #257
  • Fix to empty worksheet garbage collection when using cell caching - @MarkBaker #193
  • Excel2007 does not correctly mark rows as hidden - @Jazzo #248
  • Fixed typo in Chart/Layout set/getYMode() - @Roy Shahbazian #299
  • Fatal error: Call to a member function cellExists() line: 3327 in calculation.php if referenced worksheet doesn't exist - @EliuFlorez #279
  • AdvancedValueBinder "Division by zero"-error - @MarkBaker #290
  • Adding Sheet to Workbook Bug - @MarkBaker CodePlex #20604
  • Calculation engine incorrectly evaluates empty cells as #VALUE - @MarkBaker CodePlex #20703
  • Formula references to cell on another sheet in ODS files - @MarkBaker CodePlex #20760

Features

  • LibreOffice created XLSX files results in an empty file. - @MarkBaker #321, #158, CodePlex #17824
  • Implementation of the Excel HLOOKUP() function - @amerov
  • Added "Quote Prefix" to style settings (Excel2007 Reader and Writer only) - @MarkBaker
  • Added Horizontal FILL alignment for Excel5 and Excel2007 Readers/Writers, and Horizontal DISTRIBUTED alignment for Excel2007 Reader/Writer - @MarkBaker
  • Add support for reading protected (RC4 encrypted) .xls files - @trvrnrth #261

General

  • Adding support for macros, Ribbon in Excel 2007 - @LWol #252
  • Remove array_shift in ReferenceHelper::insertNewBefore improves column or row delete speed - @cdhutch CodePlex #20055
  • Improve stock chart handling and rendering, with help from Swashata Ghosh - @MarkBaker
  • Fix to calculation properties for Excel2007 so that the opening application will only recalculate on load if it's actually required - @MarkBaker
  • Modified Excel2007 Writer to default preCalculateFormulas to false - @MarkBaker
    • Note that autosize columns will still recalculate affected formulae internally- Functionality to getHighestRow() for a specified column, and getHighestColumn() for a specified row - @dresenhista #242

  • Modify PHPExcel_Reader_Excel2007 to use zipClass from PHPExcel_Settings::getZipClass() - @adamriyadi #247

    • This allows the use of PCLZip when reading for people that don't have access to ZipArchive

      Security

  • Convert properties to string in OOCalc reader - @infojunkie #276

  • Disable libxml external entity loading by default. - @maartenba #322

[1.7.9] - 2013-06-02

Features

Bugfixes

  • Added getStyle() method to Cell object - @MarkBaker
  • Error in PHPEXCEL/Calculation.php script on line 2976 (stack pop check) - @Asker CodePlex #18777
  • CSV files without a file extension being identified as HTML - @MarkBaker CodePlex #18794
  • Wrong check for maximum number of rows in Excel5 Writer - @AndreKR #66
  • Cache directory for DiscISAM cache storage cannot be set - @MarkBaker #67
  • Fix to Excel2007 Reader for hyperlinks with an anchor fragment (following a #), otherwise they were treated as sheet references - @MarkBaker CodePlex #17976
  • getSheetNames() fails on numeric (floating point style) names with trailing zeroes - @MarkBaker CodePlex #18963
  • Modify cell's getCalculatedValue() method to return the content of RichText objects rather than the RichText object itself - @MarkBaker
  • Fixed formula/formatting bug when removing rows - @techhead #70
  • Fix to cellExists for non-existent namedRanges - @alexgann #63
  • Sheet View in Excel5 Writer - @Progi1984 #22
  • PHPExcel_Worksheet::getCellCollection() may not return last cached cell - @amironov #82
  • Rich Text containing UTF-8 characters creating unreadable content with Excel5 Writer - @teso CodePlex #18551
  • Work item GH-8/CP11704 : Conditional formatting in Excel 5 Writer - @Progi1984
  • canRead() Error for GoogleDocs ODS files: in ODS files from Google Docs there is no mimetype file - @MarkBaker #113
  • "Sheet index is out of bounds." Exception - @MarkBaker #80
  • Fixed number format fatal error - @ccorliss #105
  • Add DROP TABLE in destructor for SQLite and SQLite3 cache controllers - @MarkBaker
  • Fix merged-cell borders on HTML/PDF output - @alexgann #154
  • Fix: Hyperlinks break when removing rows - @Shanto #161
  • Fix Extra Table Row From Images and Charts - @neclimdul #166

General

  • Single cell print area - @MarkBaker #130
  • Improved AdvancedValueBinder for currency - @kea #69
  • Fix for environments where there is no access to /tmp but to upload_tmp_dir - @MarkBaker
    • 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- Search style by identity in PHPExcel_Worksheet::duplicateStyle() - @amironov #84
  • Fill SheetView IO in Excel5 - @karak #85
  • Memory and Speed improvements in PHPExcel_Reader_Excel5 - @cfhay CodePlex #18958
  • Modify listWorksheetNames() and listWorksheetInfo to use XMLReader with streamed XML rather than SimpleXML - @MarkBaker #78
  • Restructuring of PHPExcel Exceptions - @dbonsch
  • Refactor Calculation Engine from singleton to a Multiton - @MarkBaker
    • Ensures that calculation cache is maintained independently for different workbooks

[1.7.8] - 2012-10-12

Features

  • Phar builder script to add phar file as a distribution option - @kkamkou
  • Refactor PDF Writer to allow use with a choice of PDF Rendering library - @MarkBaker
    • rather than restricting to tcPDF
    • Current options are tcPDF, mPDF, DomPDF
    • tcPDF Library has now been removed from the deployment bundle- Initial version of HTML Reader - @MarkBaker
  • Implement support for AutoFilter in PHPExcel_Writer_Excel5 - @Progi1984
  • Modified ERF and ERFC Engineering functions to accept Excel 2010's modified acceptance of negative arguments - @MarkBaker
  • Support SheetView view attribute (Excel2007) - @k1LoW
  • Excel compatibility option added for writing CSV files - @MarkBaker
    • While Excel 2010 can read CSV files with a simple UTF-8 BOM, Excel2007 and earlier require UTF-16LE encoded tab-separated files.
    • The new setExcelCompatibility(TRUE) option for the CSV Writer will generate files with this formatting for easy import into Excel2007 and below.- Language implementations for Turkish (tr) - @MarkBaker
  • Added fraction tests to advanced value binder - @MarkBaker

General

  • Allow call to font setUnderline() for underline format to specify a simple boolean for UNDERLINE_NONE or UNDERLINE_SINGLE - @MarkBaker
  • Add Currency detection to the Advanced Value Binder - @alexgann
  • setCellValueExplicitByColumnAndRow() do not return PHPExcel_Worksheet - @MarkBaker CodePlex #18404
  • Reader factory doesn't read anymore XLTX and XLT files - @MarkBaker CodePlex #18324
  • Magic __toString() method added to Cell object to return raw data value as a string - @MarkBaker
  • Add cell indent to html rendering - @alexgann

Bugfixes

  • ZeroHeight for rows in sheet format - @Raghav1981
  • OOCalc cells containing text:span inside the text:p tag - @cyberconte
  • Fix to listWorksheetInfo() method for OOCalc Reader - @schir1964
  • Support for "e" (epoch) date format mask - @MarkBaker
    • Rendered as a 4-digit CE year in non-Excel outputs- Background color cell is always black when editing cell - @MarkBaker
  • Allow "no impact" to formats on Conditional Formatting - @MarkBaker
  • OOCalc Reader fix for NULL cells - @wackonline
  • Fix to excel2007 Chart Writer when a $plotSeriesValues is empty - @seltzlab
  • Various fixes to Chart handling - @MarkBaker
  • Error loading xlsx file with column breaks - @MarkBaker CodePlex #18370
  • OOCalc Reader now handles percentage and currency data types - @MarkBaker
  • mb_stripos empty delimiter - @MarkBaker
  • getNestingLevel() Error on Excel5 Read - @takaakik
  • Fix to Excel5 Reader when cell annotations are defined before their referenced text objects - @MarkBaker
  • OOCalc Reader modified to process number-rows-repeated - @MarkBaker
  • Chart Title compatibility on Excel 2007 - @MarkBaker CodePlex #18377
  • Chart Refresh returning cell reference rather than values - @MarkBaker CodePlex #18146
  • Autoshape being identified in twoCellAnchor when includeCharts is TRUE triggering load error - @MarkBaker CodePlex #18145
  • v-type texts for series labels now recognised and parsed correctly - @MarkBaker CodePlex #18325
  • load file failed if the file has no extensionType - @wolf5x CodePlex #18492
  • Pattern fill colours in Excel2007 Style Writer - @dverspui
  • Excel2007 Writer order of font style elements to conform with Excel2003 using compatibility pack - @MarkBaker
  • Problems with $_activeSheetIndex when decreased below 0. - @MarkBaker CodePlex #18425
  • PHPExcel_CachedObjectStorage_SQLite3::cacheMethodIsAvailable() uses class_exists - autoloader throws error - @MarkBaker CodePlex #18597
  • Cannot access private property PHPExcel_CachedObjectStorageFactory::$_cacheStorageMethod - @MarkBaker CodePlex #18598
  • Data titles for charts - @MarkBaker CodePlex #18397
    • PHPExcel_Chart_Layout now has methods for getting/setting switches for displaying/hiding chart data labels- Discard single cell merge ranges when reading (stupid that Excel allows them in the first place) - @MarkBaker
  • Discard hidden autoFilter named ranges - @MarkBaker

[1.7.7] - 2012-05-19

Bugfixes

Features

  • OOCalc cells contain same data bug? - @cyberconte CodePlex #17471
  • listWorksheetInfo() method added to Readers... courtesy of Christopher Mullins - @schir1964
  • Options for cell caching using Igbinary and SQLite/SQlite3. - @MarkBaker
  • Additional row iterator options: allow a start row to be defined in the constructor; seek(), and prev() methods added. - @MarkBaker
  • Implement document properties in Excel5 writer - @Progi1984 CodePlex #9759

General

  • Implement chart functionality (EXPERIMENTAL) - @MarkBaker CodePlex #16
    • Initial definition of chart objects.
    • Reading Chart definitions through the Excel2007 Reader
    • Facility to render charts to images using the 3rd-party jpgraph library
    • Writing Charts using the Excel2007 Writer- Fix to build to ensure that Examples are included with the documentation - @MarkBaker
  • Reduce cell caching overhead using dirty flag to ensure that cells are only rewritten to the cache if they have actually been changed - @MarkBaker
  • Improved memory usage in CSV Writer - @MarkBaker
  • Improved speed and memory usage in Excel5 Writer - @MarkBaker
  • Experimental - @MarkBaker
    • Added getHighestDataColumn(), getHighestDataRow(), getHighestRowAndColumn() and calculateWorksheetDataDimension() methods for the worksheet that return the highest row and column that have cell records- Support for Rich-Text in PHPExcel_Writer_Excel5 - @Progi1984 CodePlex #8916
  • Two easy to fix Issues concerning PHPExcel_Token_Stack (l10n/UC) - @MarkBaker CodePlex #15405
  • Locale file paths not fit for windows - @MarkBaker CodePlex #15461
  • Add file directory as a cache option for cache_to_discISAM - @MarkBaker CodePlex #16643
  • Datatype.php & constant TYPE_NULL - @MarkBaker CodePlex #16923
  • Ensure use of system temp directory for all temporary work files, unless explicitly specified - @MarkBaker
  • [Patch] faster stringFromColumnIndex() - @char101 CodePlex #16359
  • Fix for projects that still use old autoloaders - @whit1206 CodePlex #16028
  • Unknown codepage: 10007 - @atz CodePlex #17024
    • Additional Mac codepages

[1.7.6] - 2011-02-27

Features

  • Provide option to use PCLZip as an alternative to ZipArchive. - @MarkBaker
    • This allows the writing of Excel2007 files, even without ZipArchive enabled (it does require zlib), or when php_zip is one of the buggy PHP 5.2.6 or 5.2.8 versions
    • It can be enabled using PHPExcel_Settings::setZipClass(PHPExcel_Settings::PCLZIP);
    • Note that it is not yet implemented as an alternative to ZipArchive for those Readers that are extracting from zips- Added listWorksheetNames() method to Readers that support multiple worksheets in a workbook, allowing a user to extract a list of all the worksheet names from a file without parsing/loading the whole file. - @MarkBaker CodePlex #14979
  • Speed boost and memory reduction in the Worksheet toArray() method. - @MarkBaker
  • Added new rangeToArray() and namedRangeToArray() methods to the PHPExcel_Worksheet object. - @MarkBaker
    • Functionally, these are identical to the toArray() method, except that they take an additional first parameter of a Range (e.g. 'B2:C3') or a Named Range name.
    • Modified the toArray() method so that it actually uses rangeToArray().- Added support for cell comments in the OOCalc, Gnumeric and Excel2003XML Readers, and in the Excel5 Reader - @MarkBaker
  • Improved toFormattedString() handling for Currency and Accounting formats to render currency symbols - @MarkBaker

Bugfixes

General

  • Full column/row references in named ranges not supported by updateCellReference() - @MarkBaker CodePlex #15409
  • Improved performance (speed), for building the Shared Strings table in the Excel2007 Writer. - @MarkBaker
  • Improved performance (speed), for PHP to Excel date conversions - @MarkBaker
  • Enhanced SheetViews element structures in the Excel2007 Writer for frozen panes. - @MarkBaker
  • Removed Serialized Reader/Writer as these no longer work. - @MarkBaker

[1.7.5] - 2010-12-10

Features

  • Implement Gnumeric File Format - @MarkBaker CodePlex #8769
    • Initial work on Gnumeric Reader (Worksheet Data, Document Properties and basic Formatting)- Support for Extended Workbook Properties in Excel2007, Excel5 and OOCalc Readers; support for User-defined Workbook Properties in Excel2007 and OOCalc Readers - @MarkBaker
  • Support for Extended and User-defined Workbook Properties in Excel2007 Writer - @MarkBaker
  • Provided a setGenerateSheetNavigationBlock(false); option to suppress generation of the sheet navigation block when writing multiple worksheets to HTML - @MarkBaker
  • Advanced Value Binder now recognises TRUE/FALSE strings (locale-specific) and converts to boolean - @MarkBaker
  • PHPExcel_Worksheet->toArray() is returning truncated values - @MarkBaker CodePlex #14301
  • Configure PDF Writer margins based on Excel Worksheet Margin Settings value - @MarkBaker
  • Added Contiguous flag for the CSV Reader, when working with Read Filters - @MarkBaker
  • Added getFormattedValue() method for cell object - @MarkBaker
  • Added strictNullComparison argument to the worksheet fromArray() method - @MarkBaker

Bugfixes

General

  • Using $this when not in object context in Excel5 Reader - @MarkBaker CodePlex #14837
  • Removes a unnecessary loop through each cell when applying conditional formatting to a range. - @MarkBaker
  • Removed spurious PHP end tags (?>) - @MarkBaker
  • Improved performance (speed) and reduced memory overheads, particularly for the Writers, but across the whole library. - @MarkBaker

[1.7.4] - 2010-08-26

Bugfixes

  • Excel5 : Formula : Power - @Progi1984 CodePlex #7895
  • Excel5 : Formula : Unary plus - @Progi1984 CodePlex #7895
  • Excel5 : Just write the Escher stream if necessary in Worksheet - @Progi1984
  • Syntax errors in memcache.php 1.7.3c - @MarkBaker CodePlex #13433
  • Support for row or column ranges in the calculation engine, e.g. =SUM(C:C) or =SUM(1:2) - @MarkBaker
    • Also support in the calculation engine for absolute row or column ranges e.g. =SUM($C:$E) or =SUM($3:5)- Picture problem with Excel 2003 - @Erik Tilt CodePlex #13455
  • Wrong variable used in addExternalSheet in PHPExcel.php - @MarkBaker CodePlex #13484
  • "Invalid cell coordinate" error when formula access data from an other sheet - @MarkBaker CodePlex #13515
  • (related to Work item 13515) Calculation engine confusing cell range worksheet when referencing cells in a different worksheet to the formula - @MarkBaker
  • Wrong var naming in Worksheet->garbageCollect() - @MarkBaker CodePlex #13752
  • PHPExcelStyle*::__clone() methods cause cloning loops? - @MarkBaker CodePlex #13764
  • Recent builds causing problems loading xlsx files? (ZipArchive issue?) - @MarkBaker CodePlex #11488
  • cache_to_apc causes fatal error when processing large data sets - @MarkBaker CodePlex #13856
  • OOCalc reader misses first line if it's a 'table-header-row' - @MarkBaker CodePlex #13880

  • using cache with copy or clone bug? - @MarkBaker CodePlex #14011

    • Fixed $worksheet->copy() or clone $worksheet when using cache_in_memory, cache_in_memory_gzip, cache_in_memory_serialized, cache_to_discISAM, cache_to_phpTemp, cache_to_apc and cache_to_memcache;

    • Fixed but untested when using cache_to_wincache.

      Features

  • Standard Deviation functions returning DIV/0 Error when Standard Deviation is zero - @MarkBaker CodePlex #13450

  • Support for print area with several ranges in the Excel2007 reader, and improved features for editing print area with several ranges - @MarkBaker

  • Improved Cell Exception Reporting - @MarkBaker CodePlex #13769

General

  • Fixed problems with reading Excel2007 Properties - @MarkBaker
  • PHP Strict Standards: Non-static method PHPExcel_Shared_String::utf16_decode() should not be called statically - @MarkBaker
  • Array functions were ignored when loading an existing file containing them, and as a result, they would lose their 'cse' status. - @MarkBaker
  • Minor memory tweaks to Excel2007 Writer - @MarkBaker
  • Modified ReferenceHelper updateFormulaReferences() method to handle updates to row and column cell ranges (including absolute references e.g. =SUM(A:$E) or =SUM($5:5), and range/cell references that reference a worksheet by name), and to provide both performance and memory improvements. - @MarkBaker
  • Modified Excel2007 Reader so that ReferenceHelper class is instantiated only once rather than for every shared formula in a workbook. - @MarkBaker
  • Correct handling for additional (synonym) formula tokens in Excel5 Reader - @MarkBaker
  • Additional reading of some Excel2007 Extended Properties (Company, Manager) - @MarkBaker

[1.7.3c] - 2010-06-01

Bugfixes

[1.7.3b] - 2010-05-31

Bugfixes

[1.7.3] - 2010-05-17

General

  • Applied patch 4990 (modified) - @Erik Tilt
  • Applied patch 5568 (modified) - @MarkBaker
  • Applied patch 5943 - @MarkBaker
  • Upgrade build script to use Phing - @MarkBaker CodePlex #13042
  • Replacing var with public/private - @Erik Tilt CodePlex #11586
  • Applied Anthony's Sterling's Class Autoloader to reduce memory overhead by "Lazy Loading" of classes - @MarkBaker
  • Modification to functions that accept a date parameter to support string values containing ordinals as per Excel (English language only) - @MarkBaker
  • Modify PHPExcel_Style_NumberFormat::toFormattedString() to handle dates that fall outside of PHP's 32-bit date range - @MarkBaker
  • Applied patch 5207 - @MarkBaker

Features

  • PHPExcel developer documentation: Set page margins - @Erik Tilt CodePlex #11970
  • Special characters and accents in SYLK reader - @Erik Tilt CodePlex #11038
  • Implement more Excel calculation functions - @MarkBaker
    • Implemented the COUPDAYS(), COUPDAYBS(), COUPDAYSNC(), COUPNCD(), COUPPCD() and PRICE() Financial functions
    • Implemented the N() and TYPE() Information functions
    • Implemented the HYPERLINK() Lookup and Reference function- Horizontal page break support in PHPExcel_Writer_PDF - @Erik Tilt CodePlex #11526
  • Introduce method setActiveSheetIndexByName() - @Erik Tilt CodePlex #11529
  • AdvancedValueBinder.php: Automatically wrap text when there is new line in string (ALT+"Enter") - @Erik Tilt CodePlex #11550
  • Data validation support in PHPExcel_Reader_Excel5 and PHPExcel_Writer_Excel5 - @Erik Tilt CodePlex #10300
  • Improve autosize calculation - @MarkBaker CodePlex #11616
  • Methods to translate locale-specific function names in formulae - @MarkBaker
    • Language implementations for Czech (cs), Danish (da), German (de), English (uk), Spanish (es), Finnish (fi), French (fr), Hungarian (hu), Italian (it), Dutch (nl), Norwegian (no), Polish (pl), Portuguese (pt), Brazilian Portuguese (pt_br), Russian (ru) and Swedish (sv)- Implement document properties in Excel5 reader/writer - @Erik Tilt CodePlex #9759
    • Fixed so far for PHPExcel_Reader_Excel5- Show/hide row and column headers in worksheet - @Erik Tilt CodePlex #11849
  • Can't set font on writing PDF (by key) - @Erik Tilt CodePlex #11919
  • Thousands scale (1000^n) support in PHPExcel_Style_NumberFormat::toFormattedString - @Erik Tilt CodePlex #12096
  • Implement repeating rows in PDF and HTML writer - @Erik Tilt
  • Sheet tabs in PHPExcel_Writer_HTML - @Erik Tilt CodePlex #12289
  • Add Wincache CachedObjectProvider - @MarkBaker CodePlex #13041
  • Configure PDF Writer paper size based on Excel Page Settings value, and provided methods to override paper size and page orientation with the writer - @MarkBaker
    • Note PHPExcel defaults to Letter size, while the previous PDF writer enforced A4 size, so PDF writer will now default to Letter- Initial implementation of cell caching: allowing larger workbooks to be managed, but at a cost in speed - @MarkBaker

Bugfixes

  • Added an identify() method to the IO Factory that identifies the reader which will be used to load a particular file without actually loading it. - @MarkBaker
  • Warning messages with INDEX function having 2 arguments - @MarkBaker CodePlex #10979
  • setValue('=') should result in string instead of formula - @Erik Tilt CodePlex #11473
  • method _raiseFormulaError should no be private - @MarkBaker CodePlex #11471
  • Fatal error: Call to undefined function mb_substr() in ...Classes\PHPExcel\Reader\Excel5.php on line 2903 - @Erik Tilt CodePlex #11485
  • getBold(), getItallic(), getStrikeThrough() not always working with PHPExcel_Reader_Excel2007 - @Erik Tilt CodePlex #11487
  • AdvancedValueBinder.php not working correctly for $cell->setValue('hh:mm:ss') - @Erik Tilt CodePlex #11492
  • Fixed leap year handling for the YEARFRAC() Date/Time function when basis ia 1 (Actual/actual) - @MarkBaker
  • Warning messages - @MarkBaker CodePlex #11490
    • Calculation Engine code modified to enforce strict standards for pass by reference- PHPExcel_Cell_AdvancedValueBinder doesnt work for dates in far future - @Erik Tilt CodePlex #11483
  • MSODRAWING bug with long CONTINUE record in PHPExcel_Reader_Excel5 - @Erik Tilt CodePlex #11528
  • PHPExcel_Reader_Excel2007 reads print titles as named range when there is more than one sheet - @Erik Tilt CodePlex #11571
  • missing @return in phpdocblock in reader classes - @Erik Tilt CodePlex #11561
  • AdvancedValueBinder.php: String sometimes becomes a date when it shouldn't - @Erik Tilt CodePlex #11576
  • Small numbers escape treatment in PHPExcel_Style_NumberFormat::toFormattedString() - @Erik Tilt CodePlex #11588
  • Blank styled cells are not blank in output by HTML writer due to   - @Erik Tilt CodePlex #11590
  • Calculation engine bug: Existing, blank cell + number gives #NUM - @MarkBaker CodePlex #11587
  • AutoSize only measures length of first line in cell with multiple lines (ALT+Enter) - @Erik Tilt CodePlex #11608
  • Fatal error running Tests/12serializedfileformat.php (PHPExcel 1.7.2) - @Erik Tilt CodePlex #11608
  • Fixed various errors in the WORKDAY() and NETWORKDAYS() Date/Time functions (particularly related to holidays) - @MarkBaker
  • Uncaught exception 'Exception' with message 'Valid scale is between 10 and 400.' in Classes/PHPExcel/Worksheet/SheetView.php:115 - @Erik Tilt CodePlex #11660
  • "Unrecognized token 39 in formula" with PHPExcel_Reader_Excel5 (occuring with add-in functions) - @Erik Tilt CodePlex #11551
  • Excel2007 reader not reading PHPExcel_Style_Conditional::CONDITION_EXPRESSION - @Erik Tilt CodePlex #11668
  • Fix to the BESSELI(), BESSELJ(), BESSELK(), BESSELY() and COMPLEX() Engineering functions to use correct default values for parameters - @MarkBaker
  • DATEVALUE function not working for pure time values + allow DATEVALUE() function to handle partial dates (e.g. "1-Jun" or "12/2010") - @MarkBaker CodePlex #11525
  • Fix for empty quoted strings in formulae - @MarkBaker
  • Trap for division by zero in Bessel functions - @MarkBaker
  • Fix to OOCalc Reader to convert semi-colon (;) argument separator in formulae to a comma (,) - @MarkBaker
  • PHPExcel_Writer_Excel5_Parser cannot parse formula like =SUM(C$5:C5) - @Erik Tilt CodePlex #11693
  • Fix to OOCalc Reader to handle dates that fall outside 32-bit PHP's date range - @MarkBaker
  • File->sys_get_temp_dir() can fail in safe mode - @Erik Tilt CodePlex #11692
  • Sheet references in Excel5 writer do not work when referenced sheet title contains non-Latin symbols - @Erik Tilt CodePlex #11727
  • Bug in HTML writer can result in missing rows in output - @Erik Tilt CodePlex #11743
  • setShowGridLines(true) not working with PHPExcel_Writer_PDF - @Erik Tilt CodePlex #11674
  • PHPExcel_Worksheet_RowIterator initial position incorrect - @Erik Tilt CodePlex #11836
  • PHPExcel_Worksheet_HeaderFooterDrawing Strict Exception thrown (by jshaw86) - @Erik Tilt CodePlex #11835
  • Parts of worksheet lost when there are embedded charts (Excel5 reader) - @Erik Tilt CodePlex #11850
  • VLOOKUP() function error when lookup value is passed as a cell reference rather than an absolute value - @MarkBaker
  • First segment of Rich-Text not read correctly by PHPExcel_Reader_Excel2007 - @Erik Tilt CodePlex #12041
  • Fatal Error with getCell('name') when name matches the pattern for a cell reference - @MarkBaker CodePlex #12048
  • excel5 writer appears to be swapping image locations - @Erik Tilt CodePlex #12039
  • Undefined index: host in ZipStreamWrapper.php, line 94 and line 101 - @Erik Tilt CodePlex #11954
  • BIFF8 File Format problem (too short COLINFO record) - @Erik Tilt CodePlex #11672
  • Column width sometimes changed after read/write with Excel2007 reader/writer - @Erik Tilt CodePlex #12121
  • Worksheet.php throws a fatal error when styling is turned off via setReadDataOnly on the reader - @Erik Tilt CodePlex #11964
  • Checking for Circular References in Formulae - @MarkBaker CodePlex #11851
    • Calculation Engine code now traps for cyclic references, raising an error or throwing an exception, or allows 1 or more iterations through cyclic references, based on a configuration setting- PNG transparency using Excel2007 writer - @Erik Tilt CodePlex #12244
  • Custom readfilter error when cell formulas reference excluded cells (Excel5 reader) - @Erik Tilt CodePlex #12221
  • Protection problem in XLS - @Erik Tilt CodePlex #12288
  • getColumnDimension()->setAutoSize() incorrect on cells with Number Formatting - @Erik Tilt CodePlex #12300
  • Notices reading Excel file with Add-in funcitons (PHPExcel_Reader_Excel5) - @Erik Tilt CodePlex #12378
  • Excel5 reader not reading formulas with deleted sheet references - @Erik Tilt CodePlex #12380
  • Named range (defined name) scope problems for in PHPExcel - @Erik Tilt CodePlex #12404
  • PHP Parse error: syntax error, unexpected T_PUBLIC in PHPExcel/Calculation.php on line 3482 - @Erik Tilt CodePlex #12423
  • Named ranges don't appear in name box using Excel5 writer - @Erik Tilt CodePlex #12505
  • Many merged cells + autoSize column -> slows down the writer - @Erik Tilt CodePlex #12509
  • Incorrect fallback order comment in Shared/Strings.php ConvertEncoding() - @Erik Tilt CodePlex #12539
  • IBM AIX iconv() will not work, should revert to mbstring etc. instead - @Erik Tilt CodePlex #12538
  • Excel5 writer and mbstring functions overload - @Erik Tilt CodePlex #12568
  • OFFSET needs to flattenSingleValue the $rows and $columns args - @MarkBaker CodePlex #12672
  • Formula with DMAX(): Notice: Undefined offset: 2 in ...\PHPExcel\Calculation.php on line 2365 - @MarkBaker CodePlex #12546
    • Note that the Database functions have not yet been implemented- Call to a member function getParent() on a non-object in Classes\PHPExcel\Calculation.php Title is required - @MarkBaker CodePlex #12839
  • Cyclic Reference in Formula - @MarkBaker CodePlex #12935
  • Memory error...data validation? - @MarkBaker CodePlex #13025

[1.7.2] - 2010-01-11

General

  • Applied patch 4362 - @Erik Tilt
  • Applied patch 4363 (modified) - @Erik Tilt
  • 1.7.1 Extremely Slow - Refactored PHPExcel_Calculation_Functions::flattenArray() method and set calculation cache timer default to 2.5 seconds - @MarkBaker CodePlex #10874
  • Allow formulae to contain line breaks - @MarkBaker
  • split() function deprecated in PHP 5.3.0 - @Erik Tilt CodePlex #10910
  • sys_get_temp_dir() requires PHP 5.2.1, not PHP 5.2 [provide fallback function for PHP 5.2.0] - @Erik Tilt
  • Implementation of the ISPMT() Financial function by Matt Groves - @MarkBaker
  • Put the example of formula with more arguments in documentation - @MarkBaker CodePlex #11052

Features

  • Improved accuracy for the GAMMAINV() Statistical Function - @MarkBaker
  • XFEXT record support to fix colors change from Excel5 reader, and copy/paste color change with Excel5 writer - @Erik Tilt CodePlex #10409
    • Excel5 reader reads RGB color information in XFEXT records for borders, font color and fill color- Implement more Excel calculation functions - @MarkBaker
    • Implemented the FVSCHEDULE(), XNPV(), IRR(), MIRR(), XIRR() and RATE() Financial functions
    • Implemented the SUMPRODUCT() Mathematical function
    • Implemented the ZTEST() Statistical Function- Multiple print areas in one sheet - @Erik Tilt CodePlex #10919
  • Store calculated values in output by PHPExcel_Writer_Excel5 - @Erik Tilt CodePlex #10930
  • Sheet protection options in Excel5 reader/writer - @Erik Tilt CodePlex #10939
  • Modification of the COUNT(), AVERAGE(), AVERAGEA(), DEVSQ, AVEDEV(), STDEV(), STDEVA(), STDEVP(), STDEVPA(), VARA() and VARPA() SKEW() and KURT() functions to correctly handle boolean values depending on whether they're passed in as values, values within a matrix or values within a range of cells. - @MarkBaker
  • Cell range selection - @Erik Tilt
  • Root-relative path handling - @MarkBaker CodePlex #10266

Bugfixes

  • Named Ranges not working with PHPExcel_Writer_Excel5 - @Erik Tilt CodePlex #11315
  • Excel2007 Reader fails to load Apache POI generated Excel - @MarkBaker CodePlex #11206
  • Number format is broken when system's thousands separator is empty - @MarkBaker CodePlex #11154
  • ReferenceHelper::updateNamedFormulas throws errors if oldName is empty - @MarkBaker CodePlex #11401
  • parse_url() fails to parse path to an image in xlsx - @MarkBaker CodePlex #11296
  • Workaround for iconv_substr() bug in PHP 5.2.0 - @Erik Tilt CodePlex #10876
  • 1 pixel error for image width and height with PHPExcel_Writer_Excel5 - @Erik Tilt CodePlex #10877
  • Fix to GEOMEAN() Statistical function - @MarkBaker
  • setValue('-') and setValue('.') sets numeric 0 instead of 1-character string - @Erik Tilt CodePlex #10884
  • Row height sometimes much too low after read with PHPExcel_Reader_Excel5 - @Erik Tilt CodePlex #10885
  • Diagonal border. Miscellaneous missing support. - @Erik Tilt CodePlex #10888
    • Constant PHPExcel_Style_Borders::DIAGONAL_BOTH added to support double-diagonal (cross)
    • PHPExcel_Reader_Excel2007 not always reading diagonal borders (only recognizes 'true' and not '1')
    • PHPExcel_Reader_Excel5 support for diagonal borders
    • PHPExcel_Writer_Excel5 support for diagonal borders- Session bug: Fatal error: Call to a member function bindValue() on a non-object in ...\Classes\PHPExcel\Cell.php on line 217 - @Erik Tilt CodePlex #10894
  • Colors messed up saving twice with same instance of PHPExcel_Writer_Excel5 (regression since 1.7.0) - @Erik Tilt CodePlex #10896
  • Method PHPExcel_Worksheet::setDefaultStyle is not working - @Erik Tilt CodePlex #10917
  • PHPExcel_Reader_CSV::canRead() sometimes says false when it shouldn't - @Erik Tilt CodePlex #10897
  • Changes in workbook not picked up between two saves with PHPExcel_Writer_Excel2007 - @Erik Tilt CodePlex #10922
  • Decimal and thousands separators missing in HTML and PDF output - @Erik Tilt CodePlex #10913
  • Notices with PHPExcel_Reader_Excel5 and named array constants - @Erik Tilt CodePlex #10936
  • Calculation engine limitation on 32-bit platform with integers > 2147483647 - @MarkBaker CodePlex #10938
  • Shared(?) formulae containing absolute cell references not read correctly using Excel5 Reader - @Erik Tilt CodePlex #10959
  • Warning messages with intersection operator involving single cell - @MarkBaker CodePlex #10962
  • Infinite loop in Excel5 reader caused by zero-length string in SST - @Erik Tilt CodePlex #10980
  • Remove unnecessary cell sorting to improve speed by approx. 18% in HTML and PDF writers - @Erik Tilt CodePlex #10983
  • Cannot read A1 cell content - OO_Reader - @MarkBaker CodePlex #10977
  • Transliteration failed, invalid encoding - @Erik Tilt CodePlex #11000

[1.7.1] - 2009-11-02

General

Features

  • Upgrade to TCPDF 4.8.009 - @Erik Tilt
  • Support for row and column styles (feature request) - @Erik Tilt
    • Basic implementation for Excel2007/Excel5 reader/writer- Hyperlink to local file in Excel5 reader/writer - @Erik Tilt CodePlex #10459
  • Color Tab (Color Sheet's name) - @MarkBaker CodePlex #10472
  • Border style "double" support in PHPExcel_Writer_HTML - @Erik Tilt CodePlex #10488
  • Multi-section number format support in HTML/PDF/CSV writers - @Erik Tilt CodePlex #10492
  • Some additional performance tweaks in the calculation engine - @MarkBaker
  • Fix result of DB() and DDB() Financial functions to 2dp when in Gnumeric Compatibility mode - @MarkBaker
  • Added AMORDEGRC(), AMORLINC() and COUPNUM() Financial function (no validation of parameters yet) - @MarkBaker
  • Improved accuracy of TBILLEQ(), TBILLPRICE() and TBILLYIELD() Financial functions when in Excel or Gnumeric mode - @MarkBaker
  • Added INDIRECT() Lookup/Reference function (only supports full addresses at the moment) - @MarkBaker
  • PHPExcel_Reader_CSV::canRead() improvements - @MarkBaker CodePlex #10498
  • Input encoding option for PHPExcel_Reader_CSV - @Erik Tilt CodePlex #10500
  • Colored number format support, e.g. [Red], in HTML/PDF output - @Erik Tilt CodePlex #10493
  • Color Tab (Color Sheet's name) [Excel5 reader/writer support] - @Erik Tilt CodePlex #10559
  • Initial version of SYLK (slk) and Excel 2003 XML Readers (Cell data and basic cell formatting) - @MarkBaker
  • Initial version of Open Office Calc (ods) Reader (Cell data only) - @MarkBaker
  • Initial use of "pass by reference" in the calculation engine for ROW() and COLUMN() Lookup/Reference functions - @MarkBaker
  • COLUMNS() and ROWS() Lookup/Reference functions, and SUBSTITUTE() Text function - @MarkBaker CodePlex #2346
  • AdvancedValueBinder(): Re-enable zero-padded string-to-number conversion, e.g '0004' -> 4 - @Erik Tilt CodePlex #10502
  • Make PHP type match Excel datatype - @Erik Tilt CodePlex #10600
  • Change first page number on header - @MarkBaker CodePlex #10630
  • Applied patch 3941 - @MarkBaker
  • Hidden sheets - @MB,ET CodePlex #10745
  • mbstring fallback when iconv is broken - @Erik Tilt CodePlex #10761
  • Note, can't yet handle comparison of two matrices - @MarkBaker
  • Improved handling for validation and error trapping in a number of functions - @MarkBaker
  • Improved support for fraction number formatting - @MarkBaker
  • Support Reading CSV with Byte Order Mark (BOM) - @Erik Tilt CodePlex #10455

Bugfixes

[1.7.0] - 2009-08-10

General

  • Expand documentation: Number formats - @Erik Tilt
  • Class 'PHPExcel_Cell_AdvancedValueBinder' not found - @Erik Tilt

Features

  • Change return type of date functions to PHPExcel_Calculation_Functions::RETURNDATE_EXCEL - @MarkBaker
  • New RPN and stack-based calculation engine for improved performance of formula calculation - @MarkBaker
    • Faster (anything between 2 and 12 times faster than the old parser, depending on the complexity and nature of the formula)
    • Significantly more memory efficient when formulae reference cells across worksheets
    • Correct behaviour when referencing Named Ranges that exist on several worksheets
    • Support for Excel ^ (Exponential) and % (Percentage) operators
    • Support for matrices within basic arithmetic formulae (e.g. ={1,2,3;4,5,6;7,8,9}/2)
    • Better trapping/handling of NaN and infinity results (return #NUM! error)
    • Improved handling of empty parameters for Excel functions
    • Optional logging of calculation steps- New calculation engine can be accessed independently of workbooks (for use as a standalone calculator) - @MarkBaker
  • Implement more Excel calculation functions - @MarkBaker
    • Initial implementation of the COUNTIF() and SUMIF() Statistical functions
    • Added ACCRINT() Financial function- Modifications to number format handling for dddd and ddd masks in dates, use of thousand separators even when locale only implements it for money, and basic fraction masks (0 ?/? and ?/?) - @MarkBaker
  • Support arbitrary fixed number of decimals in PHPExcel_Style_NumberFormat::toFormattedString() - @Erik Tilt
  • Improving performance and memory on data dumps - @Erik Tilt
    • Various style optimizations (merging from branch wi6857-memory)
    • Moving hyperlink and dataValidation properties from cell to worksheet for lower PHP memory usage- Provide fluent interfaces where possible - @MarkBaker
  • Make easy way to apply a border to a rectangular selection - @Erik Tilt
  • Support for system window colors in PHPExcel_Reader_Excel5 - @Erik Tilt
  • Horizontal center across selection - @Erik Tilt
  • Merged cells record, write to full record size in PHPExcel_Writer_Excel5 - @Erik Tilt
  • Add page break between sheets in exported PDF - @MarkBaker
  • Sanitization of UTF-8 input for cell values - @Erik Tilt
  • Read cached calculated value with PHPExcel_Reader_Excel5 - @Erik Tilt
  • Miscellaneous CSS improvements for PHPExcel_Writer_HTML - @Erik Tilt
  • getProperties: setCompany feature request - @Erik Tilt
  • Insert worksheet at a specified index - @MarkBaker
  • Change worksheet index - @MarkBaker
  • Readfilter for CSV reader - @MarkBaker
  • Check value of mbstring.func_overload when saving with PHPExcel_Writer_Excel5 - @Erik Tilt CodePlex #10172
  • Eliminate dependency of an include path pointing to class directory - @Erik Tilt CodePlex #10251
  • Method for getting the correct reader for a certain file (contribution) - @Erik Tilt CodePlex #10292
  • Choosing specific row in fromArray method - @Erik Tilt CodePlex #10287
  • Shared formula support in PHPExcel_Reader_Excel5 - @Erik Tilt CodePlex #10319

Bugfixes

  • Right-to-left column direction in worksheet - @MB,ET CodePlex #10345
  • PHPExcel_Reader_Excel5 not reading PHPExcel_Style_NumberFormat::FORMAT_NUMBER ('0') - @Erik Tilt
  • Fractional row height in locale other than English results in corrupt output using PHPExcel_Writer_Excel2007 - @Erik Tilt
  • Fractional (decimal) numbers not inserted correctly when locale is other than English - @Erik Tilt
  • Fractional calculated value in locale other than English results in corrupt output using PHPExcel_Writer_Excel2007 - @Erik Tilt
  • Locale aware decimal and thousands separator in exported formats HTML, CSV, PDF - @Erik Tilt
  • Cannot Add Image with Space on its Name - @MarkBaker
  • Black line at top of every page in output by PHPExcel_Writer_PDF - @Erik Tilt
  • Border styles and border colors not showing in HTML output (regression since 1.6.4) - @Erik Tilt
  • Hidden screen gridlines setting in worksheet not read by PHPExcel_Reader_Excel2007 - @Erik Tilt
  • Some valid sheet names causes corrupt output using PHPExcel_Writer_Excel2007 - @MarkBaker
  • More than 32,767 characters in a cell gives corrupt Excel file - @Erik Tilt
  • Images not getting copyied with the ->copy() function - @Erik Tilt
  • Bad calculation of column width setAutoSize(true) function - @Erik Tilt
  • Dates are sometimes offset by 1 day in output by HTML and PDF writers depending on system timezone setting - @Erik Tilt
  • Wingdings symbol fonts not working with PHPExcel_Writer_Excel5 - @Erik Tilt CodePlex #10003
  • White space string prefix stripped by PHPExcel_Writer_Excel2007 - @MarkBaker CodePlex #10010
  • The name of the Workbook stream MUST be "Workbook", not "Book" - @Erik Tilt CodePlex #10023
  • Avoid message "Microsoft Excel recalculates formulas..." when closing xls file from Excel - @Erik Tilt CodePlex #10030
  • Non-unique newline representation causes problems with LEN formula - @Erik Tilt CodePlex #10031
  • Newline in cell not showing with PHPExcel_Writer_HTML and PHPExcel_Writer_PDF - @Erik Tilt CodePlex #10033
  • Rich-Text strings get prefixed by   when output by HTML writer - @Erik Tilt CodePlex #10046
  • Leading spaces do not appear in output by HTML/PDF writers - @Erik Tilt CodePlex #10052
  • Empty Apache POI-generated file can not be read - @MarkBaker CodePlex #10061
  • Column width not scaling correctly with font size in HTML and PDF writers - @Erik Tilt CodePlex #10068
  • Inaccurate row heights with HTML writer - @Erik Tilt CodePlex #10069
  • Reference helper - @MarkBaker
  • Excel 5 Named ranges should not be local to the worksheet, but accessible from all worksheets - @MarkBaker
  • Row heights are ignored by PHPExcel_Writer_PDF - @Erik Tilt CodePlex #10088
  • Write raw XML - @MarkBaker
  • removeRow(), removeColumn() not always clearing cell values - @Erik Tilt CodePlex #10098
  • Problem reading certain hyperlink records with PHPExcel_Reader_Excel5 - @Erik Tilt CodePlex #10142
  • Hyperlink cell range read failure with PHPExcel_Reader_Excel2007 - @Erik Tilt CodePlex #10143
  • 'Column string index can not be empty.' - @MarkBaker CodePlex #10149
  • getHighestColumn() sometimes says there are 256 columns with PHPExcel_Reader_Excel5 - @Erik Tilt CodePlex #10204
  • extractSheetTitle fails when sheet title contains exclamation mark (!) - @Erik Tilt CodePlex #10220
  • setTitle() sometimes erroneously appends integer to sheet name - @Erik Tilt CodePlex #10221
  • Mac BIFF5 Excel file read failure (missing support for Mac OS Roman character set) - @Erik Tilt CodePlex #10229
  • BIFF5 header and footer incorrectly read by PHPExcel_Reader_Excel5 - @Erik Tilt CodePlex #10230
  • iconv notices when reading hyperlinks with PHPExcel_Reader_Excel5 - @Erik Tilt CodePlex #10259
  • Excel5 reader OLE read failure with small Mac BIFF5 Excel files - @Erik Tilt CodePlex #10252
  • Problem in reading formula : IF( IF ) with PHPExcel_Reader_Excel5 - @Erik Tilt CodePlex #10272
  • Error reading formulas referencing external sheets with PHPExcel_Reader_Excel5 - @Erik Tilt CodePlex #10274
  • Image horizontally stretched when default font size is increased (PHPExcel_Writer_Excel5) - @Erik Tilt CodePlex #10291
  • Undefined offset in Reader\Excel5.php on line 3572 - @Erik Tilt CodePlex #10333
  • PDF output different then XLS (copied data) - @MarkBaker CodePlex #10340
  • Internal hyperlinks with UTF-8 sheet names not working in PHPExcel_Writer_Excel5 - @Erik Tilt CodePlex #10352
  • String shared formula result read error with PHPExcel_Reader_Excel5 - @Erik Tilt CodePlex #10361
  • Uncaught exception 'Exception' with message 'Valid scale is between 10 and 400.' in Classes/PHPExcel/Worksheet/PageSetup.php:338 - @Erik Tilt CodePlex #10363
  • Using setLoadSheetsOnly fails if you do not use setReadDataOnly(true) and sheet is not the first sheet - @Erik Tilt CodePlex #10355
  • getCalculatedValue() sometimes incorrect with IF formula and 0-values - @MarkBaker CodePlex #10362
  • Excel Reader 2007 problem with "shared" formulae when "master" is an error - @MarkBaker
  • Named Range Bug, using the same range name on different worksheets - @MarkBaker
  • Java code in JAMA classes - @MarkBaker
  • getCalculatedValue() not working with some formulas involving error types - @MarkBaker
  • evaluation of both return values in an IF() statement returning an error if either result was an error, irrespective of the IF evaluation - @MarkBaker
  • Power in formulas: new calculation engine no longer treats ^ as a bitwise XOR operator - @MarkBaker
  • Bugfixes and improvements to many of the Excel functions in PHPExcel - @MarkBaker
    • Added optional "places" parameter in the BIN2HEX(), BIN2OCT, DEC2BIN(), DEC2OCT(), DEC2HEX(), HEX2BIN(), HEX2OCT(), OCT2BIN() and OCT2HEX() Engineering Functions
    • Trap for unbalanced matrix sizes in MDETERM() and MINVERSE() Mathematic and Trigonometric functions
    • Fix for default characters parameter value for LEFT() and RIGHT() Text functions
    • Fix for GCD() and LCB() Mathematical functions when the parameters include a zero (0) value
    • Fix for BIN2OCT() Engineering Function for 2s complement values (which were returning hex values)
    • Fix for BESSELK() and BESSELY() Engineering functions
    • Fix for IMDIV() Engineering Function when result imaginary component is positive (wasn't setting the sign)
    • Fix for ERF() Engineering Function when called with an upper limit value for the integration
    • Fix to DATE() Date/Time Function for year value of 0
    • Set ISPMT() function as category FINANCIAL
    • Fix for DOLLARDE() and DOLLARFR() Financial functions
    • Fix to EFFECT() Financial function (treating $nominal_rate value as a variable name rather than a value)
    • Fix to CRITBINOM() Statistical function (CurrentValue and EssentiallyZero treated as constants rather than variables)
    • Note that an Error in the function logic can still lead to a permanent loop
    • Fix to MOD() Mathematical function to work with floating point results
    • Fix for QUOTIENT() Mathematical function
    • Fix to HOUR(), MINUTE() and SECOND() Date/Time functions to return an error when passing in a floating point value of 1.0 or greater, or less than 0
    • LOG() Function now correctly returns base-10 log when called with only one parameter, rather than the natural log as the default base
    • Modified text functions to handle multibyte character set (UTF-8).

[1.6.7] - 2009-04-22

BREAKING CHANGE

In previous versions of PHPExcel up to and including 1.6.6, when a cell had a date-like number format code, it was possible to enter a date directly using an integer PHP-time without converting to Excel date format. Starting with PHPExcel 1.6.7 this is no longer supported. Refer to the developer documentation for more information on entering dates into a cell.

General

Features

Bugfixes

[1.6.6] - 2009-03-02

General

Features

Bugfixes

  • Eliminate duplicate style entries in multisheet workbook written by PHPExcel_Writer_Excel5 - @Erik Tilt CodePlex #9355
  • Redirect to client browser fails due to trailing white space in class definitions - @Erik Tilt CodePlex #8810
  • Spurious column dimension element introduced in blank worksheet after using PHPExcel_Writer_Excel2007 - @MarkBaker CodePlex #8816
  • Image gets slightly narrower than expected when using PHPExcel_Writer_Excel5 - @Erik Tilt CodePlex #8830
  • Image laid over non-visible row gets squeezed in height when using PHPExcel_Writer_Excel5 - @Erik Tilt CodePlex #8831
  • PHPExcel_Reader_Excel5 fails when there are 10 or more images in the workbook - @Erik Tilt CodePlex #8860
  • Different header/footer images in different sheets not working with PHPExcel_Writer_Excel2007 - @MarkBaker CodePlex #8909
  • Fractional seconds disappear when using PHPExcel_Reader_Excel2007 and PHPExcel_Reader_Excel5 - @MB, ET CodePlex #8924
  • Images not showing in OpenOffice when using PHPExcel_Writer_Excel5 - @Erik Tilt CodePlex #7994
  • Images not showing on print using PHPExcel_Writer_Excel5 - @Erik Tilt CodePlex #9047
  • PHPExcel_Writer_Excel5 maximum allowed record size 4 bytes too short - @Erik Tilt CodePlex #9085
  • Not numeric strings are formatted as dates and numbers using worksheet's toArray method - @MarkBaker CodePlex #9119
  • Excel5 simple formula parsing error - @Erik Tilt CodePlex #9132
  • Problems writing dates with CSV - @Erik Tilt CodePlex #9206
  • PHPExcel_Reader_Excel5 reader fails with fatal error when reading group shapes - @Erik Tilt CodePlex #9203
  • PHPExcel_Writer_Excel5 fails completely when workbook contains more than 57 colors - @Erik Tilt CodePlex #9231
  • PHPExcel_Writer_PDF not compatible with autoload - @Erik Tilt CodePlex #9244
  • Fatal error: Call to a member function getNestingLevel() on a non-object in PHPExcel/Reader/Excel5.php on line 690 - @Erik Tilt CodePlex #9250
  • Notices when running test 04printing.php on PHP 5.2.8 - @MarkBaker CodePlex #9246
  • insertColumn() spawns creation of spurious RowDimension - @MarkBaker CodePlex #9294
  • Fix declarations for methods in extended Trend classes - @MarkBaker CodePlex #9296
  • Fix to parameters for the FORECAST Statistical Function - @MarkBaker CodePlex #2346
  • PDF writer problems with cell height and text wrapping - @MarkBaker CodePlex #7083
  • Fix test for calculated value in case the returned result is an array - @MarkBaker
  • Column greater than 256 results in corrupt Excel file using PHPExcel_Writer_Excel5 - @Erik Tilt
  • Excel Numberformat 0.00 results in non internal decimal places values in toArray() Method - @MarkBaker CodePlex #9351
  • setAutoSize not taking into account text rotation - @MB,ET CodePlex #9356
  • Call to undefined method PHPExcel_Worksheet_MemoryDrawing::getPath() in PHPExcel/Writer/HTML.php - @Erik Tilt CodePlex #9372

[1.6.5] - 2009-01-05

General

  • Applied patch 2063 - @MarkBaker
  • Optimise Shared Strings - @MarkBaker
  • Optimise Cell Sorting - @MarkBaker
  • Optimise Style Hashing - @MarkBaker
  • UTF-8 enhancements - @Erik Tilt
  • PHPExcel_Writer_HTML validation errors against strict HTML 4.01 / CSS 2.1 - @Erik Tilt
  • Documented work items 6203 and 8110 in manual - @MarkBaker
  • Restructure package hierachy so classes can be found more easily in auto-generated API (from work item 8468) - @Erik Tilt

Features

  • Redirect output to a client's browser: Update recommendation in documentation - @MarkBaker CodePlex #8806
  • PHPExcel_Reader_Excel5 support for print gridlines - @Erik Tilt CodePlex #7897
  • Screen gridlines support in Excel5 reader/writer - @Erik Tilt CodePlex #7899
  • Option for adding image to spreadsheet from image resource in memory - @MB, ET CodePlex #7552
  • PHPExcel_Reader_Excel5 style support for BIFF5 files (Excel 5.0 - Excel 95) - @Erik Tilt CodePlex #7862
  • PHPExcel_Reader_Excel5 support for user-defined colors and special built-in colors - @Erik Tilt CodePlex #7918
  • Support for freeze panes in PHPExcel_Reader_Excel5 - @Erik Tilt CodePlex #7992
  • Support for header and footer margins in PHPExcel_Reader_Excel5 - @Erik Tilt CodePlex #7996
  • Support for active sheet index in Excel5 reader/writer - @Erik Tilt CodePlex #7997
  • Freeze panes not read by PHPExcel_Reader_Excel2007 - @MarkBaker CodePlex #7991
  • Support for screen zoom level (feature request) - @MB, ET CodePlex #7993
  • Support for default style in PHPExcel_Reader_Excel5 - @Erik Tilt CodePlex #8012
  • Apple iWork / Numbers.app incompatibility - @MarkBaker CodePlex #8094
  • Support "between rule" in conditional formatting - @MarkBaker CodePlex #7931
  • Comment size, width and height control (feature request) - @MarkBaker CodePlex #8308
  • Improve method for storing MERGEDCELLS records in PHPExcel_Writer_Excel5 - @Erik Tilt CodePlex #8418
  • Support for protectCells() in Excel5 reader/writer - @Erik Tilt CodePlex #8435
  • Support for fitToWidth and fitToHeight pagesetup properties in PHPExcel_Reader_Excel5 - @Erik Tilt CodePlex #8472
  • Support for setShowSummaryBelow() and setShowSummaryRight() in PHPExcel_Writer_Excel5 - @Erik Tilt CodePlex #8489
  • Support for Excel 1904 calendar date mode (Mac) - @MarkBaker CodePlex #8483
  • Excel5 reader: Support for reading images (bitmaps) - @Erik Tilt CodePlex #7538
  • Support for default style in PHPExcel_Writer_Excel5 - @Erik Tilt CodePlex #8787
  • Modified calculate() method to return either an array or the first value from the array for those functions that return arrays rather than single values (e.g the MMULT and TRANSPOSE function). This performance can be modified based on the $returnArrayAsType which can be set/retrieved by calling the setArrayReturnType() and getArrayReturnType() methods of the PHPExcel_Calculation class. - @MarkBaker

Bugfixes

[1.6.4] - 2008-10-27

Features

Bugfixes

[1.6.3] - 2008-08-25

General

Features

Bugfixes

[1.6.2] - 2008-06-23

General

  • Document style array values - @MarkBaker CodePlex #6088
  • Applied patch 1195 - @MarkBaker
  • Redirecting output to a client’s web browser - http headers - @MarkBaker CodePlex #6178
  • Improve worksheet garbage collection - @MarkBaker CodePlex #6187
  • Functions that return date values can now be configured to return as Excel serialized date/time, PHP serialized date/time, or a PHP date/time object. - @MarkBaker
  • Functions that explicitly accept dates as parameters now permit values as Excel serialized date/time, PHP serialized date/time, a valid date string, or a PHP date/time object. - @MarkBaker
  • Implement ACOSH, ASINH and ATANH functions for those operating platforms/PHP versions that don't include these functions - @MarkBaker
  • Implement ATAN2 logic reversing the arguments as per Excel - @MarkBaker
  • Additional validation of parameters for COMBIN - @MarkBaker

Features

Bugfixes

[1.6.1] - 2008-04-28

General

Features

Bugfixes

[1.6.0] - 2008-02-14

Features

Bugfixes

[1.5.5] - 2007-12-24

General

Features

  • Semi-nightly builds - @MarkBaker CodePlex #4427
  • Implement "date" datatype - @MarkBaker CodePlex #3155
  • Date format not honored in CSV writer - @MarkBaker CodePlex #4150
  • RichText and sharedStrings - @MarkBaker CodePlex #4199
  • Implement more Excel calculation functions - @MarkBaker CodePlex #2346
    • Addition of DATE, DATEDIF, DATEVALUE, DAY, DAYS360- Implement more Excel calculation functions - @MarkBaker CodePlex #2346
    • Addition of AVEDEV, HARMEAN and GEOMEAN
    • Addition of the BINOMDIST (Non-cumulative only), COUNTBLANK, EXPONDIST, FISHER, FISHERINV, NORMDIST, NORMSDIST, PERMUT, POISSON (Non-cumulative only) and STANDARDIZE Statistical Functions
    • Addition of the CEILING, COMBIN, EVEN, FACT, FACTDOUBLE, FLOOR, MULTINOMIAL, ODD, ROUNDDOWN, ROUNDUP, SIGN, SQRTPI and SUMSQ Mathematical Functions
    • Addition of the NORMINV, NORMSINV, CONFIDENCE and SKEW Statistical Functions
    • Addition of the CRITBINOM, HYPGEOMDIST, KURT, LOGINV, LOGNORMDIST, NEGBINOMDIST and WEIBULL Statistical Functions
    • Addition of the LARGE, PERCENTILE, QUARTILE, SMALL and TRIMMEAN Statistical Functions
    • Addition of the BIN2HEX, BIN2OCT, DELTA, ERF, ERFC, GESTEP, HEX2BIN, HEX2DEC, HEX2OCT, OCT2BIN and OCT2HEX Engineering Functions
    • Addition of the CHIDIST, GAMMADIST and GAMMALN Statistical Functions
    • Addition of the GCD, LCM, MROUND and SUBTOTAL Mathematical Functions
    • Addition of the LOWER, PROPER and UPPER Text Functions
    • Addition of the BETADIST and BETAINV Statistical Functions
    • Addition of the CHIINV and GAMMAINV Statistical Functions
    • Addition of the SERIESSUM Mathematical Function
    • Addition of the CHAR, CODE, FIND, LEN, REPT, SEARCH, T, TRIM Text Functions
    • Addition of the FALSE and TRUE Boolean Functions
    • Addition of the TDIST and TINV Statistical Functions
    • Addition of the EDATE, EOMONTH, YEAR, MONTH, TIME, TIMEVALUE, HOUR, MINUTE, SECOND, WEEKDAY, WEEKNUM, NOW, TODAY and Date/Time Function
    • Addition of the BESSELI, BESSELJ, BESSELK and BESSELY Engineering Functions
    • Addition of the SLN and SYD Financial Functions
    • reworked MODE calculation to handle floating point numbers
    • Improved error trapping for invalid input values
    • Fix to SMALL, LARGE, PERCENTILE and TRIMMEAN to eliminate non-numeric values
    • Added CDF to BINOMDIST and POISSON
    • Fix to a potential endless loop in CRITBINOM, together with other bugfixes to the algorithm
    • Fix to SQRTPI so that it will work with a real value parameter rather than just integers
    • Trap for passing negative values to FACT
    • Improved accuracy of the NORMDIST cumulative function, and of the ERF and ERFC functions
    • Replicated Excel data-type and error handling for BIN, DEC, OCT and HEX conversion functions
    • Replicated Excel data-type and error handling for AND and OR Boolean functions
    • Bugfix to MROUND
    • Rework of the DATE, DATEVALUE, DAY, DAYS360 and DATEDIF date/Time functions to use Excel dates rather than straight PHP dates
    • Rework of the AND, OR Boolean functions to ignore string values
    • Rework of the BIN2DEC, BIN2HEX, BIN2OCT, DEC2BIN, DEC2HEX, DEC2OCT Engineering functions to handle two's complement
    • Excel, Gnumeric and OpenOffice Calc compatibility flag for functions
    • Note, not all functions have yet been written to work with the Gnumeric and OpenOffice Calc compatibility flags
    • 1900 or 1904 Calendar flag for date functions
    • Reworked ExcelToPHP date method to handle the Excel 1900 leap year
    • Note that this will not correctly return values prior to 13-Dec-1901 20:45:52 as this is the minimum value that PHP date serial values can handle. If you need to work with dates prior to this, then an ExcelToPHPObject method has been added which will work correctly with values between Excel's 1900 calendar base date of 1-Jan-1900, and 13-Dec-1901
    • Addition of ExcelToPHPObject date method to return a PHP DateTime object from an Excel date serial value
    • PHPToExcel method modified to accept either PHP date serial numbers or PHP DateTime objects
    • Addition of FormattedPHPToExcel which will accept a date and time broken to into year, month, day, hour, minute, second and return an Excel date serial value- Control characters in Excel 2007 - @MarkBaker CodePlex #4485
  • BaseDrawing::setWidthAndHeight method request - @MarkBaker CodePlex #4796
  • Page Setup -> Print Titles -> Sheet -> 'Rows to repeat at top' - @MarkBaker CodePlex #4798

Bugfixes

[1.5.0] - 2007-10-23

Features

Bugfixes

[1.4.5] - 2007-08-23

General

Features

Bugfixes

[1.4.0] - 2007-07-23

General

Features

Bugfixes

[1.3.5] - 2007-06-27

Features

Bugfixes

[1.3.0] - 2007-06-05

General

Features

Bugfixes

[1.2.0] - 2007-04-26

General

  • Stringtable attribute "count" not necessary, provides wrong info to Excel sometimes... - @MarkBaker
  • Updated tests to address more document properties - @MarkBaker
  • Some refactoring in PHPExcel_Writer_Excel2007_Workbook - @MarkBaker
  • New package: PHPExcel_Shared - @MarkBaker
  • Password hashing algorithm implemented in PHPExcel_Shared_PasswordHasher - @MarkBaker
  • Moved pixel conversion functions to PHPExcel_Shared_Drawing - @MarkBaker
  • Switch over to LGPL license - @MarkBaker CodePlex #244

Features

Bugfixes

[1.1.1] - 2007-03-26

General

[1.1.0] - 2007-03-22

Bugfixes

General

Features

[1.0.0] - 2007-02-22

Bugfixes

  • PHPExcel->removeSheetByIndex now re-orders sheets after deletion, so no array indexes are lost - @JV
  • PHPExcel_Writer_Excel2007_Worksheet::_writeCols() used direct assignment to $pSheet->getColumnDimension('A')->Width instead of $pSheet->getColumnDimension('A')->setWidth() - @JV
  • DocumentProperties used $this->LastModifiedBy instead of $this->_lastModifiedBy. - @JV

General

  • Only first = should be removed when writing formula in PHPExcel_Writer_Excel2007_Worksheet. - @JV
  • Consistency of method names to camelCase - @JV
  • Updated tests to match consistency changes - @JV
  • Detection of mime-types now with image_type_to_mime_type() - @JV
  • Constants now hold string value used in Excel 2007 - @JV

Features

  • Fixed folder name case (WorkSheet -> Worksheet) - @MarkBaker
  • PHPExcel classes (not the Writer classes) can be duplicated, using a duplicate() method. - @MarkBaker
  • Cell styles can now be duplicated to a range of cells using PHPExcel_Worksheet->duplicateStyle() - @MarkBaker
  • Conditional formatting - @MarkBaker
  • Reader for Excel 2007 (not supporting full specification yet!) - @JV

[1.0.0 RC] - 2007-01-31

2007-01-22

  • Fixed some performance issues on large-scale worksheets (mainly loops vs. indexed arrays)
  • Performance on creating StringTable has been increased
  • Performance on writing Excel2007 worksheet has been increased

2007-01-18

  • Images can now be rotated
  • Fixed bug: When drawings have full path specified, no mime type can be deducted
  • Fixed bug: Only one drawing can be added to a worksheet

2007-01-12

  • Refactoring of some classes to use ArrayObject instead of array()
  • Cell style now has support for number format (i.e. #,##0)
  • Implemented embedding images

2007-01-02

  • Cell style now has support for fills, including gradient fills
  • Cell style now has support for fonts
  • Cell style now has support for border colors
  • Cell style now has support for font colors
  • Cell style now has support for alignment

2006-12-21

  • Support for cell style borders
  • Support for cell styles
  • Refactoring of Excel2007 Writer into multiple classes in package SpreadSheet_Writer_Excel2007
  • Refactoring of all classes, changed public members to public properties using getter/setter
  • Worksheet names are now unique. On duplicate worksheet names, a number is appended.
  • Worksheet now has parent SpreadSheet object
  • Worksheet now has support for page header and footer
  • Worksheet now has support for page margins
  • Worksheet now has support for page setup (only Paper size and Orientation)
  • Worksheet properties now accessible by using getProperties()
  • Worksheet now has support for row and column dimensions (height / width)
  • Exceptions thrown have a more clear description

Initial version

  • Create a Spreadsheet object
  • Add one or more Worksheet objects
  • Add cells to Worksheet objects
  • Export Spreadsheet object to Excel 2007 OpenXML format
  • Each cell supports the following data formats: string, number, formula, boolean.