RetailCRM-Mirror/PHPExcel
1
0
Fork 0
mirror of https://github.com/retailcrm/PHPExcel.git synced 2024-11-22 21:36:05 +03:00
Code Issues Projects Releases Wiki Activity
649 Commits 14 Branches 14 Tags 22 MiB
cellRestructure
Commit Graph

182 Commits

Author SHA1 Message Date
Mark Baker
59932b0cac Bugfix: Work item 18370 - Error loading xlsx file with column breaks 
Deprecated the getCalculatedValue(), setCalculatedValue(), setFormulaAttributes() and getFormulaAttributes() methods in PHPExcel_Cell.
Documentation changes and unit tests.
 2012-07-18 12:29:33 +01:00
Mark Baker
1535b4d9e7 Feature: Modified ERF and ERFC Engineering functions to accept Excel 2010's modified acceptance of negative arguments 2012-07-14 14:20:17 +01:00
Mark Baker
e2a2fdb335 Bugfix: (seltzlab) Fix to excel2007 Chart Writer when a $plotSeriesValues is empty 2012-07-14 01:26:53 +01:00
Mark Baker
c20c5f6ac8 Bugfix: (wackonline) OOCalc Reader fix for NULL cells 2012-07-14 00:40:55 +01:00
Progi1984
e1104f1862 ADDED : Implement support for AutoFilter in PHPExcel_Writer_Excel5 2012-07-13 18:20:06 +02:00
Mark Baker
b7acf2bbe4 Bugfix: Work items 15905 and 18183 
Allow "no impact" to formats on Conditional Formatting
 2012-07-02 22:38:24 +01:00
Mark Baker
6710c8a136 Bugfix: Work items 15799 and 18278 
Background color cell is always black when editing cell
 2012-06-26 21:08:11 +01:00
Mark Baker
57464cbf1a Bugfix: Support for "e" (epoch) date format mask 
Rendered as a 4-digit CE year in non-Excel outputs
 2012-06-26 20:55:27 +01:00
Mark Baker
ec9256a12e Bugfix: Patch 12318 - OOCalc cells containing <text:span> inside the <text:p> tag 
Bugfix: Fix to listWorksheetInfo() method for OOCalc Reader

git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@91446 2327b42d-5241-43d6-9e2a-de5ac946f064
 2012-06-07 19:42:45 +00:00
Mark Baker
0502d215d0 Initial refactoring of PDF Writer to work with user-selection of 3rd party PDF libraries 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@91327 2327b42d-5241-43d6-9e2a-de5ac946f064
 2012-06-04 20:06:16 +00:00
Mark Baker
9ef758443d Bugfix: Work item 17471 - OOCalc cells contain same data bug? 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@90421 2327b42d-5241-43d6-9e2a-de5ac946f064
 2012-05-13 18:15:46 +00:00
Mark Baker
47c94fb28a New Reader Feature: listWorksheetInfo() method added to Readers... courtesy of Christopher Mullins (schir1964) 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@88719 2327b42d-5241-43d6-9e2a-de5ac946f064
 2012-03-31 19:16:53 +00:00
Mark Baker
4f76dfad97 Bugfix: (bnr) Work item 17501 - =sumproduct(A,B) <> =sumproduct(B,A) in xlsx 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@87695 2327b42d-5241-43d6-9e2a-de5ac946f064
 2012-03-12 23:42:12 +00:00
Progi1984
41199626d8 FIXED : Work item 8916 - Support for Rich-Text in PHPExcel_Writer_Excel5 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@87070 2327b42d-5241-43d6-9e2a-de5ac946f064
 2012-02-27 22:05:21 +00:00
Mark Baker
3543ea45ef Bugfix: Work item 17186 - setSelectedCellByColumnAndRow is not working 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@86732 2327b42d-5241-43d6-9e2a-de5ac946f064
 2012-02-21 10:44:10 +00:00
Mark Baker
6f91dd9f59 Bugfix: Work item 17403 - duplicateStyle() method doesn't duplicate conditional formats 
Added an equivalent duplicateConditionalStyle() method for duplicating conditional styles

git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@86383 2327b42d-5241-43d6-9e2a-de5ac946f064
 2012-02-12 18:04:22 +00:00
Progi1984
097a30b6d8 IMPROVED : Changelog 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@85954 2327b42d-5241-43d6-9e2a-de5ac946f064
 2012-02-02 09:57:20 +00:00
Mark Baker
ac37b8ae8d Bugfix: Work item 17262 - Named Range definition in .xls when sheet reeference is quote wrapped 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@85313 2327b42d-5241-43d6-9e2a-de5ac946f064
 2012-01-15 12:06:04 +00:00
Mark Baker
a22e46f328 Bugfix: Work item 17199 - Indexed colors should be consistent with Excel and start from 1 (current indexing of the default palette array starts at 0) 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@85260 2327b42d-5241-43d6-9e2a-de5ac946f064
 2012-01-14 10:51:29 +00:00
Mark Baker
438bc9da60 Bugfix: Work item 17166 - Indexed colors do not refer to Excel's indexed colors? 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@84644 2327b42d-5241-43d6-9e2a-de5ac946f064
 2012-01-02 00:12:09 +00:00
Mark Baker
86db0b8535 General: Change iterators to implement Iterator rather than extend CachingIterator, as a fix for PHP 5.4. changes in SPL 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@84516 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-12-30 00:04:06 +00:00
Mark Baker
24bd9b5e8a Feature: Additional row iterator options: allow a start row to be defined in the constructor; seek(), and prev() methods added. 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@84512 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-12-29 22:59:24 +00:00
Mark Baker
b235c531a7 Experimental - Added getHighestDataColumn(), getHighestDataRow(), getHighestRowAndColumn() and calculateWorksheetDataDimension() methods for the worksheet that return the highest row and column that have cell records 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@83932 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-12-16 16:01:21 +00:00
Mark Baker
0924d0a4ca Bugfix: (fauvel) Work item 16958 - Cell::getFormattedValue returns RichText object instead of string 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@83890 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-12-14 23:00:45 +00:00
Mark Baker
7fce476f0c General: (atz) Work item 17024 - Unknown codepage: 10007 
Additional Mac codepages

git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@83889 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-12-14 22:48:09 +00:00
Mark Baker
93e8a05780 Feature - initial version of Igbinary (serialized) cell caching 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@83657 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-12-05 23:42:39 +00:00
Mark Baker
07e56b5a60 Feature - initial version of SQLite cell caching 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@83557 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-12-03 00:24:44 +00:00
Mark Baker
ee028c165d General: Work item 16028 - Fix for projects that still use old autoloaders 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@83541 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-12-02 14:16:23 +00:00
Mark Baker
969c409ba1 Bugfix: Work item 16266 - PHPExcel_Style::applyFromArray() returns null rather than style object in advanced mode 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@83539 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-12-02 13:59:57 +00:00
Mark Baker
207f6f5818 General: Work item 16359 - [Patch] faster stringFromColumnIndex() 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@83538 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-12-02 13:40:40 +00:00
Mark Baker
bbc73039e6 General: Ensure use of system temp directory for all temporary work files, unless explicitly specified 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@83403 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-11-28 14:44:28 +00:00
Mark Baker
68a0930f67 Bugfix: Work item 16960 - Previous calculation engine error conditions trigger cyclic reference errors 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@83263 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-11-25 14:37:47 +00:00
Mark Baker
f2076cde3f Bugfix: Work item 16956 - External links in Excel2010 files cause Fatal error 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@83261 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-11-25 13:34:08 +00:00
Mark Baker
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

git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@83260 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-11-25 12:16:01 +00:00
Mark Baker
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

git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@82024 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-10-26 16:16:43 +00:00
Mark Baker
efc066c233 Bugfix: Work item 16212 - $arguments improperly used in CachedObjectStorage/PHPTemp.php 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@82008 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-10-25 19:31:57 +00:00
Mark Baker
f2310e05d0 Bugfix: Work item 16246 - reader/CSV fails on this file 
auto_detect_line_endings now set in CSV reader

git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@77805 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-08-05 14:37:30 +00:00
Mark Baker
94e3dc3fd2 Improved speed and memory usage in Excel5 Writer 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@74786 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-06-01 23:09:12 +00:00
Mark Baker
48b2fb8e99 Bugfix: Locale-specific fix to text functions when passing a boolean argument instead of a string 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@73499 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-05-15 22:58:20 +00:00
Mark Baker
85ff71fd18 General: Improved memory usage in CSV Writer 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@73146 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-05-11 22:36:47 +00:00
Mark Baker
dd7b0610e9 Bugfix: Work item 15762 - INDIRECT() function doesn't work with named ranges 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@72460 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-04-29 13:44:27 +00:00
Mark Baker
5979a4ec13 Bugfix: Work item 15786 - RangeToArray strange array keys 
and Minor performance tweak to the workbook setActiveSheetIndexByName() method


git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@72435 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-04-28 20:42:50 +00:00
Mark Baker
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 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@72227 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-04-25 14:25:53 +00:00
Mark Baker
ff4daef39c General: Fix to build to ensure that Examples are included with the documentation 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@72195 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-04-23 21:12:20 +00:00
Mark Baker
c7f99d0d98 Bugfix: Work item 15707 - ini_set() call in Calculation class destructor 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@72060 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-04-19 21:40:35 +00:00
Mark Baker
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 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@71420 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-04-05 21:57:59 +00:00
Mark Baker
a0ac293ec6 Bugfix: Work item 15537 - Excel2007 Reader canRead function bug 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@70501 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-03-17 11:29:14 +00:00
Mark Baker
9704feec19 Bugfix: Work item 15518 - PCLZip library issue 
References to ZipArchive Constants when ZipArchive class isn't available

git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@70307 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-03-14 13:52:49 +00:00
Mark Baker
f08f16c8ca General: Work item 15461 - Locale file paths not fit for windows 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@69731 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-03-04 14:22:08 +00:00
Mark Baker
09df4fd647 Bugfix: Work item 15459 - Invalid cell coordinate in Autofilter for Excel2007 Writer 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@69709 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-03-03 23:01:31 +00:00
Mark Baker
cfaa5209f7 General: Work item 15405 - Two easy to fix Issues concerning PHPExcel_Token_Stack (l10n/UC) 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@69508 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-02-28 00:32:55 +00:00
Maarten Balliauw
fb9a1e2ca8 Preparing 1.7.6 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@69504 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-02-28 00:16:46 +00:00
Mark Baker
aedff36d4e Bugfix: Work item 15409 - Full column/row references in named ranges not supported by updateCellReference() 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@69495 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-02-27 22:33:42 +00:00
Mark Baker
45fb4d84c1 Bugfix: Work item 15421 - PHPExcel_ReferenceHelper::insertNewBefore() is missing an 'Update worksheet: comments' section 
Solution, courtesy of MKunert

git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@69421 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-02-25 22:57:22 +00:00
Mark Baker
46e1c4eaff General: Removed Serialized Reader/Writer as these no longer work. 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@69147 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-02-22 10:21:38 +00:00
Mark Baker
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)


git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@69064 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-02-21 12:21:20 +00:00
Mark Baker
7425aa8460 Feature: Work Item 2346 - Implement more Excel calculation functions 
Implemented the DGET() Database function

git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@68576 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-02-13 17:19:00 +00:00
Mark Baker
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

git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@68574 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-02-13 17:08:00 +00:00
Mark Baker
5a7e7bb93f Bugfix: Work item 15308 - Writing to Variable No Longer Works. $_tmp_dir Missing in PHPExcel\PHPExcel\Shared\OLE\PPS\Root.php 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@68481 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-02-11 22:44:05 +00:00
Mark Baker
eb5dadcd4c Bugfix: Work item 15312 - Caching and tmp partition exhaustion 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@68479 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-02-11 22:26:51 +00:00
Mark Baker
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) 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@68308 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-02-10 12:26:50 +00:00
Mark Baker
4a33c85f26 Work Item 15198 - FreezePane causing damaged or modified error 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@68177 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-02-08 13:14:30 +00:00
Mark Baker
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()

git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@68176 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-02-08 12:55:45 +00:00
Mark Baker
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.

git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@68124 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-02-07 11:19:07 +00:00
Mark Baker
8c0663486b Feature: Improved toFormattedString() handling for Currency and Accounting format masks to render currency symbols 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@67614 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-01-31 17:18:10 +00:00
Mark Baker
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) 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@67582 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-01-30 23:22:12 +00:00
Mark Baker
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 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@67536 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-01-29 17:05:02 +00:00
Mark Baker
5e27d037bc Bugfix: Work item 14980 - Images not getting copyied with the ->clone function 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@67525 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-01-28 23:09:02 +00:00
Mark Baker
545c2a0f19 Bugfix: Work item 15172 - rangeToarray function modified for non-existent cells 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@67475 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-01-27 16:09:37 +00:00
Mark Baker
db2fb8158a Feature: Added initial support for cell comments in the Excel5 Reader for BIFF8 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@67346 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-01-24 12:26:06 +00:00
Mark Baker
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) 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@67190 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-01-21 16:41:02 +00:00
Mark Baker
9cc2f8d50b Feature: Added basic support for cell comments in the OOCalc Reader 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@67188 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-01-21 14:36:28 +00:00
Mark Baker
2b4c15b92f Feature: Added support for cell comments in the Gnumeric and Excel2003XML Readers 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@67186 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-01-21 13:11:28 +00:00
Mark Baker
5a2830c499 Bugfix: Work item 15129 - Worksheet fromArray() only working with 2-D arrays 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@67182 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-01-21 10:47:20 +00:00
Mark Baker
d154e853b2 Bugfix: Work item 15094 - Merge cells 'un-merge' when using an existing spreadsheet (Excel5 Reader) 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@66848 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-01-13 16:01:29 +00:00
Mark Baker
9f252c9e80 Bugfix: Work item 15089 - PHPExcel_Worksheet->toArray() index problem 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@66807 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-01-12 16:48:54 +00:00
Mark Baker
1643bb9613 Feature: 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().

git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@66799 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-01-12 15:20:29 +00:00
Mark Baker
56d7506cf5 Bugfix: Minor patchfix for Excel2003XML Reader when XML is defined with a charset attribute 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@66707 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-01-10 17:51:55 +00:00
Mark Baker
1ec263ee94 General: Improved performance (speed), for building the Shared Strings table in the Excel2007 Writer. 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@66590 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-01-07 14:52:28 +00:00
Mark Baker
74f299e5e5 Bugfix: 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 


git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@66428 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-01-04 23:14:59 +00:00
Mark Baker
59b831c4f1 Speed boost and memory reduction in the Worksheet toArray() method. 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@66403 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-01-04 13:52:05 +00:00
Mark Baker
b321f33fed Bugfix: Work item 15029 - coordinateFromString throws exception for rows greater than 99,999 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@66366 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-01-03 22:39:51 +00:00
Maarten Balliauw
fd95065240 Work item 11583 - Need method for removing autoFilter 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@66340 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-01-03 10:26:43 +00:00
Maarten Balliauw
ccbb28167b Updated headers to reflect the new year. Happy new year 2011! 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@66338 2327b42d-5241-43d6-9e2a-de5ac946f064
 2011-01-03 09:20:10 +00:00
Mark Baker
6ed30f559a git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@66316 2327b42d-5241-43d6-9e2a-de5ac946f064 2011-01-02 12:14:18 +00:00
Mark Baker
c644f9816c Feature: Work item 14979 - Added listWorksheetNames() method to Excel2003XML Reader, and fixed a namespace bug 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@66085 2327b42d-5241-43d6-9e2a-de5ac946f064
 2010-12-28 21:37:11 +00:00
Mark Baker
14cc952323 Feature: Work item 14979 - Added listWorksheetNames() method to OOCalc and Gnumeric Readers 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@66079 2327b42d-5241-43d6-9e2a-de5ac946f064
 2010-12-28 19:34:21 +00:00
Mark Baker
e3a01db2a9 Feature: 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. 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@66063 2327b42d-5241-43d6-9e2a-de5ac946f064
 2010-12-28 18:46:23 +00:00
Mark Baker
457f826fa6 Bugfix: Work item 14973 - PHPExcel_Cell::isInRange() incorrect results - offset by one column 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@65968 2327b42d-5241-43d6-9e2a-de5ac946f064
 2010-12-27 22:43:11 +00:00
Mark Baker
7a792cd566 Bugfix: 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

git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@65692 2327b42d-5241-43d6-9e2a-de5ac946f064
 2010-12-23 21:18:23 +00:00
Mark Baker
ad3d9dc853 Bugfix: Work item 14888 - Simple =IF() formula disappears 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@65353 2327b42d-5241-43d6-9e2a-de5ac946f064
 2010-12-15 10:07:21 +00:00
Mark Baker
aa213fe236 Provide 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.

git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@65260 2327b42d-5241-43d6-9e2a-de5ac946f064
 2010-12-13 23:56:51 +00:00
Maarten Balliauw
5168f49b36 Preparations for PHPExcel 1.7.5 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@65096 2327b42d-5241-43d6-9e2a-de5ac946f064
 2010-12-10 07:53:41 +00:00
Mark Baker
c5ea92442d Performance improvements for the Excel5 Reader and Writer 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@64968 2327b42d-5241-43d6-9e2a-de5ac946f064
 2010-12-07 17:34:47 +00:00
Mark Baker
1238c6086d Bugfix: Work item 14831 - Style : applyFromArray() for 'allborders' not working 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@64875 2327b42d-5241-43d6-9e2a-de5ac946f064
 2010-12-06 12:45:41 +00:00
Mark Baker
9cacc2fda7 Feature: (MBaker) Fix to toFormattedString() method in PHPExcel_Style_NumberFormat to handle fractions with a # code for the integer part 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@64874 2327b42d-5241-43d6-9e2a-de5ac946f064
 2010-12-06 12:42:16 +00:00
Mark Baker
d57128a095 git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@64727 2327b42d-5241-43d6-9e2a-de5ac946f064 2010-12-02 23:32:58 +00:00
Mark Baker
6c9a41879b Feature: Added strictNullComparison argument to the worksheet fromArray() method 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@64270 2327b42d-5241-43d6-9e2a-de5ac946f064
 2010-11-24 15:28:15 +00:00
Mark Baker
b25ced63cc Bugfix: Work item 13559 - PHPExcel_Writer_PDF does not handle cell borders correctly 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@64268 2327b42d-5241-43d6-9e2a-de5ac946f064
 2010-11-24 14:12:12 +00:00
Mark Baker
9641c16df0 Memory and Performance Improvements 
git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@64204 2327b42d-5241-43d6-9e2a-de5ac946f064
 2010-11-23 17:24:29 +00:00