d:\wwwroot\wuchunhua\thinkphp\vendor\phpoffice\phpexcel\changelog.txt
001:
**************************************************************************************
002:
* PHPExcel
003:
*
004:
* Copyright (c) 2006 - 2014 PHPExcel
005:
*
006:
* This library is free software; you can redistribute it and/or
007:
* modify it under the terms of the GNU Lesser General Public
008:
* License as published by the Free Software Foundation; either
009:
* version 2.1 of the License, or (at your option) any later version.
010:
*
011:
* This library is distributed in the hope that it will be useful,
012:
* but WITHOUT ANY WARRANTY; without even the implied warranty of
013:
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
014:
* Lesser General Public License for more details.
015:
*
016:
* You should have received a copy of the GNU Lesser General Public
017:
* License along with this library; if not, write to the Free Software
018:
* Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
019:
*
020:
* @copyright Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
021:
* @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL
022:
* @version ##VERSION##, ##DATE##
023:
**************************************************************************************
024:
025:
026:
Planned for 1.8.2
027:
- Bugfix: (MBaker) - Fix to getCell() method when cell reference includes a worksheet reference
028:
- Bugfix: (ncrypthic) Work Item GH-570 - Ignore inlineStr type if formula element exists
029:
- Bugfix: (hernst42) Work Item GH-709 - Fixed missing renames of writeRelationShip (from _writeRelationShip)
030:
- General: (umpirsky) Work Item GH-548 - Optimize vlookup() sort
031:
- Bugfix: (MBaker) Work Item GH-554 - Whitespace after toRichTextObject()
032:
- Feature: (MBaker) - Initial implementation of SUMIFS() function
033:
- Feature: (MBaker) - Additional codepages
034:
- Feature: (Tomino2112) Work Item GH-808 - MemoryDrawing not working in HTML writer
035:
- General: (rentalhost) Work Item GH-575 - Excel 2007 Reader freezes because of conditional formatting
036:
- Bugfix: (vitalyrepin) Pull Request 869 - c:max and c:min elements shall NOT be inside c:orientation elements
037:
- General: (sim642) Pull Request 489 - Implement actual timezone adjustment into PHPExcel_Shared_Date::PHPToExcel
038:
039:
040:
2015-04-30 (v1.8.1):
041:
- Bugfix: (goncons) Work Item GH-397 - Fix for Writing an Open Document cell with non-numeric formula
042:
- Bugfix: (sarciszewski) Work Item GH-329 - Avoid potential divide by zero in basedrawing
043:
- Bugfix: (ymaerschalck) Work Item GH-405 - XML External Entity (XXE) Processing, different behaviour between simplexml_load_string() and simplexml_load_file().
044:
- Bugfix: (MBaker) - Fix to ensure that current cell is maintained when executing formula calculations
045:
- Bugfix: (MBaker) Work Item GH-350 - Keep/set the value on Reader _loadSheetsOnly as NULL, courtesy of Restless-ET
046:
- Bugfix: (MBaker) Work Item CP18105 - Loading an Excel 2007 spreadsheet throws an "Autofilter must be set on a range of cells" exception
047:
- Bugfix: (MBaker) Work Item GH-388 - Fix to autoloader registration for backward compatibility with PHP 5.2.0 not accepting the prepend flag
048:
- Bugfix: (MBaker) Work Item GH-384 - DOM loadHTMLFile() failing with options flags when using PHP < 5.4.0
049:
- Bugfix: (MBaker) - Fix for percentage operator in formulae for BIFF Writer
050:
- Bugfix: (MBaker) - Fix to getStyle() call for cell object
051:
- Bugfix: (MBaker) - Discard Autofilters in Excel2007 Reader when filter range isn't a valid range
052:
- Bugfix: (frozenstupidity) Work Item GH-423 - Fix invalid NA return in VLOOKUP
053:
- Bugfix: (wiseloren) Work Item CP21454 - "No Impact" conditional formatting fix for NumberFormat
054:
- Bugfix: (bobwitlox) Work Item GH-467 - Bug in Excel2003XML reader, parsing merged cells
055:
- Bugfix: (MBaker) Work Item GH-302 - Fix for CEIL() and FLOOR() when number argument is zero
056:
- Bugfix: (MBaker) - Remove cells cleanly when calling RemoveRow() or RemoveColumn()
057:
- General: (MBaker) - Small performance improvement for autosize columns
058:
- General: (frost-nzcr4) Work Item GH-379 - Change the getter/setter for zeroHeight to camel case
059:
- General: (MBaker) Work Item GH-394 - DefaultValueBinder is too much aggressive when converting string to numeric
060:
- General: (MBaker) - Default precalculate formulas to false for writers
061:
- General: (MBaker) - Set default Cyclic Reference behaviour to 1 to eliminate exception when using a single cyclic iteration in formulae
062:
- General: (MBaker) Work Item GH-396 - Some Excel writer libraries erroneously use Codepage 21010 for UTF-16LE
063:
- Feature: (WiktrzGE) Work Item GH-404 - Methods to manage most of the existing options for Chart Axis, Major Grid-lines and Minor Grid-lines
064:
- Feature: (frost-nzcr4) Work Item GH-403 - ODS read/write comments in the cell
065:
- Feature: (CQD) Work Item GH-389 - Additional Mac CJK codepage definitions
066:
- Feature: (bolovincev) Work Item GH-269 - Update Worksheet.php getStyleByColumnAndRow() to allow a range of cells rather than just a single cell
067:
- Feature: (MBaker) - New methods added for testing cell status within merge groups
068:
- Feature: (cifren/MBaker) Work Item GH-205 - Handling merge cells in HTML Reader
069:
- Feature: (MBaker) - Helper to convert basic HTML markup to a Rich Text object
070:
- Feature: (MBaker) - Improved Iterators
071:
New Column Iterator
072:
Support for row and column ranges
073:
Improved handling for next/prev
074:
- Security: (MBaker) - XML filescan in XML-based Readers to prevent XML Entity Expansion (XEE)
075:
(see http://projects.webappsec.org/w/page/13247002/XML%20Entity%20Expansion for an explanation of XEE injection) attacks
076:
Reference CVE-2015-3542 - Identification of problem courtesy of Dawid Golunski (Pentest Ltd.)
077:
078:
2014-03-02 (v1.8.0):
079:
- Bugfix: (MBaker) Work item CP19830 - Undefined variable: fileHandle in CSV Reader
080:
- Bugfix: (MBaker) Work item CP19968 - Out of memory in style/supervisor.php
081:
- Bugfix: (MBaker) - Style error with merged cells in PDF Writer
082:
- Bugfix: (MBaker) - Problem with cloning worksheets
083:
- Bugfix: (tavoarcila) Work Item GH-259 - Bug fix reading Open Office files
084:
- Bugfix: (MBaker) Work item CP20397 - Serious bug in absolute cell reference used in shared formula
085:
Would also have affected insert/delete column/row
086:
- Bugfix: (RomanSyroeshko) Work Item GH-267 - CHOOSE() returns "#VALUE!" if the 1st entry is chosen
087:
- Bugfix: (Gemorroj) Work Item GH-268 - When duplicating styles, styles shifted by one column to the right
088:
Fix also applied to duplicating conditional styles
089:
- Bugfix: (IndrekHaav) Work Item GH-212 - Fix for formulae that reference a sheet whose name begins with a digit:
090:
these were erroneously identified as numeric values, causing the parser to throw an undefined variable error.
091:
- Bugfix: (IndrekHaav) Work Item CP16208 - Fixed undefined variable error due to $styleArray being used before it's initialised
092:
- Bugfix: (PowerKiKi) Work Item GH-273 - ISTEXT() return wrong result if referencing an empty but formatted cell
093:
- Bugfix: (PowerKiKi) Work Item GH-270/GH-31 - Binary comparison of strings are case insensitive
094:
- Bugfix: (MBaker) Work Item GH-275 - Insert New Row/Column Before is not correctly updating formula references
095:
- 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
096:
- Bugfix: (MBaker) Work Item GH-193 - Fix to empty worksheet garbage collection when using cell caching
097:
- Bugfix: (Jazzo) Work Item GH-248 - Excel2007 does not correctly mark rows as hidden
098:
- Bugfix: (Roy Shahbazian) Work Item GH-299 - Fixed typo in Chart/Layout set/getYMode()
099:
- 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
100:
- Bugfix: (MBaker) Work Item GH-290 - AdvancedValueBinder "Division by zero"-error
101:
- Bugfix: (MBaker) Work Item CP20604 - Adding Sheet to Workbook Bug
102:
- Bugfix: (MBaker) Work item CP20703 - Calculation engine incorrectly evaluates empty cells as #VALUE
103:
- Bugfix: (MBaker) Work item CP20760 - Formula references to cell on another sheet in ODS files
104:
- Bugfix: (MBaker) Work item GH321,GH158,CP17824 - LibreOffice created XLSX files results in an empty file.
105:
- Feature: (amerov) - Implementation of the Excel HLOOKUP() function
106:
- Feature: (MBaker) - Added "Quote Prefix" to style settings (Excel2007 Reader and Writer only)
107:
- Feature: (MBaker) - Added Horizontal FILL alignment for Excel5 and Excel2007 Readers/Writers, and Horizontal DISTRIBUTED alignment for Excel2007 Reader/Writer
108:
- Feature: (trvrnrth) Work Item GH-261 - Add support for reading protected (RC4 encrypted) .xls files
109:
- Feature: (LWol) Work Item GH-252 - Adding support for macros, Ribbon in Excel 2007
110:
- General: (cdhutch) Work item CP20055 - Remove array_shift in ReferenceHelper::insertNewBefore improves column or row delete speed
111:
- General: (MBaker) - Improve stock chart handling and rendering, with help from Swashata Ghosh
112:
- General: (MBaker) - Fix to calculation properties for Excel2007 so that the opening application will only recalculate on load if it's actually required
113:
- General: (MBaker) - Modified Excel2007 Writer to default preCalculateFormulas to false
114:
Note that autosize columns will still recalculate affected formulae internally
115:
- General: (dresenhista) Work Item GH-242 - Functionality to getHighestRow() for a specified column, and getHighestColumn() for a specified row
116:
- General: (adamriyadi) Work Item GH-247 - Modify PHPExcel_Reader_Excel2007 to use zipClass from PHPExcel_Settings::getZipClass()
117:
This allows the use of PCLZip when reading for people that don't have access to ZipArchive
118:
- General: (infojunkie) Work Item GH-276 - Convert properties to string in OOCalc reader
119:
- Security: (maartenba) Work Item GH-322 - Disable libxml external entity loading by default.
120:
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).
121:
Reference CVE-2014-2054
122:
123:
124:
2013-06-02 (v1.7.9):
125:
- Feature: (MBaker) Include charts option for HTML Writer
126:
- Feature: (MBaker) Added composer file
127:
- Feature: (MBaker) Added getStyle() method to Cell object
128:
- Bugfix: (Asker) Work item 18777 - Error in PHPEXCEL/Calculation.php script on line 2976 (stack pop check)
129:
- Bugfix: (MBaker) Work item 18794 - CSV files without a file extension being identified as HTML
130:
- Bugfix: (AndreKR) Work item GH-66 - Wrong check for maximum number of rows in Excel5 Writer
131:
- Bugfix: (MBaker) Work item GH-67 - Cache directory for DiscISAM cache storage cannot be set
132:
- Bugfix: (MBaker) Work item 17976 - Fix to Excel2007 Reader for hyperlinks with an anchor fragment (following a #), otherwise they were treated as sheet references
133:
- Bugfix: (MBaker) Work item 18963 - getSheetNames() fails on numeric (floating point style) names with trailing zeroes
134:
- Bugfix: (MBaker) Work item GH-130 - Single cell print area
135:
- General: (kea) Work item GH-69 - Improved AdvancedValueBinder for currency
136:
- General: (MBaker) Work items 17936 and 17840 - Fix for environments where there is no access to /tmp but to upload_tmp_dir
137:
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
138:
- General: (amironov ) Work item GH-84 - Search style by identity in PHPExcel_Worksheet::duplicateStyle()
139:
- General: (karak) Work item GH-85 - Fill SheetView IO in Excel5
140:
- General: (cfhay) Work item 18958 - Memory and Speed improvements in PHPExcel_Reader_Excel5
141:
- General: (MBaker) Work item GH-78 - Modify listWorksheetNames() and listWorksheetInfo to use XMLReader with streamed XML rather than SimpleXML
142:
- General: (dbonsch) Restructuring of PHPExcel Exceptions
143:
- General: (MBaker) Work items 16926 and 15145 - Refactor Calculation Engine from singleton to a Multiton
144:
Ensures that calculation cache is maintained independently for different workbooks
145:
- General: (MBaker) Modify cell's getCalculatedValue() method to return the content of RichText objects rather than the RichText object itself
146:
- Bugfix: (techhead) Work item GH-70 - Fixed formula/formatting bug when removing rows
147:
- Bugfix: (alexgann) Work item GH-63 - Fix to cellExists for non-existent namedRanges
148:
- Bugfix: (MBaker) Work item 18844 - cache_in_memory_gzip "eats" last worksheet line, cache_in_memory doesn't
149:
- Feature: (Progi1984) Work item GH-22 - Sheet View in Excel5 Writer
150:
- Bugfix: (amironov) Work item GH-82 - PHPExcel_Worksheet::getCellCollection() may not return last cached cell
151:
- Bugfix: (teso) Work item 18551 - Rich Text containing UTF-8 characters creating unreadable content with Excel5 Writer
152:
- Bugfix: (MBaker) Work item GH-104 - echo statements in HTML.php
153:
- Feature: (Progi1984) Work item GH-8/CP11704 : Conditional formatting in Excel 5 Writer
154:
- Bugfix: (MBaker) Work item GH-113 - canRead() Error for GoogleDocs ODS files: in ODS files from Google Docs there is no mimetype file
155:
- Bugfix: (MBaker) Work item GH-80 - "Sheet index is out of bounds." Exception
156:
- Bugfix: (ccorliss) Work item GH-105 - Fixed number format fatal error
157:
- Bugfix: (MBaker) - Add DROP TABLE in destructor for SQLite and SQLite3 cache controllers
158:
- Bugfix: (alexgann) Work item GH-154 - Fix merged-cell borders on HTML/PDF output
159:
- Bugfix: (Shanto) Work item GH-161 - Fix: Hyperlinks break when removing rows
160:
- Bugfix: (neclimdul) Work item GH-166 - Fix Extra Table Row From Images and Charts
161:
162:
163:
2012-10-12 (v1.7.8):
164:
- Special: (kkamkou) Phar builder script to add phar file as a distribution option
165:
- Feature: (MBaker) Refactor PDF Writer to allow use with a choice of PDF Rendering library
166:
rather than restricting to tcPDF
167:
Current options are tcPDF, mPDF, DomPDF
168:
tcPDF Library has now been removed from the deployment bundle
169:
- Feature: (MBaker) Initial version of HTML Reader
170:
- Feature: (Progi1984) & (blazzy) Work items 9605 - Implement support for AutoFilter in PHPExcel_Writer_Excel5
171:
- Feature: (MBaker) Modified ERF and ERFC Engineering functions to accept Excel 2010's modified acceptance of negative arguments
172:
- Feature: (k1LoW) Support SheetView `view` attribute (Excel2007)
173:
- Feature: (MBaker) Excel compatibility option added for writing CSV files
174:
While Excel 2010 can read CSV files with a simple UTF-8 BOM, Excel2007 and earlier require UTF-16LE encoded tab-separated files.
175:
The new setExcelCompatibility(TRUE) option for the CSV Writer will generate files with this formatting for easy import into Excel2007 and below.
176:
- Feature: (MBaker) Language implementations for Turkish (tr)
177:
- Feature: (MBaker) Added fraction tests to advanced value binder
178:
- Feature: (MBaker) Allow call to font setUnderline() for underline format to specify a simple boolean for UNDERLINE_NONE or UNDERLINE_SINGLE
179:
- General: (alexgann) Add Currency detection to the Advanced Value Binder
180:
- General: (MBaker) Work item 18404 - setCellValueExplicitByColumnAndRow() do not return PHPExcel_Worksheet
181:
- General: (MBaker) Work item 18324 - Reader factory doesn't read anymore XLTX and XLT files
182:
- General: (MBaker) Magic __toString() method added to Cell object to return raw data value as a string
183:
- General: (alexgann) Add cell indent to html rendering
184:
- General: (Raghav1981) ZeroHeight for rows in sheet format
185:
- Bugfix: (cyberconte) Patch 12318 - OOCalc cells containing <text:span> inside the <text:p> tag
186:
- Bugfix: (schir1964) Fix to listWorksheetInfo() method for OOCalc Reader
187:
- Bugfix: (MBaker) Support for "e" (epoch) date format mask
188:
Rendered as a 4-digit CE year in non-Excel outputs
189:
- Bugfix: (MBaker) Work items 15799 and 18278 - Background color cell is always black when editing cell
190:
- Bugfix: (MBaker) Work items 15905 and 18183 - Allow "no impact" to formats on Conditional Formatting
191:
- Bugfix: (wackonline) OOCalc Reader fix for NULL cells
192:
- Bugfix: (seltzlab) Fix to excel2007 Chart Writer when a $plotSeriesValues is empty
193:
- Bugfix: (MBaker) Various fixes to Chart handling
194:
- Bugfix: (MBaker) Work item 18370 - Error loading xlsx file with column breaks
195:
- Bugfix: (MBaker) OOCalc Reader now handles percentage and currency data types
196:
- Bugfix: (MBaker) Work Item 18415 - mb_stripos empty delimiter
197:
- Bugfix: (takaakik) Work Item 15455 - getNestingLevel() Error on Excel5 Read
198:
- Bugfix: (MBaker) Fix to Excel5 Reader when cell annotations are defined before their referenced text objects
199:
- Bugfix: (MBaker) OOCalc Reader modified to process number-rows-repeated
200:
- Bugfix: (MBaker) Work item 18377 - Chart Title compatibility on Excel 2007
201:
- Bugfix: (MBaker) Work item 18146 - Chart Refresh returning cell reference rather than values
202:
- Bugfix: (MBaker) Work item 18145 - Autoshape being identified in twoCellAnchor when includeCharts is TRUE triggering load error
203:
- Bugfix: (MBaker) Work item 18325 - v-type texts for series labels now recognised and parsed correctly
204:
- Bugfix: (wolf5x) Work item 18492 - load file failed if the file has no extensionType
205:
- Bugfix: (dverspui) Pattern fill colours in Excel2007 Style Writer
206:
- Bugfix: (MBaker) Excel2007 Writer order of font style elements to conform with Excel2003 using compatibility pack
207:
- Bugfix: (MBaker) Work item 18425 - Problems with $_activeSheetIndex when decreased below 0.
208:
- Bugfix: (MBaker) Work item 18597 - PHPExcel_CachedObjectStorage_SQLite3::cacheMethodIsAvailable() uses class_exists - autoloader throws error
209:
- Bugfix: (MBaker) Work item 18598 - Cannot access private property PHPExcel_CachedObjectStorageFactory::$_cacheStorageMethod
210:
- Bugfix: (MBaker) Work item 18397 - Data titles for charts
211:
PHPExcel_Chart_Layout now has methods for getting/setting switches for displaying/hiding chart data labels
212:
- Bugfix: (MBaker) Discard single cell merge ranges when reading (stupid that Excel allows them in the first place)
213:
- Bugfix: (MBaker) Discard hidden autoFilter named ranges
214:
215:
216:
2012-05-19 (v1.7.7):
217:
- Bugfix: (Progi1984) Work item 8916 - Support for Rich-Text in PHPExcel_Writer_Excel5
218:
- Bugfix: (cyberconte) Work item 17471 - OOCalc cells contain same data bug?
219:
- Feature: (schir1964) listWorksheetInfo() method added to Readers... courtesy of Christopher Mullins
220:
- Feature: (MBaker) Options for cell caching using Igbinary and SQLite/SQlite3.
221:
- Feature: (MBaker) Additional row iterator options: allow a start row to be defined in the constructor; seek(), and prev() methods added.
222:
- Feature: (Progi1984) Work item 9759 - Implement document properties in Excel5 writer
223:
- Feature: (MBaker) Work item 16 - Implement chart functionality (EXPERIMENTAL)
224:
Initial definition of chart objects.
225:
Reading Chart definitions through the Excel2007 Reader
226:
Facility to render charts to images using the 3rd-party jpgraph library
227:
Writing Charts using the Excel2007 Writer
228:
- General: (MBaker) Fix to build to ensure that Examples are included with the documentation
229:
- General: (MBaker) Reduce cell caching overhead using dirty flag to ensure that cells are only rewritten to the cache if they have actually been changed
230:
- General: (MBaker) Improved memory usage in CSV Writer
231:
- General: (MBaker) Improved speed and memory usage in Excel5 Writer
232:
- General: (MBaker) Experimental -
233:
Added getHighestDataColumn(), getHighestDataRow(), getHighestRowAndColumn() and calculateWorksheetDataDimension() methods for the worksheet that return the highest row and column that have cell records
234:
- General: (MBaker) Change iterators to implement Iterator rather than extend CachingIterator, as a fix for PHP 5.4. changes in SPL
235:
- Bugfix: (MBaker) Work item 15459 - Invalid cell coordinate in Autofilter for Excel2007 Writer
236:
- Bugfix: (MBaker) Work item 15518 - PCLZip library issue
237:
- Bugfix: (MBaker) Work item 15537 - Excel2007 Reader canRead function bug
238:
- Bugfix: (MBaker) Support for Excel functions whose return can be used as either a value or as a cell reference depending on its context within a formula
239:
- Bugfix: (gilles06) Work item 15707 - ini_set() call in Calculation class destructor
240:
- Bugfix: (MBaker) Work item 15786 - RangeToArray strange array keys
241:
- Bugfix: (MBaker) Work item 15762 - INDIRECT() function doesn't work with named ranges
242:
- Bugfix: (MBaker) Locale-specific fix to text functions when passing a boolean argument instead of a string
243:
- Bugfix: (MBaker) Work item 16246 - reader/CSV fails on this file
244:
auto_detect_line_endings now set in CSV reader
245:
- Bugfix: (MBaker) Work item 16212 - $arguments improperly used in CachedObjectStorage/PHPTemp.php
246:
- Bugfix: (MBaker) Work item 16643 - Bug In Cache System (cell reference when throwing caching errors)
247:
- Bugfix: (MBaker) Work item 16895 - PHP Invalid index notice on writing excel file when active sheet has been deleted
248:
- Bugfix: (MBaker) Work item 16956 - External links in Excel2010 files cause Fatal error
249:
- Bugfix: (MBaker) Work item 16960 - Previous calculation engine error conditions trigger cyclic reference errors
250:
- Bugfix: (mkopinsky) Work item 16266 - PHPExcel_Style::applyFromArray() returns null rather than style object in advanced mode
251:
- Bugfix: (fauvel) Work item 16958 - Cell::getFormattedValue returns RichText object instead of string
252:
- Bugfix: (MBaker) Work item 17166 - Indexed colors do not refer to Excel's indexed colors?
253:
- Bugfix: (MBaker) Work item 17199 - Indexed colors should be consistent with Excel and start from 1 (current index starts at 0)
254:
- Bugfix: (MBaker) Work item 17262 - Named Range definition in .xls when sheet reeference is quote wrapped
255:
- Bugfix: (MBaker) Work item 17403 - duplicateStyle() method doesn't duplicate conditional formats
256:
Added an equivalent duplicateConditionalStyle() method for duplicating conditional styles
257:
- Bugfix: (bnr) Work item 17501 - =sumproduct(A,B) <> =sumproduct(B,A) in xlsx
258:
- Bugfix: (Progi1984) Work item 8916 - Support for Rich-Text in PHPExcel_Writer_Excel5
259:
- General: (MBaker) Work item 15405 - Two easy to fix Issues concerning PHPExcel_Token_Stack (l10n/UC)
260:
- General: (MBaker) Work item 15461 - Locale file paths not fit for windows
261:
- General: (MBaker) Work item 16643 - Add file directory as a cache option for cache_to_discISAM
262:
- General: (MBaker) Work item 16923 - Datatype.php & constant TYPE_NULL
263:
- General: (MBaker) Ensure use of system temp directory for all temporary work files, unless explicitly specified
264:
- General: (char101) Work item 16359 - [Patch] faster stringFromColumnIndex()
265:
- General: (whit1206) Work item 16028 - Fix for projects that still use old autoloaders
266:
- General: (atz) Work item 17024 - Unknown codepage: 10007
267:
Additional Mac codepages
268:
269:
270:
2011-02-27 (v1.7.6):
271:
- Feature: (MBaker) Provide option to use PCLZip as an alternative to ZipArchive.
272:
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
273:
It can be enabled using PHPExcel_Settings::setZipClass(PHPExcel_Settings::PCLZIP);
274:
Note that it is not yet implemented as an alternative to ZipArchive for those Readers that are extracting from zips
275:
- Feature: (MBaker) Work item 14979 - 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.
276:
- Feature: (MBaker) Speed boost and memory reduction in the Worksheet toArray() method.
277:
- Feature: (MBaker) Added new rangeToArray() and namedRangeToArray() methods to the PHPExcel_Worksheet object.
278:
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.
279:
Modified the toArray() method so that it actually uses rangeToArray().
280:
- Feature: (MBaker) Added support for cell comments in the OOCalc, Gnumeric and Excel2003XML Readers, and in the Excel5 Reader
281:
- Feature: (MBaker) Improved toFormattedString() handling for Currency and Accounting formats to render currency symbols
282:
- Feature: (MBaker) Work Item 2346 - Implement more Excel calculation functions
283:
Implemented the DAVERAGE(), DCOUNT(), DCOUNTA(), DGET(), DMAX(), DMIN(), DPRODUCT(), DSTDEV(), DSTDEVP(), DSUM(), DVAR() and DVARP() Database functions
284:
- Bugfix: (MBaker) Work item 14888 - Simple =IF() formula disappears
285:
- Bugfix: (MBaker) Work item 14898 - PHP Warning: preg_match(): Compilation failed: PCRE does not support \\L, \\l, \\N, \\P, \\p, \\U, \\u, or \\X
286:
- Bugfix: (MBaker) Work item 14901 - VLOOKUP choking on parameters in PHPExcel.1.7.5/PHPExcel_Writer_Excel2007
287:
- Bugfix: (MBaker) Work item 14973 - PHPExcel_Cell::isInRange() incorrect results - offset by one column
288:
- Bugfix: (MBaker) Treat CodePage of 0 as CP1251 (for .xls files written by applications that don't set the CodePage correctly, such as Apple Numbers)
289:
- Bugfix: (MB) Work item 11583 - Need method for removing autoFilter
290:
- Bugfix: (MBaker) Work item 15029 - coordinateFromString throws exception for rows greater than 99,999
291:
- Bugfix: (MBaker) Work item 14999 - PHPExcel Excel2007 Reader colour problems with solidfill
292:
- Bugfix: (MBaker) Work item 13215 - Formatting get lost and edit a template XLSX file
293:
- Bugfix: (MBaker) Work item 14029 - Excel 2007 Reader /writer lost fontcolor
294:
- Bugfix: (MBaker) Work item 13374 - file that makes cells go black
295:
- Bugfix: (MBaker) Minor patchfix for Excel2003XML Reader when XML is defined with a charset attribute
296:
- Bugfix: (MBaker) Work item 15089 - PHPExcel_Worksheet->toArray() index problem
297:
- Bugfix: (MBaker) Work item 15094 - Merge cells 'un-merge' when using an existing spreadsheet
298:
- Bugfix: (MBaker) Work item 15129 - Worksheet fromArray() only working with 2-D arrays
299:
- Bugfix: (xkeshav) Work item 15172 - rangeToarray function modified for non-existent cells
300:
- Bugfix: (MBaker) Work item 14980 - Images not getting copyied with the ->clone function
301:
- Bugfix: (MBaker) Work item 11576 - AdvancedValueBinder.php: String sometimes becomes a date when it shouldn't
302:
- Bugfix: (MBaker) Fix Excel5 Writer so that it only writes column dimensions for columns that are actually used rather than the full range (A to IV)
303:
- Bugfix: (MBaker) Work item 15198 - FreezePane causing damaged or modified error
304:
The freezePaneByColumnAndRow() method row argument should default to 1 rather than 0.
305:
Default row argument for all __ByColumnAndRow() methods should be 1
306:
- Bugfix: (MBaker) Work item 15121 - Column reference rather than cell reference in Print Area definition
307:
Fix Excel2007 Writer to handle print areas that are defined as row or column ranges rather than just as cell ranges
308:
- Bugfix: (MBaker) Reduced false positives from isDateTimeFormatCode() method by suppressing testing within quoted strings
309:
- Bugfix: (MBaker) Work item 15312 - Caching and tmp partition exhaustion
310:
- Bugfix: (MBaker) Work item 15308 - Writing to Variable No Longer Works. $_tmp_dir Missing in PHPExcel\PHPExcel\Shared\OLE\PPS\Root.php
311:
- Bugfix: (MBaker) Work item 15379 - Named ranges with dot don't get parsed properly
312:
- Bugfix: (MBaker) Work item 15096 - insertNewRowBefore fails to consistently update references
313:
- Bugfix: (MBaker) "i" is not a valid character for Excel date format masks (in isDateTimeFormatCode() method)
314:
- Bugfix: (MKunert) Work item 15421 - PHPExcel_ReferenceHelper::insertNewBefore() is missing an 'Update worksheet: comments' section
315:
- Bugfix: (MBaker) Work item 15409 - Full column/row references in named ranges not supported by updateCellReference()
316:
- General: (MBaker) Improved performance (speed), for building the Shared Strings table in the Excel2007 Writer.
317:
- General: (MBaker) Improved performance (speed), for PHP to Excel date conversions
318:
- General: (MBaker) Enhanced SheetViews element structures in the Excel2007 Writer for frozen panes.
319:
- General: (MBaker) Removed Serialized Reader/Writer as these no longer work.
320:
321:
322:
2010-12-10 (v1.7.5):
323:
- Feature: (MBaker) Work item 8769 - Implement Gnumeric File Format
324:
Initial work on Gnumeric Reader (Worksheet Data, Document Properties and basic Formatting)
325:
- Feature: (MBaker) (incorporating part of Workitem 9759) - Support for Extended Workbook Properties in Excel2007, Excel5 and OOCalc Readers; support for User-defined Workbook Properties in Excel2007 and OOCalc Readers
326:
- Feature: (MBaker) Support for Extended and User-defined Workbook Properties in Excel2007 Writer
327:
- Feature: (MBaker) Provided a setGenerateSheetNavigationBlock(false); option to suppress generation of the sheet navigation block when writing multiple worksheets to HTML
328:
- Feature: (MBaker) Advanced Value Binder now recognises TRUE/FALSE strings (locale-specific) and converts to boolean
329:
- Feature: (MBaker) Work item 14301 - PHPExcel_Worksheet->toArray() is returning truncated values
330:
- Feature: (MBaker) Configure PDF Writer margins based on Excel Worksheet Margin Settings value
331:
- Feature: (MBaker) Added Contiguous flag for the CSV Reader, when working with Read Filters
332:
- Feature: (MBaker) Added getFormattedValue() method for cell object
333:
- Feature: (MBaker) Added strictNullComparison argument to the worksheet fromArray() method
334:
- Feature: (MBaker) Fix to toFormattedString() method in PHPExcel_Style_NumberFormat to handle fractions with a # code for the integer part
335:
- Bugfix: (MB) Work item 14143 - NA() doesn't propagate in matrix calc - quick fix in JAMA/Matrix.php
336:
- Bugfix: (Progi1984) Work item 7895 - Excel5 : Formula : String constant containing double quotation mark
337:
- Bugfix: (Progi1984) Work item 7895 - Excel5 : Formula : Percent
338:
- Bugfix: (Progi1984) Work item 7895 - Excel5 : Formula : Error constant
339:
- Bugfix: (Progi1984) Work item 7895 - Excel5 : Formula : Concatenation operator
340:
- Bugfix: (MBaker) Work item 14146 - Worksheet clone broken for CachedObjectStorage_Memory
341:
- Bugfix: (MBaker) Work item 12998 - PHPExcel_Reader_Excel2007 fails when gradient fill without type is present in a file
342:
- Bugfix: (MBaker) Work item 14176 - @ format for numeric strings in XLSX to CSV conversion
343:
- Bugfix: (MBaker) Work item 14223 - Advanced Value Binder Not Working?
344:
- Bugfix: (MBaker) Work item 14226 - unassigned object variable in PHPExcel->removeCellXfByIndex
345:
- Bugfix: (MBaker) Work item 14236 - problem with getting cell values from another worksheet... (if cell doesn't exist)
346:
- Bugfix: (MBaker) Work items 14260 & 14233 - Setting cell values to one char strings & Trouble reading one character string (thanks gorfou)
347:
- Bugfix: (MBaker) Work item 14256 - Worksheet title exception when duplicate worksheet is being renamed but exceeds the 31 character limit
348:
- Bugfix: (MBaker) Work item 14086 - Named range with sheet name that contains the $ throws exception when getting the cell
349:
- Bugfix: (MBaker) Added autoloader to DefaultValueBinder and AdvancedValueBinder
350:
- Bugfix: (MBaker) Modified PHPExcel_Shared_Date::isDateTimeFormatCode() to return false if format code begins with "_" or with "0 " to prevent false positives
351:
These leading characters are most commonly associated with number, currency or accounting (or occasionally fraction) formats
352:
- Bugfix: (MBaker) Work item 14374 - BUG : Excel5 and setReadFilter ?
353:
- Bugfix: (MBaker) Work item 14425 - Wrong exception message while deleting column
354:
- Bugfix: (MBaker) Work item 14679 - Formula evaluation fails with Japanese sheet refs
355:
- Bugfix: (MBaker) Work item 13559 - PHPExcel_Writer_PDF does not handle cell borders correctly
356:
- Bugfix: (MBaker) Work item 14831 - Style : applyFromArray() for 'allborders' not working
357:
- Bugfix: (MBaker) Work item 14837 - Using $this when not in object context in Excel5 Reader
358:
- General: (MBaker) Applied patch 6609 - Removes a unnecessary loop through each cell when applying conditional formatting to a range.
359:
- General: (MBaker) Applied patch 7169 - Removed spurious PHP end tags (?>)
360:
- General: (MBaker) Improved performance (speed) and reduced memory overheads, particularly for the Writers, but across the whole library.
361:
362:
363:
2010-08-26 (v1.7.4):
364:
- Bugfix: (Progi1984) Work item 7895 - Excel5 : Formula : Power
365:
- Bugfix: (Progi1984) Work item 7895 - Excel5 : Formula : Unary plus
366:
- Bugfix: (Progi1984) Excel5 : Just write the Escher stream if necessary in Worksheet
367:
- Bugfix: (MBaker) Work item 13433 - Syntax errors in memcache.php 1.7.3c
368:
- Bugfix: (MBaker) Work item 13450 - Standard Deviation functions returning DIV/0 Error when Standard Deviation is zero
369:
- Feature: (MBaker) Support for print area with several ranges in the Excel2007 reader, and improved features for editing print area with several ranges
370:
- Feature: (MBaker) Work item 13769 - Improved Cell Exception Reporting
371:
- Feature: (MBaker) Support for row or column ranges in the calculation engine, e.g. =SUM(C:C) or =SUM(1:2)
372:
Also support in the calculation engine for absolute row or column ranges e.g. =SUM($C:$E) or =SUM($3:5)
373:
- Bugfix: (ET) Work item 13455 - Picture problem with Excel 2003
374:
- Bugfix: (MBaker) Work item 13484 - Wrong variable used in addExternalSheet in PHPExcel.php
375:
- Bugfix: (MBaker) Work item 13515 - "Invalid cell coordinate" error when formula access data from an other sheet
376:
- Bugfix: (MBaker) (related to Work item 13515) Calculation engine confusing cell range worksheet when referencing cells in a different worksheet to the formula
377:
- Bugfix: (MBaker) Work item 13752 - Wrong var naming in Worksheet->garbageCollect()
378:
- Bugfix: (MBaker) Work item 13764 - PHPExcel_Style_*::__clone() methods cause cloning loops?
379:
- Bugfix: (MBaker) Work item 11488 - Recent builds causing problems loading xlsx files? (ZipArchive issue?)
380:
- Bugfix: (MBaker) Work item 13856 - cache_to_apc causes fatal error when processing large data sets
381:
- Bugfix: (MBaker) Work item 13880 - OOCalc reader misses first line if it's a 'table-header-row'
382:
- Bugfix: (MBaker) Work item 14011 - using cache with copy or clone bug?
383:
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;
384:
Fixed but untested when using cache_to_wincache.
385:
- Bugfix: (MBaker) Fixed problems with reading Excel2007 Properties
386:
- General: (MB) Applied patch 6324 - PHP Strict Standards: Non-static method PHPExcel_Shared_String::utf16_decode() should not be called statically
387:
- General: (MBaker) Applied patch 6360 - Array functions were ignored when loading an existing file containing them, and as a result, they would lose their 'cse' status.
388:
- General: (MBaker) Minor memory tweaks to Excel2007 Writer
389:
- General: (MBaker) 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.
390:
- General: (MBaker) Modified Excel2007 Reader so that ReferenceHelper class is instantiated only once rather than for every shared formula in a workbook.
391:
- General: (MBaker) Correct handling for additional (synonym) formula tokens in Excel5 Reader
392:
- General: (MBaker) Additional reading of some Excel2007 Extended Properties (Company, Manager)
393:
394:
395:
2010-06-01 (v1.7.3c):
396:
- Bugfix: (MB) Work item 13012 - Fatal error: Class 'ZipArchive' not found... ...Reader/Excel2007.php on line 217
397:
- Bugfix: (MBaker) Work item 13398 - PHPExcel_Writer_Excel2007 error after 1.7.3b
398:
399:
400:
2010-05-31 (v1.7.3b):
401:
- Bugfix: (MBaker) Work item 12903 - Infinite loop when reading
402:
- Bugfix: (MB) Work item 13381 - Wrong method chaining on PHPExcel_Worksheet class
403:
404:
405:
2010-05-17 (v1.7.3):
406:
- General: (ET) Applied patch 4990 (modified)
407:
- General: (MB) Applied patch 5568 (modified)
408:
- General: (MB) Applied patch 5943
409:
- General: (MB) Work item 13042 - Upgrade build script to use Phing
410:
- General: (ET) Work item 11586 - Replacing var with public/private
411:
- General: (MBaker) Applied Anthony's Sterling's Class Autoloader to reduce memory overhead by "Lazy Loading" of classes
412:
- General: (MBaker) Modification to functions that accept a date parameter to support string values containing ordinals as per Excel (English language only)
413:
- General: (MBaker) Modify PHPExcel_Style_NumberFormat::toFormattedString() to handle dates that fall outside of PHP's 32-bit date range
414:
- General: (MBaker) Applied patch 5207
415:
- General: (ET) Work item 11970 - PHPExcel developer documentation: Set page margins
416:
- Feature: (ET) Work item 11038 - Special characters and accents in SYLK reader
417:
- Feature: (MBaker) Work Item 2346 - Implement more Excel calculation functions
418:
- Implemented the COUPDAYS(), COUPDAYBS(), COUPDAYSNC(), COUPNCD(), COUPPCD() and PRICE() Financial functions
419:
- Implemented the N() and TYPE() Information functions
420:
- Implemented the HYPERLINK() Lookup and Reference function
421:
- Feature: (ET) Work item 11526 - Horizontal page break support in PHPExcel_Writer_PDF
422:
- Feature: (ET) Work item 11529 - Introduce method setActiveSheetIndexByName()
423:
- Feature: (ET) Work item 11550 - AdvancedValueBinder.php: Automatically wrap text when there is new line in string (ALT+"Enter")
424:
- Feature: (ET) Work item 10300 - Data validation support in PHPExcel_Reader_Excel5 and PHPExcel_Writer_Excel5
425:
- Feature: (MB) Work item 11616 - Improve autosize calculation
426:
- Feature: (MBaker) Methods to translate locale-specific function names in formulae
427:
- 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)
428:
- Feature: (ET) Work item 9759 - Implement document properties in Excel5 reader/writer
429:
- Fixed so far for PHPExcel_Reader_Excel5
430:
- Feature: (ET) Work item 11849 - Show/hide row and column headers in worksheet
431:
- Feature: (ET) Work item 11919 - Can't set font on writing PDF (by key)
432:
- Feature: (ET) Work item 12096 - Thousands scale (1000^n) support in PHPExcel_Style_NumberFormat::toFormattedString
433:
- Feature: (ET) Work item 6911 - Implement repeating rows in PDF and HTML writer
434:
- Feature: (ET) Work item 12289 - Sheet tabs in PHPExcel_Writer_HTML
435:
- Feature: (MB) Work item 13041 - Add Wincache CachedObjectProvider
436:
- Feature: (MBaker) Configure PDF Writer paper size based on Excel Page Settings value, and provided methods to override paper size and page orientation with the writer
437:
- Note PHPExcel defaults to Letter size, while the previous PDF writer enforced A4 size, so PDF writer will now default to Letter
438:
- Feature: (MBaker) Initial implementation of cell caching: allowing larger workbooks to be managed, but at a cost in speed
439:
- Feature: (MBaker) 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.
440:
- Bugfix: (MBaker) Work item 10979 - Warning messages with INDEX function having 2 arguments
441:
- Bugfix: (ET) Work item 11473 - setValue('=') should result in string instead of formula
442:
- Bugfix: (MBaker) Work item 11471 - method _raiseFormulaError should no be private
443:
- Bugfix: (ET) Work item 11485 - Fatal error: Call to undefined function mb_substr() in ...Classes\PHPExcel\Reader\Excel5.php on line 2903
444:
- Bugfix: (ET) Work item 11487 - getBold(), getItallic(), getStrikeThrough() not always working with PHPExcel_Reader_Excel2007
445:
- Bugfix: (ET) Work item 11492 - AdvancedValueBinder.php not working correctly for $cell->setValue('hh:mm:ss')
446:
- Bugfix: (MBaker) Fixed leap year handling for the YEARFRAC() Date/Time function when basis ia 1 (Actual/actual)
447:
- Bugfix: (MBaker) Work item 11490 - Warning messages
448:
- Calculation Engine code modified to enforce strict standards for pass by reference
449:
- Bugfix: (ET) Work item 11483 - PHPExcel_Cell_AdvancedValueBinder doesnt work for dates in far future
450:
- Bugfix: (ET) Work item 11528 - MSODRAWING bug with long CONTINUE record in PHPExcel_Reader_Excel5
451:
- Bugfix: (ET) Work item 11571 - PHPExcel_Reader_Excel2007 reads print titles as named range when there is more than one sheet
452:
- Bugfix: (ET) Work item 11561 - missing @return in phpdocblock in reader classes
453:
- Bugfix: (ET) Work item 11576 - AdvancedValueBinder.php: String sometimes becomes a date when it shouldn't
454:
- Bugfix: (ET) Work item 11588 - Small numbers escape treatment in PHPExcel_Style_NumberFormat::toFormattedString()
455:
- Bugfix: (ET) Work item 11590 - Blank styled cells are not blank in output by HTML writer due to
456:
- Bugfix: (MBaker) Work item 11587 - Calculation engine bug: Existing, blank cell + number gives #NUM
457:
- Bugfix: (ET) Work item 11608 - AutoSize only measures length of first line in cell with multiple lines (ALT+Enter)
458:
- Bugfix: (ET) Work item 11608 - Fatal error running Tests/12serializedfileformat.php (PHPExcel 1.7.2)
459:
- Bugfix: (MBaker) Fixed various errors in the WORKDAY() and NETWORKDAYS() Date/Time functions (particularly related to holidays)
460:
- Bugfix: (ET) Work item 11660 - Uncaught exception 'Exception' with message 'Valid scale is between 10 and 400.' in Classes/PHPExcel/Worksheet/SheetView.php:115
461:
- Bugfix: (ET) Work item 11551 - "Unrecognized token 39 in formula" with PHPExcel_Reader_Excel5 (occuring with add-in functions)
462:
- Bugfix: (ET) Work item 11668 - Excel2007 reader not reading PHPExcel_Style_Conditional::CONDITION_EXPRESSION
463:
- Bugfix: (MBaker) Fix to the BESSELI(), BESSELJ(), BESSELK(), BESSELY() and COMPLEX() Engineering functions to use correct default values for parameters
464:
- Bugfix: (MBaker) Work item 11525 - DATEVALUE function not working for pure time values + allow DATEVALUE() function to handle partial dates (e.g. "1-Jun" or "12/2010")
465:
- Bugfix: (MBaker) Fix for empty quoted strings in formulae
466:
- Bugfix: (MBaker) Trap for division by zero in Bessel functions
467:
- Bugfix: (MBaker) Fix to OOCalc Reader to convert semi-colon (;) argument separator in formulae to a comma (,)
468:
- Bugfix: (ET) Work item 11693 - PHPExcel_Writer_Excel5_Parser cannot parse formula like =SUM(C$5:C5)
469:
- Bugfix: (MBaker) Fix to OOCalc Reader to handle dates that fall outside 32-bit PHP's date range
470:
- Bugfix: (ET) Work item 11692 - File->sys_get_temp_dir() can fail in safe mode
471:
- Bugfix: (ET) Work item 11727 - Sheet references in Excel5 writer do not work when referenced sheet title contains non-Latin symbols
472:
- Bugfix: (ET) Work item 11743 - Bug in HTML writer can result in missing rows in output
473:
- Bugfix: (ET) Work item 11674 - setShowGridLines(true) not working with PHPExcel_Writer_PDF
474:
- Bugfix: (ET) Work item 11836 - PHPExcel_Worksheet_RowIterator initial position incorrect
475:
- Bugfix: (ET) Work item 11835 - PHPExcel_Worksheet_HeaderFooterDrawing Strict Exception thrown (by jshaw86)
476:
- Bugfix: (ET) Work item 11850 - Parts of worksheet lost when there are embedded charts (Excel5 reader)
477:
- Bugfix: (MBaker) VLOOKUP() function error when lookup value is passed as a cell reference rather than an absolute value
478:
- Bugfix: (ET) Work item 12041 - First segment of Rich-Text not read correctly by PHPExcel_Reader_Excel2007
479:
- Bugfix: (MBaker) Work item 12048 - Fatal Error with getCell('name') when name matches the pattern for a cell reference
480:
- Bugfix: (ET) Work item 12039 - excel5 writer appears to be swapping image locations
481:
- Bugfix: (ET) Work item 11954 - Undefined index: host in ZipStreamWrapper.php, line 94 and line 101
482:
- Bugfix: (ET) Work item 11672 - BIFF8 File Format problem (too short COLINFO record)
483:
- Bugfix: (ET) Work item 12121 - Column width sometimes changed after read/write with Excel2007 reader/writer
484:
- Bugfix: (ET) Work item 11964 - Worksheet.php throws a fatal error when styling is turned off via setReadDataOnly on the reader
485:
- Bugfix: (MBaker) Work item 11851 - Checking for Circular References in Formulae
486:
- 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
487:
- Bugfix: (ET) Work item 12244 - PNG transparency using Excel2007 writer
488:
- Bugfix: (ET) Work item 12221 - Custom readfilter error when cell formulas reference excluded cells (Excel5 reader)
489:
- Bugfix: (ET) Work item 12288 - Protection problem in XLS
490:
- Bugfix: (ET) Work item 12300 - getColumnDimension()->setAutoSize() incorrect on cells with Number Formatting
491:
- Bugfix: (ET) Work item 12378 - Notices reading Excel file with Add-in funcitons (PHPExcel_Reader_Excel5)
492:
- Bugfix: (ET) Work item 12380 - Excel5 reader not reading formulas with deleted sheet references
493:
- Bugfix: (ET) Work item 12404 - Named range (defined name) scope problems for in PHPExcel
494:
- Bugfix: (ET) Work item 12423 - PHP Parse error: syntax error, unexpected T_PUBLIC in PHPExcel/Calculation.php on line 3482
495:
- Bugfix: (ET) Work item 12505 - Named ranges don't appear in name box using Excel5 writer
496:
- Bugfix: (ET) Work item 12509 - Many merged cells + autoSize column -> slows down the writer
497:
- Bugfix: (ET) Work item 12539 - Incorrect fallback order comment in Shared/Strings.php ConvertEncoding()
498:
- Bugfix: (ET) Work item 12538 - IBM AIX iconv() will not work, should revert to mbstring etc. instead
499:
- Bugfix: (ET) Work item 12568 - Excel5 writer and mbstring functions overload
500:
- Bugfix: (MBaker) Work item 12672 - OFFSET needs to flattenSingleValue the $rows and $columns args
501:
- Bugfix: (MBaker) Work item 12546 - Formula with DMAX(): Notice: Undefined offset: 2 in ...\PHPExcel\Calculation.php on line 2365
502:
- Note that the Database functions have not yet been implemented
503:
- Bugfix: (MBaker) Work item 12839 - Call to a member function getParent() on a non-object in Classes\\PHPExcel\\Calculation.php Title is required
504:
- Bugfix: (MBaker) Work item 12935 - Cyclic Reference in Formula
505:
- Bugfix: (MBaker) Work item 13025 - Memory error...data validation?
506:
507:
508:
2010/01/11 (v1.7.2):
509:
- General: (ET) Applied patch 4362
510:
- General: (ET) Applied patch 4363 (modified)
511:
- General: (MBaker) Work item 10874 - 1.7.1 Extremely Slow - Refactored PHPExcel_Calculation_Functions::flattenArray() method and set calculation cache timer default to 2.5 seconds
512:
- General: (MBaker) Allow formulae to contain line breaks
513:
- General: (ET) Work item 10910 - split() function deprecated in PHP 5.3.0
514:
- General: (ET) sys_get_temp_dir() requires PHP 5.2.1, not PHP 5.2 [provide fallback function for PHP 5.2.0]
515:
- General: (MBaker) Applied patch 4640 - Implementation of the ISPMT() Financial function by Matt Groves
516:
- General: (MBaker) Work item 11052 - Put the example of formula with more arguments in documentation
517:
- General: (MBaker) Improved accuracy for the GAMMAINV() Statistical Function
518:
- Feature: (ET) Work item 10409 - XFEXT record support to fix colors change from Excel5 reader, and copy/paste color change with Excel5 writer
519:
- Excel5 reader reads RGB color information in XFEXT records for borders, font color and fill color
520:
- Feature: (MBaker) Work Item 2346 - Implement more Excel calculation functions
521:
- Implemented the FVSCHEDULE(), XNPV(), IRR(), MIRR(), XIRR() and RATE() Financial functions
522:
- Implemented the SUMPRODUCT() Mathematical function
523:
- Implemented the ZTEST() Statistical Function
524:
- Feature: (ET) Work item 10919 - Multiple print areas in one sheet
525:
- Feature: (ET) Work item 10930 - Store calculated values in output by PHPExcel_Writer_Excel5
526:
- Feature: (ET) Work item 10939 - Sheet protection options in Excel5 reader/writer
527:
- Feature: (MBaker) 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.
528:
- Feature: (ET) Work item 9932 - Cell range selection
529:
- Feature: (MB) Work item 10266 - Root-relative path handling
530:
- Feature: (ET) Work item 11315 - Named Ranges not working with PHPExcel_Writer_Excel5
531:
- Bugfix: (MB) Work item 11206 - Excel2007 Reader fails to load Apache POI generated Excel
532:
- Bugfix: (MB) Work item 11154 - Number format is broken when system's thousands separator is empty
533:
- Bugfix: (MB) Work item 11401 - ReferenceHelper::updateNamedFormulas throws errors if oldName is empty
534:
- Bugfix: (MB) Work item 11296 - parse_url() fails to parse path to an image in xlsx
535:
- Bugfix: (ET) Work item 10876 - Workaround for iconv_substr() bug in PHP 5.2.0
536:
- Bugfix: (ET) Work item 10877 - 1 pixel error for image width and height with PHPExcel_Writer_Excel5
537:
- Bugfix: (MBaker) Fix to GEOMEAN() Statistical function
538:
- Bugfix: (ET) Work item 10884 - setValue('-') and setValue('.') sets numeric 0 instead of 1-character string
539:
- Bugfix: (ET) Work item 10885 - Row height sometimes much too low after read with PHPExcel_Reader_Excel5
540:
- Bugfix: (ET) Work item 10888 - Diagonal border. Miscellaneous missing support.
541:
- Constant PHPExcel_Style_Borders::DIAGONAL_BOTH added to support double-diagonal (cross)
542:
- PHPExcel_Reader_Excel2007 not always reading diagonal borders (only recognizes 'true' and not '1')
543:
- PHPExcel_Reader_Excel5 support for diagonal borders
544:
- PHPExcel_Writer_Excel5 support for diagonal borders
545:
- Bugfix: (ET) Work item 10894 - Session bug: Fatal error: Call to a member function bindValue() on a non-object in ...\Classes\PHPExcel\Cell.php on line 217
546:
- Bugfix: (ET) Work item 10896 - Colors messed up saving twice with same instance of PHPExcel_Writer_Excel5 (regression since 1.7.0)
547:
- Bugfix: (ET) Work item 10917 - Method PHPExcel_Worksheet::setDefaultStyle is not working
548:
- Bugfix: (ET) Work item 10897 - PHPExcel_Reader_CSV::canRead() sometimes says false when it shouldn't
549:
- Bugfix: (ET) Work item 10922 - Changes in workbook not picked up between two saves with PHPExcel_Writer_Excel2007
550:
- Bugfix: (ET) Work item 10913 - Decimal and thousands separators missing in HTML and PDF output
551:
- Bugfix: (ET) Work item 10936 - Notices with PHPExcel_Reader_Excel5 and named array constants
552:
- Bugfix: (MBaker) Work item 10938 - Calculation engine limitation on 32-bit platform with integers > 2147483647
553:
- Bugfix: (ET) Work item 10959 - Shared(?) formulae containing absolute cell references not read correctly using Excel5 Reader
554:
- Bugfix: (MBaker) Work item 10962 - Warning messages with intersection operator involving single cell
555:
- Bugfix: (ET) Work item 10980 - Infinite loop in Excel5 reader caused by zero-length string in SST
556:
- Bugfix: (ET) Work item 10983 - Remove unnecessary cell sorting to improve speed by approx. 18% in HTML and PDF writers
557:
- Bugfix: (MBaker) Work item 10977 - Cannot read A1 cell content - OO_Reader
558:
- Bugfix: (ET) Work item 11000 - Transliteration failed, invalid encoding
559:
560:
561:
2009/11/02 (v1.7.1):
562:
- General: (ET) Work item 10687 - ereg() function deprecated in PHP 5.3.0
563:
- General: (MB) Work item 10739 - Writer Interface Inconsequence - setTempDir and setUseDiskCaching
564:
- General: (ET) Upgrade to TCPDF 4.8.009
565:
- Feature: (ET) Work item 7333 - Support for row and column styles (feature request)
566:
- Basic implementation for Excel2007/Excel5 reader/writer
567:
- Feature: (ET) Work item 10459 - Hyperlink to local file in Excel5 reader/writer
568:
- Feature: (MB) Work item 10472 - Color Tab (Color Sheet's name)
569:
- Feature: (ET) Work item 10488 - Border style "double" support in PHPExcel_Writer_HTML
570:
- Feature: (ET) Work item 10492 - Multi-section number format support in HTML/PDF/CSV writers
571:
- Feature: (MBaker) - Some additional performance tweaks in the calculation engine
572:
- Feature: (MBaker) - Fix result of DB() and DDB() Financial functions to 2dp when in Gnumeric Compatibility mode
573:
- Feature: (MBaker) - Added AMORDEGRC(), AMORLINC() and COUPNUM() Financial function (no validation of parameters yet)
574:
- Feature: (MBaker) - Improved accuracy of TBILLEQ(), TBILLPRICE() and TBILLYIELD() Financial functions when in Excel or Gnumeric mode
575:
- Feature: (MBaker) - Added INDIRECT() Lookup/Reference function (only supports full addresses at the moment)
576:
- Feature: (MB) Work item 10498 - PHPExcel_Reader_CSV::canRead() improvements
577:
- Feature: (ET) Work item 10500 - Input encoding option for PHPExcel_Reader_CSV
578:
- Feature: (ET) Work item 10493 - Colored number format support, e.g. [Red], in HTML/PDF output
579:
- Feature: (ET) Work item 10559 - Color Tab (Color Sheet's name) [Excel5 reader/writer support]
580:
- Feature: (MBaker) Initial version of SYLK (slk) and Excel 2003 XML Readers (Cell data and basic cell formatting)
581:
- Feature: (MBaker) Initial version of Open Office Calc (ods) Reader (Cell data only)
582:
- Feature: (MBaker) Initial use of "pass by reference" in the calculation engine for ROW() and COLUMN() Lookup/Reference functions
583:
- Feature: (MBaker) Work item 2346 - COLUMNS() and ROWS() Lookup/Reference functions, and SUBSTITUTE() Text function
584:
- Feature: (ET) Work item 10502 - AdvancedValueBinder(): Re-enable zero-padded string-to-number conversion, e.g '0004' -> 4
585:
- Feature: (ET) Work item 10600 - Make PHP type match Excel datatype
586:
- Feature: (MB) Work item 10630 - Change first page number on header
587:
- Feature: (MB) Applied patch 3941
588:
- Feature: (MB,ET) Work item 10745 - Hidden sheets
589:
- Feature: (ET) Work item 10761 - mbstring fallback when iconv is broken
590:
- Feature: (MBaker) Added support for matrix/value comparisons (e.g. ={1,2;3,4}>=3 or 2<>{1,2;3,4}) - Note, can't yet handle comparison of two matrices
591:
- Feature: (MBaker) Improved handling for validation and error trapping in a number of functions
592:
- Feature: (MBaker) Improved support for fraction number formatting
593:
- Feature: (ET) Work item 10455 - Support Reading CSV with Byte Order Mark (BOM)
594:
- Feature: (ET) Work item 10860 - addExternalSheet() at specified index
595:
- Bugfix: (MBaker) Work item 10684 - Named range can no longer be passed to worksheet->getCell()
596:
- Bugfix: (ET) Work item 10455 - RichText HTML entities no longer working in PHPExcel 1.7.0
597:
- Bugfix: (ET) Work item 7610 - Fit-to-width value of 1 is lost after read/write of Excel2007 spreadsheet [+ support for simultaneous scale/fitToPage]
598:
- Bugfix: (MB) Work item 10469 - Performance issue identified by profiling
599:
- Bugfix: (ET) Work item 10473 - setSelectedCell is wrong
600:
- Bugfix: (ET) Work item 10481 - Images get squeezed/stretched with (Mac) Verdana 10 Excel files using Excel5 reader/writer
601:
- Bugfix: (MBaker) Work item 10482 - Error in argument count for DATEDIF() function
602:
- Bugfix: (MBaker) Work item 10452 - updateFormulaReferences is buggy
603:
- Bugfix: (MB) Work item 10485 - CellIterator returns null Cell if onlyExistingCells is set and key() is in use
604:
- Bugfix: (MBaker) Work item 10453 - Wrong RegEx for parsing cell references in formulas
605:
- Bugfix: (MB) Work item 10486 - Optimisation subverted to devastating effect if IterateOnlyExistingCells is clear
606:
- Bugfix: (ET) Work item 10494 - Fatal error: Uncaught exception 'Exception' with message 'Unrecognized token 6C in formula'... with PHPExcel_Reader_Excel5
607:
- Bugfix: (MBaker) Work item 10490 - Fractions stored as text are not treated as numbers by PHPExcel's calculation engine
608:
- Bugfix: (ET) Work item 10503 - AutoFit (autosize) row height not working in PHPExcel_Writer_Excel5
609:
- Bugfix: (MBaker) Fixed problem with null values breaking the calculation stack
610:
- Bugfix: (ET) Work item 10524 - Date number formats sometimes fail with PHPExcel_Style_NumberFormat::toFormattedString, e.g. [$-40047]mmmm d yyyy
611:
- Bugfix: (MBaker) Fixed minor problem with DATEDIFF YM calculation
612:
- Bugfix: (MB) Applied patch 3695
613:
- Bugfix: (ET) Work item 10536 - setAutosize() and Date cells not working properly
614:
- Bugfix: (ET) Work item 10556 - Time value hour offset in output by HTML/PDF/CSV writers (system timezone problem)
615:
- Bugfix: (ET) Work item 10558 - Control characters 0x14-0x1F are not treated by PHPExcel
616:
- Bugfix: (ET) Work item 10560 - PHPExcel_Writer_Excel5 not working when open_basedir restriction is in effect
617:
- Bugfix: (MBaker) Work item 10563 - IF formula calculation problem in PHPExcel 1.7.0 (string comparisons)
618:
- Bugfix: (MBaker) Improved CODE() Text function result for UTF-8 characters
619:
- Bugfix: (ET) Work item 10568 - Empty rows are collapsed with HTML/PDF writer
620:
- Bugfix: (ET) Work item 10569 - Gaps between rows in output by PHPExcel_Writer_PDF (Upgrading to TCPDF 4.7.003)
621:
- Bugfix: (ET) Work item 10575 - Problem reading formulas (Excel5 reader problem with "fake" shared formulas)
622:
- Bugfix: (MBaker) Work item 10588 - Error type in formula: "_raiseFormulaError message is Formula Error: An unexpected error occured"
623:
- Bugfix: (ET) Work item 10599 - Miscellaneous column width problems in Excel5/Excel2007 writer
624:
- Bugfix: (ET) Work item 10615 - Reader/Excel5 'Unrecognized token 2D in formula' in latest version
625:
- Bugfix: (ET) Work item 10623 - on php 5.3 PHPExcel 1.7 Excel 5 reader fails in _getNextToken, token = 2C, throws exception
626:
- Bugfix: (ET) Work item 10617 - Fatal error when altering styles after workbook has been saved
627:
- Bugfix: (ET) Work item 10661 - Images vertically stretched or squeezed when default font size is changed (PHPExcel_Writer_Excel5)
628:
- Bugfix: (ET) Work item 10676 - Styles not read in "manipulated" Excel2007 workbook
629:
- Bugfix: (ET) Work item 10059 - Windows 7 says corrupt file by PHPExcel_Writer_Excel5 when opening in Excel
630:
- Bugfix: (MBaker) Work item 10708 - Calculations sometimes not working with cell references to other sheets
631:
- Bugfix: (ET) Work item 10706 - Problem with merged cells after insertNewRowBefore()
632:
- Bugfix: (MBaker) Applied patch 4023
633:
- Bugfix: (MBaker) Fix to SUMIF() and COUNTIF() Statistical functions for when condition is a match against a string value
634:
- Bugfix: (ET) Work item 10721 - PHPExcel_Cell::coordinateFromString should throw exception for bad string parameter
635:
- Bugfix: (ET) Work item 10723 - EucrosiaUPC (Thai font) not working with PHPExcel_Writer_Excel5
636:
- Bugfix: (MBaker) Improved the return of calculated results when the result value is an array
637:
- Bugfix: (MBaker) Allow calculation engine to support Functions prefixed with @ within formulae
638:
- Bugfix: (MBaker) Work item 10632 - Intersection operator (space operator) fatal error with calculation engine
639:
- Bugfix: (ET) Work item 10742 - Chinese, Japanese, Korean characters show as squares in PDF
640:
- Bugfix: (ET) Work item 10756 - sheet title allows invalid characters
641:
- Bugfix: (ET) Work item 10757 - Sheet!$A$1 as function argument in formula causes infinite loop in Excel5 writer
642:
- Bugfix: (MBaker) Work item 10740 - Cell range involving name not working with calculation engine - Modified calculation parser to handle range operator (:), but doesn't currently handle worksheet references with spaces or other non-alphameric characters, or trap erroneous references
643:
- Bugfix: (MBaker) Work item 10798 - DATE function problem with calculation engine (says too few arguments given)
644:
- Bugfix: (MBaker) Work item 10799 - Blank cell can cause wrong calculated value
645:
- Bugfix: (MBaker) Modified ROW() and COLUMN() Lookup/Reference Functions to return an array when passed a cell range, plus some additional work on INDEX()
646:
- Bugfix: (ET) Work item 10817 - Images not showing in Excel 97 using PHPExcel_Writer_Excel5 (patch by Jordi Gutiérrez Hermoso)
647:
- Bugfix: (ET) Work item 10785 - When figures are contained in the excel sheet, Reader was stopped
648:
- Bugfix: (MBaker) Work item 10818 - Formulas changed after insertNewRowBefore()
649:
- Bugfix: (ET) Work item 10825 - Cell range row offset problem with shared formulas using PHPExcel_Reader_Excel5
650:
- Bugfix: (MBaker) Work item 10832 - Warning: Call-time pass-by-reference has been deprecated
651:
- Bugfix: (ET) Work item 10849 - Image should "Move but don't size with cells" instead of "Move and size with cells" with PHPExcel_Writer_Excel5
652:
- Bugfix: (ET) Work item 10856 - Opening a Excel5 generated XLS in Excel 2007 results in header/footer entry not showing on input
653:
- Bugfix: (ET) Work item 10859 - addExternalSheet() not returning worksheet
654:
- Bugfix: (MBaker) Work item 10629 - Invalid results in formulas with named ranges
655:
656:
657:
2009/08/10 (v1.7.0):
658:
- General: (ET) Work item 9893 - Expand documentation: Number formats
659:
- General: (ET) Work item 9941 - Class 'PHPExcel_Cell_AdvancedValueBinder' not found
660:
- General: (MB) Work item 9960 - Change return type of date functions to PHPExcel_Calculation_Functions::RETURNDATE_EXCEL
661:
- Feature: (MBaker) - New RPN and stack-based calculation engine for improved performance of formula calculation
662:
- Faster (anything between 2 and 12 times faster than the old parser, depending on the complexity and nature of the formula)
663:
- Significantly more memory efficient when formulae reference cells across worksheets
664:
- Correct behaviour when referencing Named Ranges that exist on several worksheets
665:
- Support for Excel ^ (Exponential) and % (Percentage) operators
666:
- Support for matrices within basic arithmetic formulae (e.g. ={1,2,3;4,5,6;7,8,9}/2)
667:
- Better trapping/handling of NaN and infinity results (return #NUM! error)
668:
- Improved handling of empty parameters for Excel functions
669:
- Optional logging of calculation steps
670:
- Feature: (MBaker) - New calculation engine can be accessed independently of workbooks (for use as a standalone calculator)
671:
- Feature: (MBaker) Work Item 2346 - Implement more Excel calculation functions
672:
- Initial implementation of the COUNTIF() and SUMIF() Statistical functions
673:
- Added ACCRINT() Financial function
674:
- Feature: (MBaker) - 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 ?/?)
675:
- Feature: (ET) Work item 9794 - Support arbitrary fixed number of decimals in PHPExcel_Style_NumberFormat::toFormattedString()
676:
- Feature: (ET) Work item 6857 - Improving performance and memory on data dumps
677:
- Various style optimizations (merging from branch wi6857-memory)
678:
- Moving hyperlink and dataValidation properties from cell to worksheet for lower PHP memory usage
679:
- Feature: (MB) Work item 9869 - Provide fluent interfaces where possible
680:
- Feature: (ET) Work item 9899 - Make easy way to apply a border to a rectangular selection
681:
- Feature: (ET) Work item 9906 - Support for system window colors in PHPExcel_Reader_Excel5
682:
- Feature: (ET) Work item 9911 - Horizontal center across selection
683:
- Feature: (ET) Work item 9919 - Merged cells record, write to full record size in PHPExcel_Writer_Excel5
684:
- Feature: (MB) Work item 9895 - Add page break between sheets in exported PDF
685:
- Feature: (ET) Work item 9902 - Sanitization of UTF-8 input for cell values
686:
- Feature: (ET) Work item 9930 - Read cached calculated value with PHPExcel_Reader_Excel5
687:
- Feature: (ET) Work item 9896 - Miscellaneous CSS improvements for PHPExcel_Writer_HTML
688:
- Feature: (ET) Work item 9947 - getProperties: setCompany feature request
689:
- Feature: (MB) Patch 2981 - Insert worksheet at a specified index
690:
- Feature: (MB) Patch 3018 - Change worksheet index
691:
- Feature: (MB) Patch 3039 - Readfilter for CSV reader
692:
- Feature: (ET) Work item 10172 - Check value of mbstring.func_overload when saving with PHPExcel_Writer_Excel5
693:
- Feature: (ET) Work item 10251 - Eliminate dependency of an include path pointing to class directory
694:
- Feature: (ET) Work item 10292 - Method for getting the correct reader for a certain file (contribution)
695:
- Feature: (ET) Work item 10287 - Choosing specific row in fromArray method
696:
- Feature: (ET) Work item 10319 - Shared formula support in PHPExcel_Reader_Excel5
697:
- Feature: (MB,ET) Work item 10345 - Right-to-left column direction in worksheet
698:
- Bugfix: (ET) Work item 9824 - PHPExcel_Reader_Excel5 not reading PHPExcel_Style_NumberFormat::FORMAT_NUMBER ('0')
699:
- Bugfix: (ET) Work item 9858 - Fractional row height in locale other than English results in corrupt output using PHPExcel_Writer_Excel2007
700:
- Bugfix: (ET) Work item 9846 - Fractional (decimal) numbers not inserted correctly when locale is other than English
701:
- Bugfix: (ET) Work item 9863 - Fractional calculated value in locale other than English results in corrupt output using PHPExcel_Writer_Excel2007
702:
- Bugfix: (ET) Work item 9830 - Locale aware decimal and thousands separator in exported formats HTML, CSV, PDF
703:
- Bugfix: (MB) Work item 9819 - Cannot Add Image with Space on its Name
704:
- Bugfix: (ET) Work item 9884 - Black line at top of every page in output by PHPExcel_Writer_PDF
705:
- Bugfix: (ET) Work item 9885 - Border styles and border colors not showing in HTML output (regression since 1.6.4)
706:
- Bugfix: (ET) Work item 9888 - Hidden screen gridlines setting in worksheet not read by PHPExcel_Reader_Excel2007
707:
- Bugfix: (MB) Work item 9913 - Some valid sheet names causes corrupt output using PHPExcel_Writer_Excel2007
708:
- Bugfix: (ET) Work item 9934 - More than 32,767 characters in a cell gives corrupt Excel file
709:
- Bugfix: (ET) Work item 9937 - Images not getting copyied with the ->copy() function
710:
- Bugfix: (ET) Work item 9940 - Bad calculation of column width setAutoSize(true) function
711:
- Bugfix: (ET) Work item 9968 - Dates are sometimes offset by 1 day in output by HTML and PDF writers depending on system timezone setting
712:
- Bugfix: (ET) Work item 10003 - Wingdings symbol fonts not working with PHPExcel_Writer_Excel5
713:
- Bugfix: (MB) Work item 10010 - White space string prefix stripped by PHPExcel_Writer_Excel2007
714:
- Bugfix: (ET) Work item 10023 - The name of the Workbook stream MUST be "Workbook", not "Book"
715:
- Bugfix: (ET) Work item 10030 - Avoid message "Microsoft Excel recalculates formulas..." when closing xls file from Excel
716:
- Bugfix: (ET) Work item 10031 - Non-unique newline representation causes problems with LEN formula
717:
- Bugfix: (ET) Work item 10033 - Newline in cell not showing with PHPExcel_Writer_HTML and PHPExcel_Writer_PDF
718:
- Bugfix: (ET) Work item 10046 - Rich-Text strings get prefixed by when output by HTML writer
719:
- Bugfix: (ET) Work item 10052 - Leading spaces do not appear in output by HTML/PDF writers
720:
- Bugfix: (MB) Work item 10061 - Empty Apache POI-generated file can not be read
721:
- Bugfix: (ET) Work item 10068 - Column width not scaling correctly with font size in HTML and PDF writers
722:
- Bugfix: (ET) Work item 10069 - Inaccurate row heights with HTML writer
723:
- Bugfix: (MB) Patch 2992 - Reference helper
724:
- Bugfix: (MBaker) - Excel 5 Named ranges should not be local to the worksheet, but accessible from all worksheets
725:
- Bugfix: (ET) Work item 10088 - Row heights are ignored by PHPExcel_Writer_PDF
726:
- Bugfix: (MB) Patch 3003 - Write raw XML
727:
- Bugfix: (ET) Work item 10098 - removeRow(), removeColumn() not always clearing cell values
728:
- Bugfix: (ET) Work item 10142 - Problem reading certain hyperlink records with PHPExcel_Reader_Excel5
729:
- Bugfix: (ET) Work item 10143 - Hyperlink cell range read failure with PHPExcel_Reader_Excel2007
730:
- Bugfix: (MB) Work item 10149 - 'Column string index can not be empty.'
731:
- Bugfix: (ET) Work item 10204 - getHighestColumn() sometimes says there are 256 columns with PHPExcel_Reader_Excel5
732:
- Bugfix: (ET) Work item 10220 - extractSheetTitle fails when sheet title contains exclamation mark (!)
733:
- Bugfix: (ET) Work item 10221 - setTitle() sometimes erroneously appends integer to sheet name
734:
- Bugfix: (ET) Work item 10229 - Mac BIFF5 Excel file read failure (missing support for Mac OS Roman character set)
735:
- Bugfix: (ET) Work item 10230 - BIFF5 header and footer incorrectly read by PHPExcel_Reader_Excel5
736:
- Bugfix: (ET) Work item 10259 - iconv notices when reading hyperlinks with PHPExcel_Reader_Excel5
737:
- Bugfix: (ET) Work item 10252 - Excel5 reader OLE read failure with small Mac BIFF5 Excel files
738:
- Bugfix: (ET) Work item 10272 - Problem in reading formula : IF( IF ) with PHPExcel_Reader_Excel5
739:
- Bugfix: (ET) Work item 10274 - Error reading formulas referencing external sheets with PHPExcel_Reader_Excel5
740:
- Bugfix: (ET) Work item 10291 - Image horizontally stretched when default font size is increased (PHPExcel_Writer_Excel5)
741:
- Bugfix: (ET) Work item 10333 - Undefined offset in Reader\Excel5.php on line 3572
742:
- Bugfix: (MB) Work item 10340 - PDF output different then XLS (copied data)
743:
- Bugfix: (ET) Work item 10352 - Internal hyperlinks with UTF-8 sheet names not working in PHPExcel_Writer_Excel5
744:
- Bugfix: (ET) Work item 10361 - String shared formula result read error with PHPExcel_Reader_Excel5
745:
- Bugfix: (ET) Work item 10363 - Uncaught exception 'Exception' with message 'Valid scale is between 10 and 400.' in Classes/PHPExcel/Worksheet/PageSetup.php:338
746:
- Bugfix: (ET) Work item 10355 - Using setLoadSheetsOnly fails if you do not use setReadDataOnly(true) and sheet is not the first sheet
747:
- Bugfix: (MB) Work item 10362 - getCalculatedValue() sometimes incorrect with IF formula and 0-values
748:
- Bugfix: (MBaker) Work Item 10198 - Excel Reader 2007 problem with "shared" formulae when "master" is an error
749:
- Bugfix: (MBaker) Work Item 10106 - Named Range Bug, using the same range name on different worksheets
750:
- Bugfix: (MBaker) Work Item 10004 - Java code in JAMA classes
751:
- Bugfix: (MBaker) Work Item 9659 - getCalculatedValue() not working with some formulas involving error types
752:
- Bugfix: (MBaker) Work Item 9447 - evaluation of both return values in an IF() statement returning an error if either result was an error, irrespective of the IF evaluation
753:
- Bugfix: (MBaker) Work Item 6203 - Power in formulas: new calculation engine no longer treats ^ as a bitwise XOR operator
754:
- Bugfix: (MBaker) - Bugfixes and improvements to many of the Excel functions in PHPExcel
755:
- Added optional "places" parameter in the BIN2HEX(), BIN2OCT, DEC2BIN(), DEC2OCT(), DEC2HEX(), HEX2BIN(), HEX2OCT(), OCT2BIN() and OCT2HEX() Engineering Functions
756:
- Trap for unbalanced matrix sizes in MDETERM() and MINVERSE() Mathematic and Trigonometric functions
757:
- Fix for default characters parameter value for LEFT() and RIGHT() Text functions
758:
- Fix for GCD() and LCB() Mathematical functions when the parameters include a zero (0) value
759:
- Fix for BIN2OCT() Engineering Function for 2s complement values (which were returning hex values)
760:
- Fix for BESSELK() and BESSELY() Engineering functions
761:
- Fix for IMDIV() Engineering Function when result imaginary component is positive (wasn't setting the sign)
762:
- Fix for ERF() Engineering Function when called with an upper limit value for the integration
763:
- Fix to DATE() Date/Time Function for year value of 0
764:
- Set ISPMT() function as category FINANCIAL
765:
- Fix for DOLLARDE() and DOLLARFR() Financial functions
766:
- Fix to EFFECT() Financial function (treating $nominal_rate value as a variable name rather than a value)
767:
- Fix to CRITBINOM() Statistical function (CurrentValue and EssentiallyZero treated as constants rather than variables)
768:
Note that an Error in the function logic can still lead to a permanent loop
769:
- Fix to MOD() Mathematical function to work with floating point results
770:
- Fix for QUOTIENT() Mathematical function
771:
- 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
772:
- LOG() Function now correctly returns base-10 log when called with only one parameter, rather than the natural log as the default base
773:
- Modified text functions to handle multibyte character set (UTF-8).
774:
775:
776:
2009/04/22 (v1.6.7):
777:
- General: (MB) Work item 9416 - Deprecate misspelled setStriketrough() and getStriketrough() methods
778:
- General: (MB) Work item 9526 - Performance improvement when saving file
779:
- Feature: (MB) Work item 9598 - Check that sheet title has maximum 31 characters
780:
- Feature: (MB, ET) Work item 9631 - True support for Excel built-in number format codes
781:
- Feature: (ET) Work item 9683 - Ability to read defect BIFF5 Excel file without CODEPAGE record
782:
- Feature: (MB) Work item 9701 - Auto-detect which reader to invoke
783:
- Feature: (ET) Work item 9214 - Deprecate insertion of dates using PHP-time (Unix time) [request for removal of feature]
784:
- Feature: (ET) Work item 9747 - Support for entering time values like '9:45', '09:45' using AdvancedValueBinder
785:
- Feature: (ET) Work item 9797 - DataType dependent horizontal alignment in HTML and PDF writer
786:
- Bugfix: (MB) Work item 9375 - Cloning data validation object causes script to stop
787:
- Bugfix: (ET) Work item 9400 - Simultaneous repeating rows and repeating columns not working with PHPExcel_Writer_Excel5
788:
- Bugfix: (MB) Work item 9399 - Simultaneous repeating rows and repeating columns not working with PHPExcel_Writer_Excel2007
789:
- Bugfix: (ET) Work item 9437 - Row outline level not working with PHPExcel_Writer_Excel5
790:
- Bugfix: (ET) Work item 9452 - Occasional notices with PHPExcel_Reader_Excel5 when Excel file contains drawing elements
791:
- Bugfix: (ET) Work item 9453 - PHPExcel_Reader_Excel5 fails as a whole when workbook contains images other than JPEG/PNG
792:
- Bugfix: (ET) Work item 9444 - Excel5 writer checks for iconv but does not necessarily use it
793:
- Bugfix: (ET) Work item 9463 - Altering a style on copied worksheet alters also the original
794:
- Bugfix: (MB) Work item 9480 - Formulas are incorrectly updated when a sheet is renamed
795:
- Bugfix: (MB) Work item 9513 - PHPExcel_Worksheet::extractSheetTitle not treating single quotes correctly
796:
- Bugfix: (MB) Work item 9477 - PHP Warning raised in function array_key_exists
797:
- Bugfix: (MB) Work item 9599 - getAlignWithMargins() gives wrong value when using PHPExcel_Reader_Excel2007
798:
- Bugfix: (MB) Work item 9600 - getScaleWithDocument() gives wrong value when using PHPExcel_Reader_Excel2007
799:
- Bugfix: (MB) Work item 9630 - PHPExcel_Reader_Excel2007 not reading the first user-defined number format
800:
- Bugfix: (MB) Work item 9647 - Print area converted to uppercase after read with PHPExcel_Reader_Excel2007
801:
- Bugfix: (MB) Work item 9661 - Incorrect reading of scope for named range using PHPExcel_Reader_Excel2007
802:
- Bugfix: (MB) Work item 9690 - Error with pattern (getFillType) and rbg (getRGB)
803:
- Bugfix: (ET) Work item 9712 - AdvancedValueBinder affected by system timezone setting when inserting date values
804:
- Bugfix: (ET) Work item 9743 - PHPExcel_Reader_Excel2007 not reading value of active sheet index
805:
- Bugfix: (ET) Work item 9742 - getARGB() sometimes returns SimpleXMLElement object instead of string with PHPExcel_Reader_Excel2007
806:
- Bugfix: (ET) Work item 9731 - Negative image offset causes defects in 14excel5.xls and 20readexcel5.xlsx
807:
- Bugfix: (ET) Work item 9758 - HTML & PDF Writer not working with mergeCells (regression since 1.6.5)
808:
- Bugfix: (ET) Work item 9774 - Too wide columns with HTML and PDF writer
809:
- Bugfix: (MB) Work item 9775 - PDF and cyrillic fonts
810:
- Bugfix: (ET) Work item 9793 - Percentages not working correctly with HTML and PDF writers (shows 0.25% instead of 25%)
811:
- Bugfix: (ET) Work item 9791 - PHPExcel_Writer_HTML creates extra borders around cell contents using setUseInlineCss(true)
812:
- Bugfix: (ET) Work item 9784 - Problem with text wrap + merged cells in HTML and PDF writer
813:
- Bugfix: (ET) Work item 9814 - Adjacent path separators in include_path causing IOFactory to violate open_basedir restriction
814:
815:
816:
--------------------------------------------------------------------------------
817:
BREAKING CHANGE! In previous versions of PHPExcel up to and including 1.6.6,
818:
when a cell had a date-like number format code, it was possible to enter a date
819:
directly using an integer PHP-time without converting to Excel date format.
820:
821:
Starting with PHPExcel 1.6.7 this is no longer supported. Refer to the developer
822:
documentation for more information on entering dates into a cell.
823:
--------------------------------------------------------------------------------
824:
825:
826:
2009/03/02 (v1.6.6):
827:
- General: (MB) Work item 9102 - Improve support for built-in number formats in PHPExcel_Reader_Excel2007
828:
- General: (ET) Work item 9281 - Source files are in both UNIX and DOS formats - changed to UNIX
829:
- General: (MB) Work item 9338 - Update documentation: Which language to write formulas in?
830:
- Feature: (ET) Work item 8817 - Ignore DEFCOLWIDTH records with value 8 in PHPExcel_Reader_Excel5
831:
- Feature: (ET) Work item 8847 - Support for width, height, offsetX, offsetY for images in PHPExcel_Reader_Excel5
832:
- Feature: (MB) Work item 8870 - Disk Caching in specific folder
833:
- Feature: (MBaker) Work item 2346 - Added SUMX2MY2, SUMX2PY2, SUMXMY2, MDETERM and MINVERSE Mathematical and Trigonometric Functions
834:
- Feature: (MBaker) Work item 2346 - Added CONVERT Engineering Function
835:
- Feature: (MBaker) Work item 2346 - Added DB, DDB, DISC, DOLLARDE, DOLLARFR, INTRATE, IPMT, PPMT, PRICEDISC, PRICEMAT and RECEIVED Financial Functions
836:
- Feature: (MBaker) Work item 2346 - Added ACCRINTM, CUMIPMT, CUMPRINC, TBILLEQ, TBILLPRICE, TBILLYIELD, YIELDDISC and YIELDMAT Financial Functions
837:
- Feature: (MBaker) Work item 2346 - Added DOLLAR Text Function
838:
- Feature: (MBaker) Work item 2346 - Added CORREL, COVAR, FORECAST, INTERCEPT, RSQ, SLOPE and STEYX Statistical Functions
839:
- Feature: (MBaker) Work item 2346 - Added PEARSON Statistical Functions as a synonym for CORREL
840:
- Feature: (MBaker) Work item 2346 - Added LINEST, LOGEST (currently only valid for stats = false), TREND and GROWTH Statistical Functions
841:
- Feature: (MBaker) Work item 2346 - Added RANK and PERCENTRANK Statistical Functions
842:
- Feature: (MBaker) Work item 2346 - Added ROMAN Mathematical Function (Classic form only)
843:
- Feature: (MB) Work item 8931 - Update documentation to show example of getCellByColumnAndRow($col, $row)
844:
- Feature: (MB) Work item 8770 - Implement worksheet, row and cell iterators
845:
- Feature: (MB) Work item 9001 - Support for arbitrary defined names (named range)
846:
- Feature: (MB, ET) Work item 9016 - Update formulas when sheet title / named range title changes
847:
- Feature: (MB) Work item 9103 - Ability to read cached calculated value
848:
- Feature: (MBaker, ET) Work item 8483 - Support for Excel 1904 calendar date mode (Mac)
849:
- Feature: (ET) Work item 9194 - PHPExcel_Writer_Excel5 improvements writing shared strings table
850:
- Feature: (ET) Work item 9248 - PHPExcel_Writer_Excel5 iconv fallback when mbstring extension is not enabled
851:
- Feature: (ET) Work item 9253 - UTF-8 support in font names in PHPExcel_Writer_Excel5
852:
- Feature: (MB) Work item 9215 - Implement value binding architecture
853:
- Feature: (MB) Work item 6742 - PDF writer not working with UTF-8
854:
- Feature: (ET) Work item 9355 - Eliminate duplicate style entries in multisheet workbook written by PHPExcel_Writer_Excel5
855:
- Bugfix: (ET) Work item 8810 - Redirect to client browser fails due to trailing white space in class definitions
856:
- Bugfix: (MB) Work item 8816 - Spurious column dimension element introduced in blank worksheet after using PHPExcel_Writer_Excel2007
857:
- Bugfix: (ET) Work item 8830 - Image gets slightly narrower than expected when using PHPExcel_Writer_Excel5
858:
- Bugfix: (ET) Work item 8831 - Image laid over non-visible row gets squeezed in height when using PHPExcel_Writer_Excel5
859:
- Bugfix: (ET) Work item 8860 - PHPExcel_Reader_Excel5 fails when there are 10 or more images in the workbook
860:
- Bugfix: (MB) Work item 8909 - Different header/footer images in different sheets not working with PHPExcel_Writer_Excel2007
861:
- Bugfix: (MB, ET) Work item 8924 - Fractional seconds disappear when using PHPExcel_Reader_Excel2007 and PHPExcel_Reader_Excel5
862:
- Bugfix: (ET) Work item 7994 - Images not showing in OpenOffice when using PHPExcel_Writer_Excel5
863:
- Bugfix: (ET) Work item 9047 - Images not showing on print using PHPExcel_Writer_Excel5
864:
- Bugfix: (ET) Work item 9085 - PHPExcel_Writer_Excel5 maximum allowed record size 4 bytes too short
865:
- Bugfix: (MB) Work item 9119 - Not numeric strings are formatted as dates and numbers using worksheet's toArray method
866:
- Bugfix: (ET) Work item 9132 - Excel5 simple formula parsing error
867:
- Bugfix: (ET) Work item 9206 - Problems writing dates with CSV
868:
- Bugfix: (ET) Work item 9203 - PHPExcel_Reader_Excel5 reader fails with fatal error when reading group shapes
869:
- Bugfix: (ET) Work item 9231 - PHPExcel_Writer_Excel5 fails completely when workbook contains more than 57 colors
870:
- Bugfix: (ET) Work item 9244 - PHPExcel_Writer_PDF not compatible with autoload
871:
- Bugfix: (ET) Work item 9250 - Fatal error: Call to a member function getNestingLevel() on a non-object in PHPExcel/Reader/Excel5.php on line 690
872:
- Bugfix: (MB) Work item 9246 - Notices when running test 04printing.php on PHP 5.2.8
873:
- Bugfix: (MB) Work item 9294 - insertColumn() spawns creation of spurious RowDimension
874:
- BugFix: (MBaker) Work item 9296 - Fix declarations for methods in extended Trend classes
875:
- Bugfix: (MBaker) Work item 2346 - Fix to parameters for the FORECAST Statistical Function
876:
- Bugfix: (MB) Work item 7083 - PDF writer problems with cell height and text wrapping
877:
- Bugfix: (MBaker) Work Item 9337 - Fix test for calculated value in case the returned result is an array
878:
- Bugfix: (ET) Work Item 9354 - Column greater than 256 results in corrupt Excel file using PHPExcel_Writer_Excel5
879:
- Bugfix: (MB) Work item 9351 - Excel Numberformat 0.00 results in non internal decimal places values in toArray() Method
880:
- Bugfix: (MB,ET) Work item 9356 - setAutoSize not taking into account text rotation
881:
- Bugfix: (ET) Work item 9372 - Call to undefined method PHPExcel_Worksheet_MemoryDrawing::getPath() in PHPExcel/Writer/HTML.php
882:
883:
884:
2009/01/05 (v1.6.5):
885:
- General: (MB) Applied patch 2063
886:
- General: (MB) Applied patch from work item 8073 - Optimise Shared Strings
887:
- General: (MB) Applied patch from work item 8074 - Optimise Cell Sorting
888:
- General: (MB) Applied patch from work item 8075 - Optimise Style Hashing
889:
- General: (ET) Applied patch from work item 8245 - UTF-8 enhancements
890:
- General: (ET) Applied patch from work item 8283 - PHPExcel_Writer_HTML validation errors against strict HTML 4.01 / CSS 2.1
891:
- General: (MB) Documented work items 6203 and 8110 in manual
892:
- General: (ET) Restructure package hierachy so classes can be found more easily in auto-generated API (from work item 8468)
893:
- General: (MB) Work item 8806 - Redirect output to a client's browser: Update recommendation in documentation
894:
- Feature: (ET) Work item 7897 - PHPExcel_Reader_Excel5 support for print gridlines
895:
- Feature: (ET) Work item 7899 - Screen gridlines support in Excel5 reader/writer
896:
- Feature: (MB, ET) Work item 7552 - Option for adding image to spreadsheet from image resource in memory
897:
- Feature: (ET) Work item 7862 - PHPExcel_Reader_Excel5 style support for BIFF5 files (Excel 5.0 - Excel 95)
898:
- Feature: (ET) Work item 7918 - PHPExcel_Reader_Excel5 support for user-defined colors and special built-in colors
899:
- Feature: (ET) Work item 7992 - Support for freeze panes in PHPExcel_Reader_Excel5
900:
- Feature: (ET) Work item 7996 - Support for header and footer margins in PHPExcel_Reader_Excel5
901:
- Feature: (ET) Work item 7997 - Support for active sheet index in Excel5 reader/writer
902:
- Feature: (MB) Work item 7991 - Freeze panes not read by PHPExcel_Reader_Excel2007
903:
- Feature: (MB, ET) Work item 7993 - Support for screen zoom level (feature request)
904:
- Feature: (ET) Work item 8012 - Support for default style in PHPExcel_Reader_Excel5
905:
- Feature: (MB) Work item 8094 - Apple iWork / Numbers.app incompatibility
906:
- Feature: (MB) Work item 7931 - Support "between rule" in conditional formatting
907:
- Feature: (MB) Work item 8308 - Comment size, width and height control (feature request)
908:
- Feature: (ET) Work item 8418 - Improve method for storing MERGEDCELLS records in PHPExcel_Writer_Excel5
909:
- Feature: (ET) Work item 8435 - Support for protectCells() in Excel5 reader/writer
910:
- Feature: (ET) Work item 8472 - Support for fitToWidth and fitToHeight pagesetup properties in PHPExcel_Reader_Excel5
911:
- Feature: (ET) Work item 8489 - Support for setShowSummaryBelow() and setShowSummaryRight() in PHPExcel_Writer_Excel5
912:
- Feature: (MB) Work item 8483 - Support for Excel 1904 calendar date mode (Mac)
913:
- Feature: (ET) Work item 7538 - Excel5 reader: Support for reading images (bitmaps)
914:
- Feature: (ET) Work item 8787 - Support for default style in PHPExcel_Writer_Excel5
915:
- Feature: (MBaker) 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.
916:
- Feature: (MBaker) Work item 2346 - Added ERROR.TYPE Information Function, MMULT Mathematical and Trigonometry Function, and TRANSPOSE Lookup and Reference Function
917:
- Bugfix: (ET) Work item 7896 - setPrintGridlines(true) not working with PHPExcel_Writer_Excel5
918:
- Bugfix: (ET) Work item 7907 - Incorrect mapping of fill patterns in PHPExcel_Writer_Excel5
919:
- Bugfix: (MB) Work item 7898 - setShowGridlines(false) not working with PHPExcel_Writer_Excel2007
920:
- Bugfix: (MB) Work item 7905 - getShowGridlines() gives inverted value when reading sheet with PHPExcel_Reader_Excel2007
921:
- Bugfix: (ET) Work item 7944 - User-defined column width becomes slightly larger after read/write with Excel5
922:
- Bugfix: (ET) Work item 7949 - Incomplete border style support in PHPExcel_Writer_Excel5
923:
- Bugfix: (MB) Work item 7928 - Conditional formatting "containsText" read/write results in MS Office Excel 2007 crash
924:
- Bugfix: (MB) Work item 7995 - All sheets are always selected in output when using PHPExcel_Writer_Excel2007
925:
- Bugfix: (MB) Work item 8013 - COLUMN function warning message during plain read/write
926:
- Bugfix: (MB) Work item 8155 - setValue(0) results in string data type '0'
927:
- Bugfix: (MB) Work item 8226 - Styles not removed when removing rows from sheet
928:
- Bugfix: (MB) Work item 8301 - =IF formula causes fatal error during $objWriter->save() in Excel2007 format
929:
- Bugfix: (ET) Work item 8333 - Exception thrown reading valid xls file: "Excel file is corrupt. Didn't find CONTINUE record while reading shared strings"
930:
- Bugfix: (ET) Work item 8320 - MS Outlook corrupts files generated by PHPExcel_Writer_Excel5
931:
- Bugfix: (MB) Work item 8351 - Undefined method PHPExcel_Worksheet::setFreezePane() in ReferenceHelper.php on line 271
932:
- Bugfix: (MB) Work item 8401 - Ampersands (&), left and right angles (<, >) in Rich-Text strings leads to corrupt output using PHPExcel_Writer_Excel2007
933:
- Bugfix: (ET) Work item 8408 - Print header and footer not supporting UTF-8 in PHPExcel_Writer_Excel5
934:
- Bugfix: (ET) Work item 8463 - Vertical page breaks not working with PHPExcel_Writer_Excel5
935:
- Bugfix: (ET) Work item 8476 - Missing support for accounting underline types in PHPExcel_Writer_Excel5
936:
- Bugfix: (ET) Work item 8482 - Infinite loops when reading corrupt xls file using PHPExcel_Reader_Excel5
937:
- Bugfix: (ET) Work item 8566 - Sheet protection password not working with PHPExcel_Writer_Excel5
938:
- Bugfix: (ET) Work item 8596 - PHPExcel_Style_NumberFormat::FORMAT_NUMBER ignored by PHPExcel_Writer_Excel5
939:
- Bugfix: (ET) Work item 8781 - PHPExcel_Reader_Excel5 fails a whole when workbook contains a chart
940:
- Bugfix: (ET) Work item 8788 - Occasional loss of column widths using PHPExcel_Writer_Excel5
941:
- Bugfix: (ET) Work item 8795 - Notices while reading formulas with deleted sheet references using PHPExcel_Reader_Excel5
942:
- Bugfix: (MB) Work item 8807 - Default style not read by PHPExcel_Reader_Excel2007
943:
- Bugfix: (MB) Work item 9341 - Blank rows occupy too much space in file generated by PHPExcel_Writer_Excel2007
944:
945:
946:
2008/10/27 (v1.6.4):
947:
- General: (ET) Work item 7882 - RK record number error in MS developer documentation: 0x007E should be 0x027E
948:
- Feature: (MBaker) Work item 7878 - getHighestColumn() returning "@" for blank worksheet causes corrupt output
949:
- Feature: (MBaker) Work item 2346 - Implement ROW and COLUMN Lookup/Reference Functions (when specified with a parameter)
950:
- Feature: (MBaker) Work item 2346 - Implement initial work on OFFSET Lookup/Reference Function (returning address rather than value at address)
951:
- Feature: (ET) Work item 7416 - Excel5 reader: Page margins
952:
- Feature: (ET) Work item 7417 - Excel5 reader: Header & Footer
953:
- Feature: (ET) Work item 7449 - Excel5 reader support for page setup (paper size etc.)
954:
- Feature: (MB) Work item 7445 - Improve speed and memory consumption of PHPExcel_Writer_CSV
955:
- Feature: (MB) Work item 7432 - Better recognition of number format in HTML, CSV, and PDF writer
956:
- Feature: (MB) Work item 7485 - Font support: Superscript and Subscript
957:
- Feature: (ET) Work item 7509 - Excel5 reader font support: Super- and subscript
958:
- Feature: (ET) Work item 7521 - Excel5 reader style support: Text rotation and stacked text
959:
- Feature: (ET) Work item 7530 - Excel5 reader: Support for hyperlinks
960:
- Feature: (MB, ET) Work item 7557 - Import sheet by request
961:
- Feature: (ET) Work item 7607 - PHPExcel_Reader_Excel5 support for page breaks
962:
- Feature: (ET) Work item 7622 - PHPExcel_Reader_Excel5 support for shrink-to-fit
963:
- Feature: (MB, ET) Work item 7675 - Support for error types
964:
- Feature: (ET) Work item 7388 - Excel5 reader true formula support
965:
- Feature: (ET) Work item 7701 - Support for named ranges (defined names) in PHPExcel_Reader_Excel5
966:
- Feature: (ET) Work item 7781 - Support for repeating rows and repeating columns (print titles) in PHPExcel_Reader_Excel5
967:
- Feature: (ET) Work item 7783 - Support for print area in PHPExcel_Reader_Excel5
968:
- Feature: (ET) Work item 7795 - Excel5 reader and writer support for horizontal and vertical centering of page
969:
- Feature: (MB) Applied patch 1962
970:
- Feature: (ET) Work item 7866 - Excel5 reader and writer support for hidden cells (formulas)
971:
- Feature: (MB, ET) Work item 7612 - Support for indentation in cells (feature request)
972:
- Feature: (MB, ET) Work item 7828 - Option for reading only specified interval of rows in a sheet
973:
- Bugfix: (MBaker) Work item 7367 - PHPExcel_Calculation_Functions::DATETIMENOW() and PHPExcel_Calculation_Functions::DATENOW() to force UTC
974:
- Bugfix: (MBaker) Work item 7395 - Modified PHPExcel_Shared_Date::FormattedPHPToExcel() and PHPExcel_Shared_Date::ExcelToPHP to force datatype for return values
975:
- Bugfix: (ET) Work item 7450 - Excel5 reader not producing UTF-8 strings with BIFF5 files
976:
- Bugfix: (MB) Work item 7470 - Array constant in formula gives run-time notice with Excel2007 writer
977:
- Bugfix: (MB) Work item 7494 - PHPExcel_Reader_Excel2007 setReadDataOnly(true) returns Rich-Text
978:
- Bugfix: (ET) Work item 7496 - PHPExcel_Reader_Excel5 setReadDataOnly(true) returns Rich-Text
979:
- Bugfix: (MB) Work item 7497 - Characters before superscript or subscript losing style
980:
- Bugfix: (MB) Work item 7507 - Subscript not working with HTML writer
981:
- Bugfix: (MB) Work item 7508 - DefaultColumnDimension not working on first column (A)
982:
- Bugfix: (MB) Work item 7527 - Negative numbers are stored as text in PHPExcel_Writer_2007
983:
- Bugfix: (ET) Work item 7531 - Text rotation and stacked text not working with PHPExcel_Writer_Excel5
984:
- Bugfix: (MB) Work item 7536 - PHPExcel_Shared_Date::isDateTimeFormatCode erroneously says true
985:
- Bugfix: (MB) Work item 7559 - Different images with same filename in separate directories become duplicates
986:
- Bugfix: (ET) Work item 7568 - PHPExcel_Reader_Excel5 not returning sheet names as UTF-8 using for Excel 95 files
987:
- Bugfix: (MB) Work item 7575 - setAutoSize(true) on empty column gives column width of 10 using PHPExcel_Writer_Excel2007
988:
- Bugfix: (MB, ET) Work item 7573 - setAutoSize(true) on empty column gives column width of 255 using PHPExcel_Writer_Excel5
989:
- Bugfix: (MB) Work item 7514 - Worksheet_Drawing bug
990:
- Bugfix: (MB) Work item 7593 - getCalculatedValue() with REPT function causes script to stop
991:
- Bugfix: (MB) Work item 7594 - getCalculatedValue() with LEN function causes script to stop
992:
- Bugfix: (MB) Work item 7600 - Explicit fit-to-width (page setup) results in fit-to-height becoming 1
993:
- Bugfix: (MB) Work item 7610 - Fit-to-width value of 1 is lost after read/write of Excel2007 spreadsheet
994:
- Bugfix: (MB) Work item 7516 - Conditional styles not read properly using PHPExcel_Reader_Excel2007
995:
- Bugfix: (MB) Work item 7611 - PHPExcel_Writer_2007: Default worksheet style works only for first sheet
996:
- Bugfix: (ET) Work item 6940 - Cannot Lock Cells using PHPExcel_Writer_Excel5
997:
- Bugfix: (ET) Work item 7621 - Incorrect cell protection values found when using Excel5 reader
998:
- Bugfix: (ET) Work item 7623 - Default row height not working above highest row using PHPExcel_Writer_Excel5
999:
- Bugfix: (ET) Work item 7637 - Default column width does not get applied when using PHPExcel_Writer_Excel5
000:
- Bugfix: (ET) Work item 7642 - Broken support for UTF-8 string formula results in PHPExcel_Reader_Excel5
001:
- Bugfix: (ET) Work item 7643 - UTF-8 sheet names not working with PHPExcel_Writer_Excel5
002:
- Bugfix: (MB) Work item 7631 - getCalculatedValue() with ISNONTEXT function causes script to stop
003:
- Bugfix: (ET) Work item 7652 - Missing BIFF3 functions in PHPExcel_Writer_Excel5: USDOLLAR (YEN), FINDB, SEARCHB, REPLACEB, LEFTB, RIGHTB, MIDB, LENB, ASC, DBCS (JIS)
004:
- Bugfix: (ET) Work item 7663 - Excel5 reader doesn't read numbers correctly in 64-bit systems
005:
- Bugfix: (ET) Work item 7667 - Missing BIFF5 functions in PHPExcel_Writer_Excel5: ISPMT, DATEDIF, DATESTRING, NUMBERSTRING
006:
- Bugfix: (ET) Work item 7668 - Missing BIFF8 functions in PHPExcel_Writer_Excel5: GETPIVOTDATA, HYPERLINK, PHONETIC, AVERAGEA, MAXA, MINA, STDEVPA, VARPA, STDEVA, VARA
007:
- Bugfix: (MB) Work item 7657 - Wrong host value in PHPExcel_Shared_ZipStreamWrapper::stream_open()
008:
- Bugfix: (ET) Work item 7676 - PHPExcel_Reader_Excel5 not reading explicitly entered error types in cells
009:
- Bugfix: (ET) Work item 7678 - Boolean and error data types not preserved for formula results in PHPExcel_Reader_Excel5
010:
- Bugfix: (MB) Work item 7695 - PHPExcel_Reader_Excel2007 ignores cell data type
011:
- Bugfix: (ET) Work item 7712 - PHPExcel_Reader_Excel5 ignores cell data type
012:
- Bugfix: (ET) Work item 7587 - PHPExcel_Writer_Excel5 not aware of data type
013:
- Bugfix: (ET) Work item 7713 - Long strings sometimes truncated when using PHPExcel_Reader_Excel5
014:
- Bugfix: (ET) Work item 7727 - Direct entry of boolean or error type in cell not supported by PHPExcel_Writer_Excel5
015:
- Bugfix: (MB) Work item 7714 - PHPExcel_Reader_Excel2007: Error reading cell with data type string, date number format, and numeric-like cell value
016:
- Bugfix: (ET) Work item 7735 - Row and column outlines (group indent level) not showing after using PHPExcel_Writer_Excel5
017:
- Bugfix: (ET) Work item 7737 - Missing UTF-8 support in number format codes for PHPExcel_Writer_Excel5
018:
- Bugfix: (ET) Work item 7750 - Missing UTF-8 support with PHPExcel_Writer_Excel5 for explicit string in formula
019:
- Bugfix: (MB) Work item 7726 - Problem with class constants in PHPExcel_Style_NumberFormat
020:
- Bugfix: (ET) Work item 7758 - Sometimes errors with PHPExcel_Reader_Excel5 reading hyperlinks
021:
- Bugfix: (ET) Work item 7759 - Hyperlink in cell always results in string data type when using PHPExcel_Writer_Excel5
022:
- Bugfix: (ET) Work item 7771 - Excel file with blank sheet seen as broken in MS Office Excel 2007 when created by PHPExcel_Writer_Excel5
023:
- Bugfix: (ET) Work item 7785 - PHPExcel_Reader_Excel5: Incorrect reading of formula with explicit string containing (escaped) double-quote
024:
- Bugfix: (MB) Work item 7787 - getCalculatedValue() fails on formula with sheet name containing (escaped) single-quote
025:
- Bugfix: (MB) Work item 7786 - getCalculatedValue() fails on formula with explicit string containing (escaped) double-quote
026:
- Bugfix: (MB) Work item 7780 - Problems with simultaneous repeatRowsAtTop and repeatColumnsAtLeft using Excel2007 reader and writer
027:
- Bugfix: (ET) Work item 7802 - PHPExcel_Reader_Excel5: Error reading formulas with sheet reference containing special characters
028:
- Bugfix: (ET) Work item 7831 - Off-sheet references sheet!A1 not working with PHPExcel_Writer_Excel5
029:
- Bugfix: (ET) Work item 7834 - Repeating rows/columns (print titles), print area not working with PHPExcel_Writer_Excel5
030:
- Bugfix: (ET) Work item 7849 - Formula having datetime number format shows as text when using PHPExcel_Writer_Excel5
031:
- Bugfix: (MBaker) Work item 7863 - Cannot set formula to hidden using applyFromArray()
032:
- Bugfix: (MBaker) Work item 7805 - HTML/PDF Writers limited to 26 columns by calculateWorksheetDimension (erroneous comparison in getHighestColumn() method)
033:
- Bugfix: (MB) Work item 7873 - Formula returning error type is lost when read by PHPExcel_Reader_Excel2007
034:
- Bugfix: (ET) Work item 7883 - PHPExcel_Reader_Excel5: Cell style lost for last column in group of blank cells
035:
- Bugfix: (MB) Work item 7886 - Column width sometimes collapses to auto size using Excel2007 reader/writer
036:
- Bugfix: (MB) Work item 9343 - Data Validation Formula = 0 crashes Excel
037:
038:
039:
2008/08/25 (v1.6.3):
040:
- Bugfix: (MBaker) Work item 7367 - Modified PHPExcel_Shared_Date::PHPToExcel() to force UTC
041:
- General: (MB) Applied patch 1629
042:
- General: (MB) Applied patch 1644
043:
- General: (MB) Work item 6485 - Implement repeatRow and repeatColumn in Excel5 writer
044:
- General: (MB) Work item 6838 - Remove scene3d filter in Excel2007 drawing
045:
- Feature: (MBaker) Work item 2346 - Implement CHOOSE and INDEX Lookup/Reference Functions
046:
- Feature: (MBaker) Work item 2346 - Implement CLEAN Text Functions
047:
- Feature: (MBaker) Work item 2346 - Implement YEARFRAC Date/Time Functions
048:
- Feature: (MB) Work item 6508 - Implement 2 options for print/show gridlines
049:
- Feature: (MB) Work item 7270 - Add VLOOKUP function (contribution)
050:
- Feature: (MB) Work item 7182 - Implemented: ShrinkToFit
051:
- Feature: (MB) Work item 7218 - Row heights not updated correctly when inserting new rows
052:
- Feature: (MB) Work item 7157 - Copy worksheets within the same workbook
053:
- Feature: (ET) Work item 7290 - Excel5 reader style support: horizontal and vertical alignment plus text wrap
054:
- Feature: (ET) Work item 7294 - Excel5 reader support for merged cells
055:
- Feature: (ET) Work item 7296 - Excel5 reader: Sheet Protection
056:
- Feature: (ET) Work item 7297 - Excel5 reader: Password for sheet protection
057:
- Feature: (ET) Work item 7299 - Excel5 reader: Column width
058:
- Feature: (ET) Work item 7301 - Excel5 reader: Row height
059:
- Feature: (ET) Work item 7304 - Excel5 reader: Font support
060:
- Feature: (ET) Work item 7324 - Excel5 reader: support for locked cells
061:
- Feature: (ET) Work item 7330 - Excel5 reader style support: Fill (background colors and patterns)
062:
- Feature: (ET) Work item 7332 - Excel5 reader style support: Borders (style and color)
063:
- Feature: (ET) Work item 7346 - Excel5 reader: Rich-Text support
064:
- Feature: (MB) Work item 7313 - Read Excel built-in number formats with Excel 2007 reader
065:
- Feature: (ET) Work item 7317 - Excel5 reader: Number format support
066:
- Feature: (MB) Work item 7362 - Creating a copy of PHPExcel object
067:
- Feature: (ET) Work item 7373 - Excel5 reader: support for row / column outline (group)
068:
- Feature: (MB) Work item 7380 - Implement default row/column sizes
069:
- Feature: (MB) Work item 7364 - Writer HTML - option to return styles and table separately
070:
- Feature: (ET) Work item 7393 - Excel5 reader: Support for remaining built-in number formats
071:
- Bugfix: (MBaker) Fixed rounding in HOUR MINUTE and SECOND Time functions, and improved performance for these
072:
- Bugfix: (MBaker) Fix to TRIM function
073:
- Bugfix: (MBaker) Fixed range validation in TIME Functions.php
074:
- Bugfix: (MBaker) EDATE and EOMONTH functions now return date values based on the returnDateType flag
075:
- Bugfix: (MBaker) Write date values that are the result of a calculation function correctly as Excel serialized dates rather than PHP serialized date values
076:
- Bugfix: (MB) Work item 6690 - Excel2007 reader not always reading boolean correctly
077:
- Bugfix: (MB) Work item 6275 - Columns above IZ
078:
- Bugfix: (MB) Work item 6853 - Other locale than English causes Excel2007 writer to produce broken xlsx
079:
- Bugfix: (MB) Work item 7061 - Typo: Number_fromat in NumberFormat.php
080:
- Bugfix: (MB) Work item 6865 - Bug in Worksheet_BaseDrawing setWidth()
081:
- Bugfix: (MB) Work item 6891 - PDF writer collapses column width for merged cells
082:
- Bugfix: (MB) Work item 6867 - Issues with drawings filenames
083:
- Bugfix: (MB) Work item 7073 - fromArray() local variable isn't defined
084:
- Bugfix: (MB) Work item 7276 - PHPExcel_Writer_Excel5->setTempDir() not passed to all classes involved in writing to a file
085:
- Bugfix: (MB) Work item 7277 - Excel5 reader not handling UTF-8 properly
086:
- Bugfix: (MB) Work item 7327 - If you write a 0 value in cell, cell shows as empty
087:
- Bugfix: (MB) Work item 7302 - Excel2007 writer: Row height ignored for empty rows
088:
- Bugfix: (MB) Work item 7281 - Excel2007 (comments related error)
089:
- Bugfix: (MB) Work item 7345 - Column width in other locale
090:
- Bugfix: (MB) Work item 7347 - Excel2007 reader not reading underlined Rich-Text
091:
- Bugfix: (ET) Work item 7357 - Excel5 reader converting booleans to strings
092:
- Bugfix: (MB) Work item 7365 - Recursive Object Memory Leak
093:
- Bugfix: (MB) Work item 7372 - Excel2007 writer ignoring row dimensions without cells
094:
- Bugfix: (ET) Work item 7382 - Excel5 reader is converting formatted numbers / dates to strings
095:
096:
097:
2008/06/23 (v1.6.2):
098:
- General: (MB) Work item 6088 - Document style array values
099:
- General: (MB) Applied patch 1195
100:
- General: (MB) Work item 6178 - Redirecting output to a client’s web browser - http headers
101:
- General: (MB) Work item 6187 - Improve worksheet garbage collection
102:
- General: (MBaker) 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.
103:
- General: (MBaker) 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.
104:
- General: (MBaker) Implement ACOSH, ASINH and ATANH functions for those operating platforms/PHP versions that don't include these functions
105:
- General: (MBaker) Implement ATAN2 logic reversing the arguments as per Excel
106:
- General: (MBaker) Additional validation of parameters for COMBIN
107:
- General: (MBaker) Fixed validation for CEILING and FLOOR when the value and significance parameters have different signs; and allowed default value of 1 or -1 for significance when in GNUMERIC compatibility mode
108:
- Feature: (MBaker) Work item 2346 - Implement ADDRESS, ISLOGICAL, ISTEXT and ISNONTEXT functions
109:
- Feature: (MBaker) Work item 2346 - Implement COMPLEX, IMAGINARY, IMREAL, IMARGUMENT, IMCONJUGATE, IMABS, IMSUB, IMDIV, IMSUM, IMPRODUCT, IMSQRT, IMEXP, IMLN, IMLOG10, IMLOG2, IMPOWER IMCOS and IMSIN Engineering functions
110:
- Feature: (MBaker) Work item 2346 - Implement NETWORKDAYS and WORKDAY Date/Time functions
111:
- Feature: (MB) Work item 6100 - Make cell column AAA available
112:
- Feature: (MB) Work item 6095 - Mark particular cell as selected when opening Excel
113:
- Feature: (MB) Work item 6120 - Multiple sheets in PDF and HTML
114:
- Feature: (MB) Work item 6227 - Implement PHPExcel_ReaderFactory and PHPExcel_WriterFactory
115:
- Feature: (MB) Work item 6249 - Set image root of PHPExcel_Writer_HTML
116:
- Feature: (MB) Work item 6264 - Enable/disable calculation cache
117:
- Feature: (MB) Work item 6259 - PDF writer and multi-line text
118:
- Feature: (MB) Work item 6350 - Feature request - setCacheExpirationTime()
119:
- Feature: (JB) Work item 6370 - Implement late-binding mechanisms to reduce memory footprint
120:
- Feature: (JB) Work item 6430 - Implement shared styles
121:
- Feature: (MB) Work item 6391 - Copy sheet from external Workbook to active Workbook
122:
- Feature: (MB) Work item 6428 - Functions in Conditional Formatting
123:
- Bugfix: (MB) Work item 6096 - Default Style in Excel5
124:
- Bugfix: (MB) Work item 6150 - Numbers starting with '+' cause Excel 2007 errors
125:
- Bugfix: (MB) Work item 6092 - ExcelWriter5 is not PHP5 compatible, using it with E_STRICT results in a bunch of errors (applied patches)
126:
- Bugfix: (MB) Work item 6179 - Error Reader Excel2007 line 653 foreach ($relsDrawing->Relationship as $ele)
127:
- Bugfix: (MB) Work item 6229 - Worksheet toArray() screws up DATE
128:
- Bugfix: (MB) Work item 6253 - References to a Richtext cell in a formula
129:
- Bugfix: (MB) Work item 6285 - insertNewColumnBefore Bug
130:
- Bugfix: (MB) Work item 6319 - Error reading Excel2007 file with shapes
131:
- Bugfix: (MBaker) Work item 6302 - Determine whether date values need conversion from PHP dates to Excel dates before writing to file, based on the data type (float or integer)
132:
- Bugfix: (MBaker) Fixes to DATE function when it is given negative input parameters
133:
- Bugfix: (MB) Work item 6347 - PHPExcel handles empty cells other than Excel
134:
- Bugfix: (MB) Work item 6348 - PHPExcel handles 0 and "" as being the same
135:
- Bugfix: (MB) Work item 6357 - Problem Using Excel2007 Reader for Spreadsheets containing images
136:
- Bugfix: (MB) Work item 6359 - ShowGridLines ignored when reading/writing Excel 2007
137:
- Bugfix: (MB) Work item 6426 - Bug With Word Wrap in Excel 2007 Reader
138:
139:
140:
2008/04/28 (v1.6.1):
141:
- General: (MB) Work item 5532 - Fix documentation printing
142:
- General: (MB) Work item 5586 - Memory usage improvements
143:
- General: (MB) Applied patch 990
144:
- General: (MB) Applied patch 991
145:
- Feature: (BM) Work item 2841 - Implement PHPExcel_Reader_Excel5
146:
- Feature: (MB) Work item 5564 - Implement "toArray" and "fromArray" method
147:
- Feature: (MB) Work item 5665 - Read shared formula
148:
- Feature: (MB) Work item 5681 - Read image twoCellAnchor
149:
- Feature: (MB) Work item 4446 - &G Image as bg for headerfooter
150:
- Feature: (MB) Work item 5834 - Implement page layout functionality for Excel5 format
151:
- Feature: (MB) Work item 6039 - Feature request: PHPExcel_Writer_PDF
152:
- Bugfix: (MB) Work item 5517 - DefinedNames null check
153:
- Bugfix: (MB) Work item 5463 - Hyperlinks should not always have trailing slash
154:
- Bugfix: (MB) Work item 5592 - Saving Error - Uncaught exception (#REF! named range)
155:
- Bugfix: (MB) Work item 5634 - Error when creating Zip file on Linux System (Not Windows)
156:
- Bugfix: (MB) Work item 5876 - Time incorrecly formated
157:
- Bugfix: (MB) Work item 5914 - Conditional formatting - second rule not applied
158:
- Bugfix: (MB) Work item 5978 - PHPExcel_Reader_Excel2007 cannot load PHPExcel_Shared_File
159:
- Bugfix: (MB) Work item 6020 - Output redirection to web browser
160:
161:
162:
2008/02/14 (v1.6.0):
163:
- General: (MB) Work item 3156 - Use PHPExcel datatypes in formula calculation
164:
- Feature: (MB) Work item 5019 - Center on page when printing
165:
- Feature: (MB) Work item 5099 - Hyperlink to other spreadsheet
166:
- Feature: (MB) Work item 5104 - Set the print area of a worksheet
167:
- Feature: (MB) Work item 5118 - Read "definedNames" property of worksheet
168:
- Feature: (MB) Work item 5338 - Set default style for all cells
169:
- Feature: (MB) Work item 4216 - Named Ranges
170:
- Feature: (MB) Work item 5398 - Implement worksheet references (Sheet1!A1)
171:
- Bugfix: (MB) Work item 4967 - Redirect output to a client's web browser
172:
- Bugfix: (MB) Work item 5008 - "File Error: data may have been lost." seen in Excel 2007 and Excel 2003 SP3 when opening XLS file
173:
- Bugfix: (MB) Work item 5165 - Bug in style's getHashCode()
174:
- Bugfix: (MB) Work item 5165 - PHPExcel_Reader not correctly reading numeric values
175:
- Bugfix: (MB) Work item 5324 - Text rotation is read incorrectly
176:
- Bugfix: (MB) Work item 5326 - Enclosure " and data " result a bad data : \" instead of ""
177:
- Bugfix: (MB) Work item 5332 - Formula parser - IF statement returning array instead of scalar
178:
- Bugfix: (MB) Work item 5351 - setFitToWidth(nbpage) & setFitToWidth(nbpage) work partially
179:
- Bugfix: (MB) Work item 5361 - Worksheet::setTitle() causes unwanted renaming
180:
- Bugfix: (MB) Work item 5407 - Hyperlinks not working. Results in broken xlsx file.
181:
182:
183:
2007/12/24 (v1.5.5):
184:
- General: (MB) Work item 4135 - Grouping Rows
185:
- General: (MB) Work item 4427 - Semi-nightly builds
186:
- Feature: (MB) Work item 3155 - Implement "date" datatype
187:
- Feature: (MB) Work item 4150 - Date format not honored in CSV writer
188:
- Feature: (MB) Work item 4199 - RichText and sharedStrings
189:
- Feature: (MB) Work item 2346 - Implement more Excel calculation functions
190:
- Addition of DATE, DATEDIF, DATEVALUE, DAY, DAYS360
191:
- Feature: (MBaker) Work item 2346 - Implement more Excel calculation functions
192:
- Addition of AVEDEV, HARMEAN and GEOMEAN
193:
- Addition of the BINOMDIST (Non-cumulative only), COUNTBLANK, EXPONDIST, FISHER, FISHERINV, NORMDIST, NORMSDIST, PERMUT, POISSON (Non-cumulative only) and STANDARDIZE Statistical Functions
194:
- Addition of the CEILING, COMBIN, EVEN, FACT, FACTDOUBLE, FLOOR, MULTINOMIAL, ODD, ROUNDDOWN, ROUNDUP, SIGN, SQRTPI and SUMSQ Mathematical Functions
195:
- Addition of the NORMINV, NORMSINV, CONFIDENCE and SKEW Statistical Functions
196:
- Addition of the CRITBINOM, HYPGEOMDIST, KURT, LOGINV, LOGNORMDIST, NEGBINOMDIST and WEIBULL Statistical Functions
197:
- Addition of the LARGE, PERCENTILE, QUARTILE, SMALL and TRIMMEAN Statistical Functions
198:
- Addition of the BIN2HEX, BIN2OCT, DELTA, ERF, ERFC, GESTEP, HEX2BIN, HEX2DEC, HEX2OCT, OCT2BIN and OCT2HEX Engineering Functions
199:
- Addition of the CHIDIST, GAMMADIST and GAMMALN Statistical Functions
200:
- Addition of the GCD, LCM, MROUND and SUBTOTAL Mathematical Functions
201:
- Addition of the LOWER, PROPER and UPPER Text Functions
202:
- Addition of the BETADIST and BETAINV Statistical Functions
203:
- Addition of the CHIINV and GAMMAINV Statistical Functions
204:
- Addition of the SERIESSUM Mathematical Function
205:
- Addition of the CHAR, CODE, FIND, LEN, REPT, SEARCH, T, TRIM Text Functions
206:
- Addition of the FALSE and TRUE Boolean Functions
207:
- Addition of the TDIST and TINV Statistical Functions
208:
- Addition of the EDATE, EOMONTH, YEAR, MONTH, TIME, TIMEVALUE, HOUR, MINUTE, SECOND, WEEKDAY, WEEKNUM, NOW, TODAY and Date/Time Function
209:
- Addition of the BESSELI, BESSELJ, BESSELK and BESSELY Engineering Functions
210:
- Addition of the SLN and SYD Financial Functions
211:
- reworked MODE calculation to handle floating point numbers
212:
- Improved error trapping for invalid input values
213:
- Fix to SMALL, LARGE, PERCENTILE and TRIMMEAN to eliminate non-numeric values
214:
- Added CDF to BINOMDIST and POISSON
215:
- Fix to a potential endless loop in CRITBINOM, together with other bugfixes to the algorithm
216:
- Fix to SQRTPI so that it will work with a real value parameter rather than just integers
217:
- Trap for passing negative values to FACT
218:
- Improved accuracy of the NORMDIST cumulative function, and of the ERF and ERFC functions
219:
- Replicated Excel data-type and error handling for BIN, DEC, OCT and HEX conversion functions
220:
- Replicated Excel data-type and error handling for AND and OR Boolean functions
221:
- Bugfix to MROUND
222:
- Rework of the DATE, DATEVALUE, DAY, DAYS360 and DATEDIF date/Time functions to use Excel dates rather than straight PHP dates
223:
- Rework of the AND, OR Boolean functions to ignore string values
224:
- Rework of the BIN2DEC, BIN2HEX, BIN2OCT, DEC2BIN, DEC2HEX, DEC2OCT Engineering functions to handle two's complement
225:
- Excel, Gnumeric and OpenOffice Calc compatibility flag for functions
226:
Note, not all functions have yet been written to work with the Gnumeric and OpenOffice Calc compatibility flags
227:
- 1900 or 1904 Calendar flag for date functions
228:
- Reworked ExcelToPHP date method to handle the Excel 1900 leap year
229:
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
230:
- Addition of ExcelToPHPObject date method to return a PHP DateTime object from an Excel date serial value
231:
- PHPToExcel method modified to accept either PHP date serial numbers or PHP DateTime objects
232:
- 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
233:
- Feature: (MB) Work item 4485 - Control characters in Excel 2007
234:
- Feature: (MB) Work item 4796 - BaseDrawing::setWidthAndHeight method request
235:
- Feature: (MB) Work item 4798 - Page Setup -> Print Titles -> Sheet -> 'Rows to repeat at top'
236:
- Feature: (MB) Work item 4433 - Comment functionality
237:
- Bugfix: (MB) Work item 4124 - Undefined variable in PHPExcel_Writer_Serialized
238:
- Bugfix: (MB) Work item 4125 - Notice: Object of class PHPExcel_RichText could not be converted to int
239:
- Bugfix: (MB) Work item 4126 - Excel5Writer: utf8 string not converted to utf16
240:
- Bugfix: (MB) Work item 4180 - PHPExcel_RichText and autosize
241:
- Bugfix: (MB) Work item 4574 - Excel5Writer produces broken xls files after change mentioned in work item 4126
242:
- Bugfix: (MB) Work item 4797 - Small bug in PHPExcel_Reader_Excel2007 function _readStyle
243:
244:
245:
2007/10/23 (v 1.5.0):
246:
- General: (MB) Work item 3265 - Refactor PHPExcel Drawing
247:
- Feature: (CS) Work item 3079 - Update Shared/OLE.php to latest version from PEAR
248:
- Feature: (MB) Work item 3217 - Excel2007 vs Excel2003 compatibility pack
249:
- Feature: (MB) Work item 3234 - Cell protection (lock/unlock)
250:
- Feature: (MB) Work item 3543 - Create clickable links (hyperlinks)
251:
- Feature: (MB) Work item 3241 - Additional page setup parameters
252:
- Feature: (MB) Work item 3300 - Make temporary file path configurable (Excel5)
253:
- Feature: (MB) Work item 3306 - Small addition to applyFromArray for font
254:
- Feature: (MB) Work item 3373 - Better feedback when save of file is not possible
255:
- Bugfix: (MB) Work item 3181 - Text Rotation
256:
- Bugfix: (MB) Work item 3237 - Small bug in Page Orientation
257:
- Bugfix: (MB) Work item 3812 - insertNewColumnBeforeByColumn undefined
258:
- Bugfix: (MB) Work item 3893 - Sheet references not working in formula (Excel5 Writer)
259:
260:
261:
2007/08/23 (v 1.4.5):
262:
- General: (MB) Work item 3003 - Class file endings
263:
- General: (MB) Work item 3081 - Different calculation engine improvements
264:
- General: (MB) Work item 3082 - Different improvements in PHPExcel_Reader_Excel2007
265:
- General: (MB) Work item 3146 - Set XML indentation in PHPExcel_Writer_Excel2007
266:
- Feature: (MB) Work item 3159 - Optionally store temporary Excel2007 writer data in file instead of memory
267:
- Feature: (MB) Work item 3063 - Implement show/hide gridlines
268:
- Feature: (MB) Work item 3064 - Implement option to read only data
269:
- Feature: (MB) Work item 3080 - Optionally disable formula precalculation
270:
- Feature: (MB) Work item 3154 - Explicitly set cell datatype
271:
- Feature: (MBaker) Work item 2346 - Implement more Excel calculation functions
272:
- Addition of MINA, MAXA, COUNTA, AVERAGEA, MEDIAN, MODE, DEVSQ, STDEV, STDEVA, STDEVP, STDEVPA, VAR, VARA, VARP and VARPA Excel Functions
273:
- Fix to SUM, PRODUCT, QUOTIENT, MIN, MAX, COUNT and AVERAGE functions when cell contains a numeric value in a string datatype, bringing it in line with MS Excel behaviour
274:
- Bugfix: (MB) Work item 2881 - File_exists on ZIP fails on some installations
275:
- Bugfix: (MB) Work item 2879 - Argument in textRotation should be -90..90
276:
- Bugfix: (MB) Work item 2883 - Excel2007 reader/writer not implementing OpenXML/SpreadsheetML styles 100% correct
277:
- Bugfix: (MB) Work item 2513 - Active sheet index not read/saved
278:
- Bugfix: (MB) Work item 2935 - Print and print preview of generated XLSX causes Excel2007 to crash
279:
- Bugfix: (MB) Work item 2952 - Error in Calculations - COUNT() function
280:
- Bugfix: (MB) Work item 3002 - HTML and CSV writer not writing last row
281:
- Bugfix: (MB) Work item 3017 - Memory leak in Excel5 writer
282:
- Bugfix: (MB) Work item 3044 - Printing (PHPExcel_Writer_Excel5)
283:
- Bugfix: (MB) Work item 3046 - Problems reading zip://
284:
- Bugfix: (MB) Work item 3047 - Error reading conditional formatting
285:
- Bugfix: (MB) Work item 3067 - Bug in Excel5 writer (storePanes)
286:
- Bugfix: (MB) Work item 3077 - Memory leak in PHPExcel_Style_Color
287:
288:
289:
2007/07/23 (v 1.4.0):
290:
- General: (MB) Work item 2687 - Coding convention / code cleanup
291:
- General: (MB) Work item 2717 - Use set_include_path in tests
292:
- General: (MB) Work item 2812 - Move PHPExcel_Writer_Excel5 OLE to PHPExcel_Shared_OLE
293:
- Feature: (MB) Work item 2679 - Hide/Unhide Column or Row
294:
- Feature: (MB) Work item 2271 - Implement multi-cell styling
295:
- Feature: (MB) Work item 2720 - Implement CSV file format (reader/writer)
296:
- Feature: (MB) Work item 2845 - Implement HTML file format
297:
- Bugfix: (MB) Work item 2513 - Active sheet index not read/saved
298:
- Bugfix: (MB) Work item 2678 - Freeze Panes with PHPExcel_Writer_Excel5
299:
- Bugfix: (MB) Work item 2680 - OLE.php
300:
- Bugfix: (MB) Work item 2736 - Copy and pasting multiple drop-down list cells breaks reader
301:
- Bugfix: (MB) Work item 2775 - Function setAutoFilterByColumnAndRow takes wrong arguments
302:
- Bugfix: (MB) Work item 2858 - Simplexml_load_file fails on ZipArchive
303:
304:
305:
2007/06/27 (v 1.3.5):
306:
- General: (MB) Work item 15 - Documentation
307:
- Feature: (JV) PHPExcel_Writer_Excel5
308:
- Feature: (JV) PHPExcel_Reader_Excel2007: Image shadows
309:
- Feature: (MB) Work item 2385 - Data validation
310:
- Feature: (MB) Work item 187 - Implement richtext strings
311:
- Bugfix: (MB) Work item 2443 - Empty relations when adding image to any sheet but the first one
312:
- Bugfix: (MB) Work item 2536 - Excel2007 crashes on print preview
313:
314:
315:
2007/06/05 (v 1.3.0):
316:
- General: (MB) Work item 1942 - Create PEAR package
317:
- General: (MB) Work item 2331 - Replace *->duplicate() by __clone()
318:
- Feature: (JV) PHPExcel_Reader_Excel2007: Column auto-size, Protection, Merged cells, Wrap text, Page breaks, Auto filter, Images
319:
- Feature: (MB) Work item 245 - Implement "freezing" panes
320:
- Feature: (MB) Work item 2273 - Cell addressing alternative
321:
- Feature: (MB) Work item 2270 - Implement cell word-wrap attribute
322:
- Feature: (MB) Work item 2282 - Auto-size column
323:
- Feature: (MB) Work item 241 - Implement formula calculation
324:
- Feature: (MB) Work item 2375 - Insert/remove row/column
325:
- Bugfix: (MB) Work item 1931 - PHPExcel_Worksheet::getCell() should not accept absolute coordinates
326:
- Bugfix: (MB) Work item 2272 - Cell reference without row number
327:
- Bugfix: (MB) Work item 2276 - Styles with same coordinate but different worksheet
328:
- Bugfix: (MB) Work item 2290 - PHPExcel_Worksheet->getCellCollection() usort error
329:
- Bugfix: (SS) Work item 2353 - Bug in PHPExcel_Cell::stringFromColumnIndex
330:
- Bugfix: (JV) Work item 2353 - Reader: numFmts can be missing, use cellStyleXfs instead of cellXfs in styles
331:
332:
333:
2007/04/26 (v 1.2.0):
334:
- General: (MB) Stringtable attribute "count" not necessary, provides wrong info to Excel sometimes...
335:
- General: (MB) Updated tests to address more document properties
336:
- General: (MB) Some refactoring in PHPExcel_Writer_Excel2007_Workbook
337:
- General: (MB) New package: PHPExcel_Shared
338:
- General: (MB) Password hashing algorithm implemented in PHPExcel_Shared_PasswordHasher
339:
- General: (MB) Moved pixel conversion functions to PHPExcel_Shared_Drawing
340:
- General: (MB) Work item 244 - Switch over to LGPL license
341:
- General: (MB) Work item 5 - Include PHPExcel version in file headers
342:
- Feature: (MB) Work item 6 - Autofilter
343:
- Feature: (MB) Work item 7 - Extra document property: keywords
344:
- Feature: (MB) Work item 8 - Extra document property: category
345:
- Feature: (MB) Work item 9 - Document security
346:
- Feature: (MB) Work item 10 - PHPExcel_Writer_Serialized and PHPExcel_Reader_Serialized
347:
- Feature: (MB) Work item 11 - Alternative syntax: Addressing a cell
348:
- Feature: (MB) Work item 12 - Merge cells
349:
- Feature: (MB) Work item 13 - Protect ranges of cells with a password
350:
- Bugfix: (JV) Work item 14 - (style/fill/patternFill/fgColor or bgColor can be empty)
351:
352:
353:
2007/03/26 (v 1.1.1):
354:
- Bugfix: (MB) Work item 1250 - Syntax error in "Classes/PHPExcel/Writer/Excel2007.php" on line 243
355:
- General: (MB) Work item 1282 - Reader should check if file exists and throws an exception when it doesn't
356:
357:
358:
2007/03/22 (v 1.1.0):
359:
- Changed filenames of tests
360:
- Bugfix: (MB) Work item 836 - Style information lost after passing trough Excel2007_Reader
361:
- Bugfix: (MB) Work item 913 - Number of columns > AZ fails fixed in PHPExcel_Cell::columnIndexFromString
362:
- General: (MB) Added a brief file with installation instructions
363:
- Feature: (MB) Page breaks (horizontal and vertical)
364:
- Feature: (MB) Image shadows
365:
366:
367:
368:
2007/02/22 (v 1.0.0):
369:
- Changelog now includes developer initials
370:
- Bugfix: (JV) PHPExcel->removeSheetByIndex now re-orders sheets after deletion, so no array indexes are lost
371:
- Bugfix: (JV) PHPExcel_Writer_Excel2007_Worksheet::_writeCols() used direct assignment to $pSheet->getColumnDimension('A')->Width instead of $pSheet->getColumnDimension('A')->setWidth()
372:
- Bugfix: (JV) DocumentProperties used $this->LastModifiedBy instead of $this->_lastModifiedBy.
373:
- Bugfix: (JV) Only first = should be removed when writing formula in PHPExcel_Writer_Excel2007_Worksheet.
374:
- General: (JV) Consistency of method names to camelCase
375:
- General: (JV) Updated tests to match consistency changes
376:
- General: (JV) Detection of mime-types now with image_type_to_mime_type()
377:
- General: (JV) Constants now hold string value used in Excel 2007
378:
- General: (MB) Fixed folder name case (WorkSheet -> Worksheet)
379:
- Feature: (MB) PHPExcel classes (not the Writer classes) can be duplicated, using a duplicate() method.
380:
- Feature: (MB) Cell styles can now be duplicated to a range of cells using PHPExcel_Worksheet->duplicateStyle()
381:
- Feature: (MB) Conditional formatting
382:
- Feature: (JV) Reader for Excel 2007 (not supporting full specification yet!)
383:
384:
385:
386:
2007/01/31 (v 1.0.0 RC):
387:
- Project name has been changed to PHPExcel
388:
- Project homepage is now http://www.codeplex.com/PHPExcel
389:
- Started versioning at number: PHPExcel 1.0.0 RC
390:
391:
392:
393:
2007/01/22:
394:
- Fixed some performance issues on large-scale worksheets (mainly loops vs. indexed arrays)
395:
- Performance on creating StringTable has been increased
396:
- Performance on writing Excel2007 worksheet has been increased
397:
398:
399:
400:
2007/01/18:
401:
- Images can now be rotated
402:
- Fixed bug: When drawings have full path specified, no mime type can be deducted
403:
- Fixed bug: Only one drawing can be added to a worksheet
404:
405:
406:
407:
2007/01/12:
408:
- Refactoring of some classes to use ArrayObject instead of array()
409:
- Cell style now has support for number format (i.e. #,##0)
410:
- Implemented embedding images
411:
412:
413:
414:
2007/01/02:
415:
- Cell style now has support for fills, including gradient fills
416:
- Cell style now has support for fonts
417:
- Cell style now has support for border colors
418:
- Cell style now has support for font colors
419:
- Cell style now has support for alignment
420:
421:
422:
423:
2006/12/21:
424:
- Support for cell style borders
425:
- Support for cell styles
426:
- Refactoring of Excel2007 Writer into multiple classes in package SpreadSheet_Writer_Excel2007
427:
- Refactoring of all classes, changed public members to public properties using getter/setter
428:
- Worksheet names are now unique. On duplicate worksheet names, a number is appended.
429:
- Worksheet now has parent SpreadSheet object
430:
- Worksheet now has support for page header and footer
431:
- Worksheet now has support for page margins
432:
- Worksheet now has support for page setup (only Paper size and Orientation)
433:
- Worksheet properties now accessible by using getProperties()
434:
- Worksheet now has support for row and column dimensions (height / width)
435:
- Exceptions thrown have a more clear description
436:
437:
438:
439:
Initial version:
440:
- Create a Spreadsheet object
441:
- Add one or more Worksheet objects
442:
- Add cells to Worksheet objects
443:
- Export Spreadsheet object to Excel 2007 OpenXML format
444:
- Each cell supports the following data formats: string, number, formula, boolean.