6ea0ff9bfdPerformance tweaks
Mark Baker
2011-12-30 01:08:05 +0000
86db0b8535General: Change iterators to implement Iterator rather than extend CachingIterator, as a fix for PHP 5.4. changes in SPL
Mark Baker
2011-12-30 00:04:06 +0000
24bd9b5e8aFeature: Additional row iterator options: allow a start row to be defined in the constructor; seek(), and prev() methods added.
Mark Baker
2011-12-29 22:59:24 +0000
b235c531a7Experimental - Added getHighestDataColumn(), getHighestDataRow(), getHighestRowAndColumn() and calculateWorksheetDataDimension() methods for the worksheet that return the highest row and column that have cell records
Mark Baker
2011-12-16 16:01:21 +0000
0924d0a4caBugfix: (fauvel) Work item 16958 - Cell::getFormattedValue returns RichText object instead of string
Mark Baker
2011-12-14 23:00:45 +0000
7fce476f0cGeneral: (atz) Work item 17024 - Unknown codepage: 10007 Additional Mac codepages
Mark Baker
2011-12-14 22:48:09 +0000
5cf4740204Fix to cache factory getInstance() if initialize() has been called explicitly by a user call
Mark Baker
2011-12-09 14:55:47 +0000
fc62320de8modify cell cache getInstance() method to validate response from initialize() if it hasn't been called explicitly by a user call
Mark Baker
2011-12-09 12:19:54 +0000
cd7f0a1c51Added a cacheMethodIsAvailable() method to all cell cache classes, making it easier to identify if all the necessary classes/functions are available for each caching option. Renamed the factory getCacheStorageMethods() method to getAllCacheStorageMethods(), returning all cache options in the library. Wrote a new factory getCacheStorageMethods() method to return an array of those cache methods that are available with the current build of PHP (extensions tested, etc). Refactored factory initialize() method to use the cacheMethodIsAvailable(), so factoring the logic for testing methods out of the factory.
Mark Baker
2011-12-09 12:10:46 +0000
93e8a05780Feature - initial version of Igbinary (serialized) cell caching
Mark Baker
2011-12-05 23:42:39 +0000
86d2a5291fFeature - initial version of Igbinary (serialized) cell caching
Mark Baker
2011-12-05 23:41:49 +0000
5fb3ffceb0Performance improvement for readers that reduces overheads when setting titles in multi-worksheet workbooks, by avoiding re-iterating through all worksheet/cells whenever a sheet title is set
Mark Baker
2011-12-04 11:24:59 +0000
c345c0e8caException handling for SQLite3 cell caching
Mark Baker
2011-12-03 20:16:57 +0000
91f74c5893Exception handling for SQLite cell caching
Mark Baker
2011-12-03 18:49:27 +0000
bde593557dMinor performance optimisation: use $x+=3 instead of $x=$x+3
Mark Baker
2011-12-03 10:02:24 +0000
11c87c19adFeature - initial version of SQLite cell caching
Mark Baker
2011-12-03 00:32:01 +0000
07e56b5a60Feature - initial version of SQLite cell caching
Mark Baker
2011-12-03 00:24:44 +0000
ee028c165dGeneral: Work item 16028 - Fix for projects that still use old autoloaders
Mark Baker
2011-12-02 14:16:23 +0000
969c409ba1Bugfix: Work item 16266 - PHPExcel_Style::applyFromArray() returns null rather than style object in advanced mode
Mark Baker
2011-12-02 13:59:57 +0000
207f6f5818General: Work item 16359 - [Patch] faster stringFromColumnIndex()
Mark Baker
2011-12-02 13:40:40 +0000
bbc73039e6General: Ensure use of system temp directory for all temporary work files, unless explicitly specified
Mark Baker
2011-11-28 14:44:28 +0000
a083de817eUse PHPExcel_Shared_File::sys_get_temp_dir() for temporary files directory where not explicitly specified
Mark Baker
2011-11-28 14:41:17 +0000
135c0185f5Use PHPExcel_Shared_File::sys_get_temp_dir() for temporary zip file directory rather than ./
Mark Baker
2011-11-28 14:13:08 +0000
87c735a212Bugfix: Work item 16956 - External links in Excel2010 files cause Fatal error
Mark Baker
2011-11-25 15:45:34 +0000
68a0930f67Bugfix: Work item 16960 - Previous calculation engine error conditions trigger cyclic reference errors
Mark Baker
2011-11-25 14:37:47 +0000
6e7b84ef97Bugfix: Work item 16956 - External links in Excel2010 files cause Fatal error
Mark Baker
2011-11-25 14:30:02 +0000
f2076cde3fBugfix: Work item 16956 - External links in Excel2010 files cause Fatal error
Mark Baker
2011-11-25 13:34:08 +0000
cdbeceba47Bugfix: Work item 16895 - PHP Invalid index notice on writing excel file when active sheet has been deleted General: Work item 16923 - Datatype.php & constant TYPE_NULL
Mark Baker
2011-11-25 12:16:01 +0000
77cd4ac9aaBugfix: Work item 16643 - Bug In Cache System (cell reference when throwing caching errors) General: Work item 16643 - Add file directory as a cache option for cache_to_discISAM
Mark Baker
2011-10-26 16:16:43 +0000
efc066c233Bugfix: Work item 16212 - $arguments improperly used in CachedObjectStorage/PHPTemp.php
Mark Baker
2011-10-25 19:31:57 +0000
d68efe81d7Fixed a reference error
Maarten Balliauw
2011-10-25 06:02:36 +0000
f2310e05d0Bugfix: Work item 16246 - reader/CSV fails on this file auto_detect_line_endings now set in CSV reader
Mark Baker
2011-08-05 14:37:30 +0000
bb34668146Modify underlying PHP_OLE to support multiple streams This is preparatory to providing support for workbook properties (and extended properties) in the Excel5 Writer, because properties are stored in the SummaryInformation and DocumentSummaryInformation streams, and not in the workbook stream. Previously, PHP_OLE could only save a single stream, so this had to be the workbook stream; so document property information was discarded by the Excel5 Writer.
Mark Baker
2011-08-05 14:04:07 +0000
94e3dc3fd2Improved speed and memory usage in Excel5 Writer
Mark Baker
2011-06-01 23:09:12 +0000
3cbbcd87d5Update to phpdoc comments
Mark Baker
2011-05-30 22:26:55 +0000
cdb94cfb1eMinor performance tweak
Mark Baker
2011-05-30 22:25:04 +0000
c7539c3d4cPerformance improvements to Excel5 Writer
Mark Baker
2011-05-30 22:22:49 +0000
f041495fb8Call dataTypeForValue() method in self rather than PHPExcel_Cell_Datatype
Mark Baker
2011-05-30 22:20:13 +0000
dd7674a36aFixed charset code for CHARSET_ANSI_THAI
Mark Baker
2011-05-30 22:16:45 +0000
c792f053b5Performance improvements by removing tests against BIFF version... especially as we only save as BIFF8 now, BIFF5 having been discarded some releases ago
Mark Baker
2011-05-26 20:17:48 +0000
48b2fb8e99Bugfix: Locale-specific fix to text functions when passing a boolean argument instead of a string
Mark Baker
2011-05-15 22:58:20 +0000
85ff71fd18General: Improved memory usage in CSV Writer
Mark Baker
2011-05-11 22:36:47 +0000
adacb26028Additional PHPDocumentor tagging
Mark Baker
2011-04-29 14:23:57 +0000
dd7b0610e9Bugfix: Work item 15762 - INDIRECT() function doesn't work with named ranges
Mark Baker
2011-04-29 13:44:27 +0000
5979a4ec13Bugfix: Work item 15786 - RangeToArray strange array keys and Minor performance tweak to the workbook setActiveSheetIndexByName() method
Mark Baker
2011-04-28 20:42:50 +0000
5672f25ebfGeneral: Reduce cell caching overhead using dirty flag to ensure that cells are only rewritten to the cache if they have actually been changed
Mark Baker
2011-04-25 14:25:53 +0000
ff4daef39cGeneral: Fix to build to ensure that Examples are included with the documentation
Mark Baker
2011-04-23 21:12:20 +0000
c7f99d0d98Bugfix: Work item 15707 - ini_set() call in Calculation class destructor
Mark Baker
2011-04-19 21:40:35 +0000
631834b4d6Minor performance improvement to date conversion routines
Mark Baker
2011-04-09 18:16:08 +0000
70f773f0caBugfix: 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
Mark Baker
2011-04-05 21:57:59 +0000
2d362092baAdded document properties to HTML output as meta tags
Mark Baker
2011-03-23 16:34:31 +0000
a0ac293ec6Bugfix: Work item 15537 - Excel2007 Reader canRead function bug
Mark Baker
2011-03-17 11:29:14 +0000
9704feec19Bugfix: Work item 15518 - PCLZip library issue References to ZipArchive Constants when ZipArchive class isn't available
Mark Baker
2011-03-14 13:52:49 +0000
34c4aa18eeAdditional work on the Excel2003XML Reader
Mark Baker
2011-03-04 14:39:00 +0000
f08f16c8caGeneral: Work item 15461 - Locale file paths not fit for windows
Mark Baker
2011-03-04 14:22:08 +0000
09df4fd647Bugfix: Work item 15459 - Invalid cell coordinate in Autofilter for Excel2007 Writer
Mark Baker
2011-03-03 23:01:31 +0000
cfaa5209f7General: Work item 15405 - Two easy to fix Issues concerning PHPExcel_Token_Stack (l10n/UC)
Mark Baker
2011-02-28 00:32:55 +0000
aedff36d4eBugfix: Work item 15409 - Full column/row references in named ranges not supported by updateCellReference()
Mark Baker
2011-02-27 22:33:42 +0000
51b3f847fbDocumented link about using PHPExcel with Typo3
Mark Baker
2011-02-26 22:56:12 +0000
23c288efadRemove Serialize test from runall.php
Mark Baker
2011-02-26 21:51:40 +0000
45fb4d84c1Bugfix: Work item 15421 - PHPExcel_ReferenceHelper::insertNewBefore() is missing an 'Update worksheet: comments' section Solution, courtesy of MKunert
Mark Baker
2011-02-25 22:57:22 +0000
901d20e6f9Add further description to PHPDoc blocks
Mark Baker
2011-02-25 16:52:43 +0000
5b71914eeaMinor work on Excel2003XML Reader (not yet complete)
Mark Baker
2011-02-23 01:05:05 +0000
bba779bfc3Not sure why array_item() was being called with a $key of true, but it was resulting in a "method call on a non-object" error with gradient fills.
Mark Baker
2011-02-22 23:01:44 +0000
57f3b411d1Set documentation language to English (UK)
Mark Baker
2011-02-22 17:35:34 +0000
f27b3d7815Fix to prevent non-comment objects from throwing errors when retrieving the set of comment objects from the XML
Mark Baker
2011-02-22 14:02:27 +0000
a07dd58fc7Added listAllFunctionNames() method to the Calculation Engine, and modified the listFunctionNames() method to return only implemented functions
Mark Baker
2011-02-22 13:57:15 +0000
46e1c4eaffGeneral: Removed Serialized Reader/Writer as these no longer work.
Mark Baker
2011-02-22 10:21:38 +0000
a8517724dcBugfix: Work item 15379 - Named ranges with dot don't get parsed properly Bugfix: Work item 15096 - insertNewRowBefore fails to consistently update references Bugfix: "i" is not a valid character for Excel date format masks (in isDateTimeFormatCode() method)
Mark Baker
2011-02-21 12:21:20 +0000
2dcead065dFixed bug in translation functions of the calculation engine
Mark Baker
2011-02-18 17:39:58 +0000
4b0852428dUpdated FAQ section
Mark Baker
2011-02-17 13:02:21 +0000
ab2825c752Feature: Work Item 2346 - Implement more Excel calculation functions Implemented the DGET() Database function
Mark Baker
2011-02-13 17:20:07 +0000
7425aa8460Feature: Work Item 2346 - Implement more Excel calculation functions Implemented the DGET() Database function
Mark Baker
2011-02-13 17:19:00 +0000
c5c816a9c6Feature: Work Item 2346 - Implement more Excel calculation functions Implemented the DAVERAGE(), DCOUNT(), DCOUNTA(), DMAX(), DMIN(), DPRODUCT(), DSTDEV(), DSTDEVP(), DSUM(), DVAR() and DVARP() Database functions
Mark Baker
2011-02-13 17:08:00 +0000
7bb65068cdOops... missing semi-colon (now fixed)
Mark Baker
2011-02-11 23:12:39 +0000
8a00ef61e8Added debug log echo option to Calculation Engine (for PHPExcel development team debugging use only)
Mark Baker
2011-02-11 22:45:17 +0000
5a7e7bb93fBugfix: Work item 15308 - Writing to Variable No Longer Works. $_tmp_dir Missing in PHPExcel\PHPExcel\Shared\OLE\PPS\Root.php
Mark Baker
2011-02-11 22:44:05 +0000
eb5dadcd4cBugfix: Work item 15312 - Caching and tmp partition exhaustion
Mark Baker
2011-02-11 22:26:51 +0000
9b40f3edf5Fixed phing build to include Documentation/Examples
Mark Baker
2011-02-10 16:30:33 +0000
0fd77aa397Minor performance tweaks when working with alternating blocks in a string
Mark Baker
2011-02-10 12:39:34 +0000
8218d04b0fBugfix: Reduced false positives from isDateTimeFormatCode() method by suppressing testing within quoted strings (thanks to John Machin, author of xlrd, and the maintainer of xlwt for reading/writing Excel files in Python)
Mark Baker
2011-02-10 12:26:50 +0000
4a33c85f26Work Item 15198 - FreezePane causing damaged or modified error
Mark Baker
2011-02-08 13:14:30 +0000
8a83e847cdBugfix: Work item 15121 - Column reference rather than cell reference in Print Area definition Fixed Excel2007 Writer to handle print areas that are defined as row or column ranges rather than just as cell ranges... added a static absoluteReference() method to PHPExcel_Cell that will return an absolute row, column or cell reference, and modified the _writeDefinedNameForPrintArea() method of the Excel2007 Workbook Writer to call that rather than absoluteCoordinate()
Mark Baker
2011-02-08 12:55:45 +0000
919df79991Bugfix: The freezePaneByColumnAndRow() method row argument should default to 1 rather than 0. Default row argument for all __ByColumnAndRow() methods should be 1 General: Enhanced SheetViews element structures in the Excel2007 Writer for frozen panes.
Mark Baker
2011-02-07 11:19:07 +0000
3757a0e6ffRemove debug code reference to hexdump()
Mark Baker
2011-01-31 22:01:08 +0000
8c0663486bFeature: Improved toFormattedString() handling for Currency and Accounting format masks to render currency symbols
Mark Baker
2011-01-31 17:18:10 +0000
1bf40dadf9Bugfix: Fix Excel5 Writer so that it only writes column dimensions for columns that are actually used rather than the full range (A to IV)
Mark Baker
2011-01-30 23:22:12 +0000
956cc7a2cfBugfix: Work item 11576 - AdvancedValueBinder.php: String sometimes becomes a date when it shouldn't. Improved with a preg_match trap to reject unlikely formats for dates before passing value to PHPExcel_Shared_Date::stringToExcel() for final validation
Mark Baker
2011-01-29 17:05:02 +0000
5e27d037bcBugfix: Work item 14980 - Images not getting copyied with the ->clone function
Mark Baker
2011-01-28 23:09:02 +0000
c1fe7016abFeature: Added support for superscript/subscript in HTML/PDF Writers
Mark Baker
2011-01-28 16:02:33 +0000
c6d58661e1Feature: Support for cell comments in the Excel5 Reader... fixed some problems with the comments in BIFF8 comments
Mark Baker
2011-01-28 12:56:38 +0000
545c2a0f19Bugfix: Work item 15172 - rangeToarray function modified for non-existent cells
Mark Baker
2011-01-27 16:09:37 +0000
a7d2134271Fix to a problem that I introduced with last night's changes to precision in the calculation engine
Mark Baker
2011-01-26 09:40:40 +0000
59e85a379dAdded flushInstance() method to clear the calculation cache, but only if the calculation engine has been instantiated. Moved precision setting from functions.php to the calculation engine constructor, with a reset when the calculation engine instance is unset... will be of value when I switch the code to support a calculation engine/cache with each instantiated PHPExcel object.
Mark Baker
2011-01-25 23:11:32 +0000
585ee1514eFeature: Added initial support for cell comments in the Excel5 Reader for BIFF8
Mark Baker
2011-01-25 09:46:30 +0000
db2fb8158aFeature: Added initial support for cell comments in the Excel5 Reader for BIFF8
Mark Baker
2011-01-24 12:26:06 +0000
5404406884Feature: Added some support for cell annotations in the Excel5 Reader... now handles annotation blocks beyond the 2,048 character limit for any individual annotation block. (for BIFF5-7 only at present... BIFF8 support is still outstanding)
Mark Baker
2011-01-21 17:58:35 +0000
2368c7fbd0Feature: Added some support for cell annotations in the Excel5 Reader (for BIFF5-7 only at present... BIFF8 support is still outstanding, as annotations were change to a drawing object with this release)
Mark Baker
2011-01-21 16:41:02 +0000
9cc2f8d50bFeature: Added basic support for cell comments in the OOCalc Reader
Mark Baker
2011-01-21 14:36:28 +0000