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
457f826fa6Bugfix: Work item 14973 - PHPExcel_Cell::isInRange() incorrect results - offset by one column
Mark Baker
2010-12-27 22:43:11 +0000
d027a3d0a7Bugfix: Calc engine needs to use Ungreedy regexp in parser
Mark Baker
2010-12-24 12:08:31 +0000
7a792cd566Bugfix: Work item 14898 - PHP Warning: preg_match(): Compilation failed: PCRE does not support \\L, \\l, \\N, \\P, \\p, \\U, \\u, or \\X Bugfix: Work item 14901 - VLOOKUP choking on parameters in PHPExcel.1.7.5/PHPExcel_Writer_Excel2007
Mark Baker
2010-12-23 21:18:23 +0000
f71aeebd30Minor performance/memory tweaks to the Excel2007 Writer
Mark Baker
2010-12-15 17:19:30 +0000
ad3d9dc853Bugfix: Work item 14888 - Simple =IF() formula disappears
Mark Baker
2010-12-15 10:07:21 +0000
20eec570ffMinor performance/memory tweaks to the Excel2007 Writer
Mark Baker
2010-12-14 17:57:15 +0000
aa213fe236Provide option to use PCLZip as an alternative to ZipArchive. 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.
Mark Baker
2010-12-13 23:56:51 +0000
ba4b73c536Removed _sheetIndex property (and related getter/setter methods) from Readers that don't use it
Mark Baker
2010-12-12 11:57:59 +0000
5a5e920444Allow cell value type attribute of "str" in Excel2007 xlsx files as a synonym for type of "s"
Mark Baker
2010-12-11 22:00:16 +0000
5168f49b36Preparations for PHPExcel 1.7.5
Maarten Balliauw
2010-12-10 07:53:41 +0000
1def6cae75Reworked OLE Reader logic to provide a single stream reader for all streams (Workbook, Properties and Document Properties) rather than duplicating code with separate stream readers for each
Mark Baker
2010-12-10 00:28:18 +0000
1fad8bd2ddGeneral performance improvements, and specific improvements in the CSV Reader
Mark Baker
2010-12-09 12:07:50 +0000
2e86645775Prevent warnings if worksheeet dimensions are empty
Mark Baker
2010-12-08 17:19:31 +0000
0ea41c7996Removed diagnostic hexDump() function from file. Not much use here anyway with the autoloader, if trying to hex dump anything other than read Excel5 files. Will move it to my debugging code, where it should be anyway.
Mark Baker
2010-12-08 15:08:09 +0000
ac13feadecFix references to private PHPExcel_Reader_Excel5 methods in PHPExcel_Reader_Excel5_Escher
Mark Baker
2010-12-07 22:54:29 +0000
c5ea92442dPerformance improvements for the Excel5 Reader and Writer
Mark Baker
2010-12-07 17:34:47 +0000
1238c6086dBugfix: Work item 14831 - Style : applyFromArray() for 'allborders' not working
Mark Baker
2010-12-06 12:45:41 +0000
9cacc2fda7Feature: (MBaker) Fix to toFormattedString() method in PHPExcel_Style_NumberFormat to handle fractions with a # code for the integer part
Mark Baker
2010-12-06 12:42:16 +0000
756e587bc9Fixes for CSV Reader read contiguous row numbering
Mark Baker
2010-12-03 23:07:13 +0000
f1e413bcc1Performance improvements to the CSV Reader and Writer
Mark Baker
2010-12-03 17:48:10 +0000
5917b8c9b0Fix call to DATEVALUE() and TIMEVALUE() methods for new function classes
Mark Baker
2010-12-03 14:28:57 +0000
a5fceae060Performance tweaks to the Calculation Engine to reduce memory usage. Splitting the functions.php into several smaller classes based on function category, so that only those category files actually used by functions in formulae will be included by the autoloader
Mark Baker
2010-12-02 17:58:26 +0000
787dae6334Performance tweaks to the Calculation Engine to reduce memory usage. Splitting the functions.php into several smaller classes based on function category, so that only those category files actually used by functions in formulae will be included by the autoloader
Mark Baker
2010-12-02 17:56:33 +0000
c672fa5980Minor performance tweaks to Excel2007 and Excel5 Readers
Mark Baker
2010-11-29 12:45:59 +0000
df98faa375Minor performance tweaks
Mark Baker
2010-11-26 17:22:22 +0000
506eabdbf7Minor performance tweaks
Mark Baker
2010-11-26 13:31:51 +0000
fcf2643609Additional validation check in the canLoad() method of Excel2007 Reader to return false for OpenXML documents that aren't workbooks (eg. pptx, docx)
Mark Baker
2010-11-26 00:36:01 +0000
f2bed9ca37Memory and Performance Improvements for Excel5 Reader
Mark Baker
2010-11-25 17:43:23 +0000
6c9a41879bFeature: Added strictNullComparison argument to the worksheet fromArray() method
Mark Baker
2010-11-24 15:28:15 +0000
b25ced63ccBugfix: Work item 13559 - PHPExcel_Writer_PDF does not handle cell borders correctly
Mark Baker
2010-11-24 14:12:12 +0000
1f188d3f92Minor performance tweak
Mark Baker
2010-11-23 22:43:43 +0000
9641c16df0Memory and Performance Improvements
Mark Baker
2010-11-23 17:24:29 +0000
4da85678d4Minor performance tweaks
Mark Baker
2010-11-23 00:05:20 +0000
29c4b1db5fSome general performance tweaks, and some specific to the Excel2007 Writer
Mark Baker
2010-11-22 18:00:22 +0000
606f43a086Performance tweaks, particularly using standard binary operations rather than matrix operations when working with single cell operands
Mark Baker
2010-11-20 23:36:20 +0000
951c332cdaMinor performance tweaks to the HTML Writer
Mark Baker
2010-11-19 14:09:53 +0000
dbcd7fb1afMinor performance tweaks to the HTML Writer
Mark Baker
2010-11-17 18:04:55 +0000
06bfeaaea0Fixed compilation error in modified HTML writer
Mark Baker
2010-11-17 09:15:54 +0000
bd46652fb1Minor performance tweaks
Mark Baker
2010-11-16 16:44:32 +0000
012348ac4aMinor performance tweak
Mark Baker
2010-11-15 13:38:48 +0000
9c9657a2e2Minor performance tweaks
Mark Baker
2010-11-14 17:56:00 +0000
270ea1df05Minor performance tweaks
Mark Baker
2010-11-14 00:17:32 +0000
51dc3403ffMinor performance tweaks
Mark Baker
2010-11-13 23:33:20 +0000
cb382e89f3Bugfix: Workitem 14679 - Formula evaluation fails with Japanese sheet refs
Mark Baker
2010-11-13 00:06:30 +0000
ad8b80bae9Bugfix: Workitem 14679 - Formula evaluation fails with Japanese sheet refs
Mark Baker
2010-11-12 23:53:31 +0000
3bd1ef536dMinor performance tweak
Mark Baker
2010-11-11 12:30:23 +0000
b16083246eGeneral: Improved performance for the Excel2007 Writer
Mark Baker
2010-11-09 13:02:55 +0000
c0ae3911b6Minor performance tweaks: changing PHPExcel_Shared_XMLWriter to extend the XMLWriter class rather than providing a wrapper for an instance of XMLWriter, with slight modifications to the writeRaw() method
Mark Baker
2010-11-09 12:31:59 +0000
d7583efe44Improved performance specifically for the Excel5 Writer, but also some general improvement for all Writers
Mark Baker
2010-11-07 16:14:24 +0000
b818187d3cFix to date properties when set as a formatted string
Mark Baker
2010-11-07 16:08:27 +0000
98e7fa5a6aDocumentation
Mark Baker
2010-11-05 22:14:59 +0000
3aa1142b5fPerformance tweaks (particularly affecting the Excel5 Writer)
Mark Baker
2010-11-05 22:13:41 +0000
8c3ce4f938Minor performance tweak
Mark Baker
2010-10-28 16:50:52 +0000
bd82adc1f3Minor performance tweak... simple improvement to sorting the cell cache array
Mark Baker
2010-10-27 10:39:53 +0000
e3b15694c0Minor performance tweaks
Mark Baker
2010-10-26 15:40:55 +0000
66f0fb12d8Minor performance tweaks
Mark Baker
2010-10-26 14:22:31 +0000
42b1e0ad76Minor performance tweaks
Mark Baker
2010-10-26 12:29:44 +0000
0a826fe9a6General: Applied patch 6609 - Removes a unnecessary loop through each cell when applying conditional formatting to a range.
Mark Baker
2010-10-25 09:42:34 +0000
568d3fa933General: Applied patch 7169 - Removed spurious PHP end tags (?>)
Mark Baker
2010-10-25 09:33:01 +0000
c481e81fb4User documentation for Spreadsheet Readers
Mark Baker
2010-10-23 22:50:06 +0000
e1c316fc58Implementation of the contiguous flag for the CSV reader, for use with a Read Filter
Mark Baker
2010-10-23 22:49:18 +0000
c448f2ed7aImplementation of the contiguous flag for the CSV reader, for use with a Read Filter
Mark Baker
2010-10-23 22:25:48 +0000
22f704e4b1New examples of Reading Workbooks
Mark Baker
2010-10-23 13:31:14 +0000
14dbe6ec72Examples of accessing Workbook Properties
Mark Baker
2010-10-20 21:55:40 +0000
5af4355b78New examples, including reading a larger workbook in chunks to give improved memory usage
Mark Baker
2010-10-20 11:30:09 +0000
45109e0533Reader exception handling example
Mark Baker
2010-10-19 12:40:52 +0000
af3300e387Bugfix: Workitem 14425 - Wrong exception message while deleting column
Mark Baker
2010-10-19 12:24:39 +0000
a73633f130Bugfix: Workitem 14374 - BUG : Excel5 and setReadFilter ? Prevent creation of Merged cells unless the read filter permits one or more cells within the range
Mark Baker
2010-10-18 16:55:55 +0000
58a600b3e3New examples of Reading Workbooks
Mark Baker
2010-10-13 19:37:19 +0000
ad9e4e2f0fFix for a single character string in a call to PHPExcel_Shared_Date::stringToExcel() being treated as a valid date
Mark Baker
2010-10-13 13:16:02 +0000
10634822feMinor fix to toArray() method for row indexing when the $returnCellRef argument is false
Mark Baker
2010-10-12 21:34:04 +0000
6b54d5a103New examples of Reading Workbooks
Mark Baker
2010-10-12 21:32:17 +0000
b0fd47beeeRemove some spurious methods and attributes from the SYLK Reader
Mark Baker
2010-10-08 14:47:11 +0000
f04feb78f8Improved file identification by adding a magic signature test (0x1F,0x8B as the first two characters of the file)
Mark Baker
2010-10-07 10:11:37 +0000
45ac4eae14Oops rectification
Mark Baker
2010-10-06 13:02:47 +0000
9946aa1595Bugfix: Workitem 14374 - BUG : Excel5 and setReadFilter ? Modifications to Worksheet's to_array() method to handle worksheets partially loaded with a readFilter by switching to iterators
Mark Baker
2010-10-06 12:57:54 +0000
2ec5a8b3bbBugfix: Workitem 14374 - BUG : Excel5 and setReadFilter ?
Mark Baker
2010-10-05 22:20:49 +0000