Commit Graph

  • 6ea0ff9bfd Performance tweaks Mark Baker 2011-12-30 01:08:05 +0000
  • 86db0b8535 General: 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
  • 24bd9b5e8a Feature: 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
  • b235c531a7 Experimental - 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
  • 0924d0a4ca Bugfix: (fauvel) Work item 16958 - Cell::getFormattedValue returns RichText object instead of string Mark Baker 2011-12-14 23:00:45 +0000
  • 7fce476f0c General: (atz) Work item 17024 - Unknown codepage: 10007 Additional Mac codepages Mark Baker 2011-12-14 22:48:09 +0000
  • 5cf4740204 Fix to cache factory getInstance() if initialize() has been called explicitly by a user call Mark Baker 2011-12-09 14:55:47 +0000
  • fc62320de8 modify 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
  • cd7f0a1c51 Added 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
  • 93e8a05780 Feature - initial version of Igbinary (serialized) cell caching Mark Baker 2011-12-05 23:42:39 +0000
  • 86d2a5291f Feature - initial version of Igbinary (serialized) cell caching Mark Baker 2011-12-05 23:41:49 +0000
  • 5fb3ffceb0 Performance 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
  • c345c0e8ca Exception handling for SQLite3 cell caching Mark Baker 2011-12-03 20:16:57 +0000
  • 91f74c5893 Exception handling for SQLite cell caching Mark Baker 2011-12-03 18:49:27 +0000
  • bde593557d Minor performance optimisation: use $x+=3 instead of $x=$x+3 Mark Baker 2011-12-03 10:02:24 +0000
  • 11c87c19ad Feature - initial version of SQLite cell caching Mark Baker 2011-12-03 00:32:01 +0000
  • 07e56b5a60 Feature - initial version of SQLite cell caching Mark Baker 2011-12-03 00:24:44 +0000
  • ee028c165d General: Work item 16028 - Fix for projects that still use old autoloaders Mark Baker 2011-12-02 14:16:23 +0000
  • 969c409ba1 Bugfix: Work item 16266 - PHPExcel_Style::applyFromArray() returns null rather than style object in advanced mode Mark Baker 2011-12-02 13:59:57 +0000
  • 207f6f5818 General: Work item 16359 - [Patch] faster stringFromColumnIndex() Mark Baker 2011-12-02 13:40:40 +0000
  • bbc73039e6 General: Ensure use of system temp directory for all temporary work files, unless explicitly specified Mark Baker 2011-11-28 14:44:28 +0000
  • a083de817e Use PHPExcel_Shared_File::sys_get_temp_dir() for temporary files directory where not explicitly specified Mark Baker 2011-11-28 14:41:17 +0000
  • 135c0185f5 Use PHPExcel_Shared_File::sys_get_temp_dir() for temporary zip file directory rather than ./ Mark Baker 2011-11-28 14:13:08 +0000
  • 87c735a212 Bugfix: Work item 16956 - External links in Excel2010 files cause Fatal error Mark Baker 2011-11-25 15:45:34 +0000
  • 68a0930f67 Bugfix: Work item 16960 - Previous calculation engine error conditions trigger cyclic reference errors Mark Baker 2011-11-25 14:37:47 +0000
  • 6e7b84ef97 Bugfix: Work item 16956 - External links in Excel2010 files cause Fatal error Mark Baker 2011-11-25 14:30:02 +0000
  • f2076cde3f Bugfix: Work item 16956 - External links in Excel2010 files cause Fatal error Mark Baker 2011-11-25 13:34:08 +0000
  • cdbeceba47 Bugfix: 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
  • 77cd4ac9aa Bugfix: 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
  • efc066c233 Bugfix: Work item 16212 - $arguments improperly used in CachedObjectStorage/PHPTemp.php Mark Baker 2011-10-25 19:31:57 +0000
  • d68efe81d7 Fixed a reference error Maarten Balliauw 2011-10-25 06:02:36 +0000
  • f2310e05d0 Bugfix: 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
  • bb34668146 Modify 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
  • 94e3dc3fd2 Improved speed and memory usage in Excel5 Writer Mark Baker 2011-06-01 23:09:12 +0000
  • 3cbbcd87d5 Update to phpdoc comments Mark Baker 2011-05-30 22:26:55 +0000
  • cdb94cfb1e Minor performance tweak Mark Baker 2011-05-30 22:25:04 +0000
  • c7539c3d4c Performance improvements to Excel5 Writer Mark Baker 2011-05-30 22:22:49 +0000
  • f041495fb8 Call dataTypeForValue() method in self rather than PHPExcel_Cell_Datatype Mark Baker 2011-05-30 22:20:13 +0000
  • dd7674a36a Fixed charset code for CHARSET_ANSI_THAI Mark Baker 2011-05-30 22:16:45 +0000
  • c792f053b5 Performance 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
  • 48b2fb8e99 Bugfix: Locale-specific fix to text functions when passing a boolean argument instead of a string Mark Baker 2011-05-15 22:58:20 +0000
  • 85ff71fd18 General: Improved memory usage in CSV Writer Mark Baker 2011-05-11 22:36:47 +0000
  • adacb26028 Additional PHPDocumentor tagging Mark Baker 2011-04-29 14:23:57 +0000
  • dd7b0610e9 Bugfix: Work item 15762 - INDIRECT() function doesn't work with named ranges Mark Baker 2011-04-29 13:44:27 +0000
  • 5979a4ec13 Bugfix: 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
  • 5672f25ebf General: 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
  • ff4daef39c General: Fix to build to ensure that Examples are included with the documentation Mark Baker 2011-04-23 21:12:20 +0000
  • c7f99d0d98 Bugfix: Work item 15707 - ini_set() call in Calculation class destructor Mark Baker 2011-04-19 21:40:35 +0000
  • 631834b4d6 Minor performance improvement to date conversion routines Mark Baker 2011-04-09 18:16:08 +0000
  • 70f773f0ca Bugfix: 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
  • 2d362092ba Added document properties to HTML output as meta tags Mark Baker 2011-03-23 16:34:31 +0000
  • a0ac293ec6 Bugfix: Work item 15537 - Excel2007 Reader canRead function bug Mark Baker 2011-03-17 11:29:14 +0000
  • 9704feec19 Bugfix: 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
  • 34c4aa18ee Additional work on the Excel2003XML Reader Mark Baker 2011-03-04 14:39:00 +0000
  • f08f16c8ca General: Work item 15461 - Locale file paths not fit for windows Mark Baker 2011-03-04 14:22:08 +0000
  • 09df4fd647 Bugfix: Work item 15459 - Invalid cell coordinate in Autofilter for Excel2007 Writer Mark Baker 2011-03-03 23:01:31 +0000
  • cfaa5209f7 General: Work item 15405 - Two easy to fix Issues concerning PHPExcel_Token_Stack (l10n/UC) Mark Baker 2011-02-28 00:32:55 +0000
  • fb9a1e2ca8 Preparing 1.7.6 Maarten Balliauw 2011-02-28 00:16:46 +0000
  • aedff36d4e Bugfix: Work item 15409 - Full column/row references in named ranges not supported by updateCellReference() Mark Baker 2011-02-27 22:33:42 +0000
  • 51b3f847fb Documented link about using PHPExcel with Typo3 Mark Baker 2011-02-26 22:56:12 +0000
  • 23c288efad Remove Serialize test from runall.php Mark Baker 2011-02-26 21:51:40 +0000
  • 45fb4d84c1 Bugfix: 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
  • 901d20e6f9 Add further description to PHPDoc blocks Mark Baker 2011-02-25 16:52:43 +0000
  • 5b71914eea Minor work on Excel2003XML Reader (not yet complete) Mark Baker 2011-02-23 01:05:05 +0000
  • bba779bfc3 Not 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
  • 57f3b411d1 Set documentation language to English (UK) Mark Baker 2011-02-22 17:35:34 +0000
  • f27b3d7815 Fix 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
  • a07dd58fc7 Added 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
  • 46e1c4eaff General: Removed Serialized Reader/Writer as these no longer work. Mark Baker 2011-02-22 10:21:38 +0000
  • a8517724dc Bugfix: 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
  • 2dcead065d Fixed bug in translation functions of the calculation engine Mark Baker 2011-02-18 17:39:58 +0000
  • 4b0852428d Updated FAQ section Mark Baker 2011-02-17 13:02:21 +0000
  • ab2825c752 Feature: Work Item 2346 - Implement more Excel calculation functions Implemented the DGET() Database function Mark Baker 2011-02-13 17:20:07 +0000
  • 7425aa8460 Feature: Work Item 2346 - Implement more Excel calculation functions Implemented the DGET() Database function Mark Baker 2011-02-13 17:19:00 +0000
  • c5c816a9c6 Feature: 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
  • 7bb65068cd Oops... missing semi-colon (now fixed) Mark Baker 2011-02-11 23:12:39 +0000
  • 8a00ef61e8 Added debug log echo option to Calculation Engine (for PHPExcel development team debugging use only) Mark Baker 2011-02-11 22:45:17 +0000
  • 5a7e7bb93f Bugfix: 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
  • eb5dadcd4c Bugfix: Work item 15312 - Caching and tmp partition exhaustion Mark Baker 2011-02-11 22:26:51 +0000
  • 9b40f3edf5 Fixed phing build to include Documentation/Examples Mark Baker 2011-02-10 16:30:33 +0000
  • 0fd77aa397 Minor performance tweaks when working with alternating blocks in a string Mark Baker 2011-02-10 12:39:34 +0000
  • 8218d04b0f Bugfix: 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
  • 4a33c85f26 Work Item 15198 - FreezePane causing damaged or modified error Mark Baker 2011-02-08 13:14:30 +0000
  • 8a83e847cd Bugfix: 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
  • 919df79991 Bugfix: 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
  • 3757a0e6ff Remove debug code reference to hexdump() Mark Baker 2011-01-31 22:01:08 +0000
  • 8c0663486b Feature: Improved toFormattedString() handling for Currency and Accounting format masks to render currency symbols Mark Baker 2011-01-31 17:18:10 +0000
  • 1bf40dadf9 Bugfix: 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
  • 956cc7a2cf Bugfix: 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
  • 5e27d037bc Bugfix: Work item 14980 - Images not getting copyied with the ->clone function Mark Baker 2011-01-28 23:09:02 +0000
  • c1fe7016ab Feature: Added support for superscript/subscript in HTML/PDF Writers Mark Baker 2011-01-28 16:02:33 +0000
  • c6d58661e1 Feature: 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
  • 545c2a0f19 Bugfix: Work item 15172 - rangeToarray function modified for non-existent cells Mark Baker 2011-01-27 16:09:37 +0000
  • a7d2134271 Fix 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
  • 59e85a379d Added 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
  • 585ee1514e Feature: Added initial support for cell comments in the Excel5 Reader for BIFF8 Mark Baker 2011-01-25 09:46:30 +0000
  • db2fb8158a Feature: Added initial support for cell comments in the Excel5 Reader for BIFF8 Mark Baker 2011-01-24 12:26:06 +0000
  • 5404406884 Feature: 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
  • 2368c7fbd0 Feature: 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
  • 9cc2f8d50b Feature: Added basic support for cell comments in the OOCalc Reader Mark Baker 2011-01-21 14:36:28 +0000