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
678b40bb24Added 30template.php test
Mark Baker
2010-09-29 22:26:10 +0000
6364b7a58aFeature: Configure PDF Writer margins based on Excel Worksheet Margin Settings values
Mark Baker
2010-09-29 14:41:43 +0000
f0131c0282Bugfix: Modified PHPExcel_Shared_Date::isDateTimeFormatCode() to return false if format code begins with "_" or with "0 " to prevent false positives These leading characters are most commonly associated with number, currency or accounting (or occasionally fraction) formats
Mark Baker
2010-09-28 15:53:49 +0000
79f92b2063Bugfix: Added autoloader to DefaultValueBinder and AdvancedValueBinder
Mark Baker
2010-09-27 23:22:05 +0000
32b8b1c7abFeature: Work item 14301 - PHPExcel_Worksheet->toArray() is returning truncated values I've made some modifications so that it is possible to pass a number of additional arguments to the method to determine exactly how the data is returned:
Mark Baker
2010-09-23 16:52:57 +0000
f93fde9b38Bugfix: Workitem 14086 - Named range with sheet name that contains the $ throws exception when getting the cell
Mark Baker
2010-09-20 15:05:54 +0000
06535cc296Bugfix: Workitem 14086 - Named range with sheet name that contains the $ throws exception when getting the cell
Mark Baker
2010-09-20 14:47:57 +0000
6925afdb91Bugfix: Workitem 14256 - Worksheet title exception when duplicate worksheet is being renamed but exceeds the 31 character limit
Mark Baker
2010-09-18 12:45:22 +0000
5f5e793c05Added Quadratic Equation Solver examples of calculation engine usage
Mark Baker
2010-09-17 22:46:31 +0000
31196f0a14Feature: Advanced Value Binder now recognises TRUE/FALSE strings (locale-specific) and converts to boolean
Mark Baker
2010-09-17 22:41:31 +0000
a3a0aa73e7Bugfix: Workitems 14260 & 14233 - Setting cell values to one char strings & Trouble reading one character string
Mark Baker
2010-09-16 17:04:11 +0000
388d2c80d1Feature: Support for Extended and User-defined Workbook Properties in Excel2007 Writer
Mark Baker
2010-09-15 21:55:37 +0000
c6a3679d77Feature: Support for Extended Workbook Properties (Manager) in Excel2007 Writer
Mark Baker
2010-09-15 19:15:35 +0000
b089979152Bugfix: 14236 - problem with getting cell values from another worksheet... (if cell doesn't exist)
Mark Baker
2010-09-14 13:50:36 +0000
e06932e0e4Bugfix: Workitem 14226 - unassigned object variable in PHPExcel->removeCellXfByIndex
Mark Baker
2010-09-12 22:46:15 +0000
3f807a1c01Bugfix: Workitem 14223 - Advanced Value Binder Not Working? Fixed AdvancedValueBinder date handling (with support for a wider range of date formats), and added support for strings containing numeric values in scientific format (e.g. "-1.234e+5")
Mark Baker
2010-09-10 14:57:07 +0000
f0f2d98146Provided a setGenerateSheetNavigationBlock(false); option to suppress generation of the sheet navigation block when writing multiple worksheets to HTML
Mark Baker
2010-09-08 15:07:31 +0000
2718e40b3aProvided a setGenerateSheetNavigationBlock(false); option to suppress generation of the sheet navigation block when writing multiple worksheets to HTML
Mark Baker
2010-09-08 15:05:26 +0000
e7d6547e56Applied ReadFilter option to OOCalc and Excel2003XML Readers, plus additional tests in the /Tests directory
Mark Baker
2010-09-08 13:49:08 +0000