Subversion Repositories eFlore/Applications.cel

Rev

Rev 2388 | Details | Compare with Previous | Last modification | View Log | RSS feed

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