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
2b4c15b92fFeature: Added support for cell comments in the Gnumeric and Excel2003XML Readers
Mark Baker
2011-01-21 13:11:28 +0000
5a2830c499Bugfix: Work item 15129 - Worksheet fromArray() only working with 2-D arrays
Mark Baker
2011-01-21 10:47:20 +0000
dd4f5252eaAdded BAHTTEXT to reader/writer list of Excel functions, though not supported in the calculation engine yet
Mark Baker
2011-01-14 18:01:41 +0000
d154e853b2Bugfix: Work item 15094 - Merge cells 'un-merge' when using an existing spreadsheet (Excel5 Reader)
Mark Baker
2011-01-13 16:01:29 +0000
9f252c9e80Bugfix: Work item 15089 - PHPExcel_Worksheet->toArray() index problem
Mark Baker
2011-01-12 16:48:54 +0000
1643bb9613Feature: Added new rangeToArray() and namedRangeToArray() methods to the PHPExcel_Worksheet object. Functionally, these are identical to the toArray() method, except that they take an additional first parameter of a Range (e.g. 'B2:C3') or a Named Range name. Modified the toArray() method so that it actually uses rangeToArray().
Mark Baker
2011-01-12 15:20:29 +0000
56d7506cf5Bugfix: Minor patchfix for Excel2003XML Reader when XML is defined with a charset attribute
Mark Baker
2011-01-10 17:51:55 +0000
1ec263ee94General: Improved performance (speed), for building the Shared Strings table in the Excel2007 Writer.
Mark Baker
2011-01-07 14:52:28 +0000
1c6fa7b5abBugfix: Work item 15046 - 1.7.5 fails cell->getCalculatedValue()
Mark Baker
2011-01-05 17:53:17 +0000
74f299e5e5Bugfix: Work item 14999 - PHPExcel Excel2007 Reader colour problems with solidfill Bugfix: Work item 13215 - Formatting get lost and edit a template XLSX file Bugfix: Work item 14029 - Excel 2007 Reader /writer lost fontcolor Bugfix: Work item 13374 - file that makes cells go black
Mark Baker
2011-01-04 23:14:59 +0000
59b831c4f1Speed boost and memory reduction in the Worksheet toArray() method.
Mark Baker
2011-01-04 13:52:05 +0000
b321f33fedBugfix: Work item 15029 - coordinateFromString throws exception for rows greater than 99,999
Mark Baker
2011-01-03 22:39:51 +0000
fd95065240Work item 11583 - Need method for removing autoFilter
Maarten Balliauw
2011-01-03 10:26:43 +0000
ccbb28167bUpdated headers to reflect the new year. Happy new year 2011!
Maarten Balliauw
2011-01-03 09:20:10 +0000
1911d4a48fUpdated user documentation with information about and example of retrieving the list of worksheet names using the listWorksheetNames() method
Mark Baker
2010-12-29 00:57:01 +0000
6da04eb1d2Performance improvements to the Excel2003XML Reader
Mark Baker
2010-12-28 22:38:20 +0000
c644f9816cFeature: Work item 14979 - Added listWorksheetNames() method to Excel2003XML Reader, and fixed a namespace bug
Mark Baker
2010-12-28 21:37:11 +0000
14cc952323Feature: Work item 14979 - Added listWorksheetNames() method to OOCalc and Gnumeric Readers
Mark Baker
2010-12-28 19:34:21 +0000
e3a01db2a9Feature: Work item 14979 - Added listWorksheetNames() method to Excel2007 and Excel5 Readers, allowing a user to extract a list of worksheet names from a file without parsing/loading the whole file.
Mark Baker
2010-12-28 18:46:23 +0000