RetailCRM-Mirror/PHPExcel
1
0
Fork 0
mirror of https://github.com/retailcrm/PHPExcel.git synced 2025-04-06 06:43:36 +03:00
Code Issues Projects Releases Wiki Activity

Commit graph

  • 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 +00:00
  • 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 +00:00
  • 85ff71fd18 General: Improved memory usage in CSV Writer Mark Baker 2011-05-11 22:36:47 +00:00
  • adacb26028 Additional PHPDocumentor tagging Mark Baker 2011-04-29 14:23:57 +00:00
  • dd7b0610e9 Bugfix: Work item 15762 - INDIRECT() function doesn't work with named ranges Mark Baker 2011-04-29 13:44:27 +00:00
  • 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 +00:00
  • 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 +00:00
  • ff4daef39c General: Fix to build to ensure that Examples are included with the documentation Mark Baker 2011-04-23 21:12:20 +00:00
  • c7f99d0d98 Bugfix: Work item 15707 - ini_set() call in Calculation class destructor Mark Baker 2011-04-19 21:40:35 +00:00
  • 631834b4d6 Minor performance improvement to date conversion routines Mark Baker 2011-04-09 18:16:08 +00:00
  • 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 +00:00
  • 2d362092ba Added document properties to HTML output as meta tags Mark Baker 2011-03-23 16:34:31 +00:00
  • a0ac293ec6 Bugfix: Work item 15537 - Excel2007 Reader canRead function bug Mark Baker 2011-03-17 11:29:14 +00:00
  • 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 +00:00
  • 34c4aa18ee Additional work on the Excel2003XML Reader Mark Baker 2011-03-04 14:39:00 +00:00
  • f08f16c8ca General: Work item 15461 - Locale file paths not fit for windows Mark Baker 2011-03-04 14:22:08 +00:00
  • 09df4fd647 Bugfix: Work item 15459 - Invalid cell coordinate in Autofilter for Excel2007 Writer Mark Baker 2011-03-03 23:01:31 +00:00
  • cfaa5209f7 General: Work item 15405 - Two easy to fix Issues concerning PHPExcel_Token_Stack (l10n/UC) Mark Baker 2011-02-28 00:32:55 +00:00
  • fb9a1e2ca8 Preparing 1.7.6 Maarten Balliauw 2011-02-28 00:16:46 +00:00
  • aedff36d4e Bugfix: Work item 15409 - Full column/row references in named ranges not supported by updateCellReference() Mark Baker 2011-02-27 22:33:42 +00:00
  • 51b3f847fb Documented link about using PHPExcel with Typo3 Mark Baker 2011-02-26 22:56:12 +00:00
  • 23c288efad Remove Serialize test from runall.php Mark Baker 2011-02-26 21:51:40 +00:00
  • 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 +00:00
  • 901d20e6f9 Add further description to PHPDoc blocks Mark Baker 2011-02-25 16:52:43 +00:00
  • 5b71914eea Minor work on Excel2003XML Reader (not yet complete) Mark Baker 2011-02-23 01:05:05 +00:00
  • 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 +00:00
  • 57f3b411d1 Set documentation language to English (UK) Mark Baker 2011-02-22 17:35:34 +00:00
  • 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 +00:00
  • 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 +00:00
  • 46e1c4eaff General: Removed Serialized Reader/Writer as these no longer work. Mark Baker 2011-02-22 10:21:38 +00:00
  • 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 +00:00
  • 2dcead065d Fixed bug in translation functions of the calculation engine Mark Baker 2011-02-18 17:39:58 +00:00
  • 4b0852428d Updated FAQ section Mark Baker 2011-02-17 13:02:21 +00:00
  • ab2825c752 Feature: Work Item 2346 - Implement more Excel calculation functions Implemented the DGET() Database function Mark Baker 2011-02-13 17:20:07 +00:00
  • 7425aa8460 Feature: Work Item 2346 - Implement more Excel calculation functions Implemented the DGET() Database function Mark Baker 2011-02-13 17:19:00 +00:00
  • 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 +00:00
  • 7bb65068cd Oops... missing semi-colon (now fixed) Mark Baker 2011-02-11 23:12:39 +00:00
  • 8a00ef61e8 Added debug log echo option to Calculation Engine (for PHPExcel development team debugging use only) Mark Baker 2011-02-11 22:45:17 +00:00
  • 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 +00:00
  • eb5dadcd4c Bugfix: Work item 15312 - Caching and tmp partition exhaustion Mark Baker 2011-02-11 22:26:51 +00:00
  • 9b40f3edf5 Fixed phing build to include Documentation/Examples Mark Baker 2011-02-10 16:30:33 +00:00
  • 0fd77aa397 Minor performance tweaks when working with alternating blocks in a string Mark Baker 2011-02-10 12:39:34 +00:00
  • 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 +00:00
  • 4a33c85f26 Work Item 15198 - FreezePane causing damaged or modified error Mark Baker 2011-02-08 13:14:30 +00:00
  • 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 +00:00
  • 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 +00:00
  • 3757a0e6ff Remove debug code reference to hexdump() Mark Baker 2011-01-31 22:01:08 +00:00
  • 8c0663486b Feature: Improved toFormattedString() handling for Currency and Accounting format masks to render currency symbols Mark Baker 2011-01-31 17:18:10 +00:00
  • 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 +00:00
  • 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 +00:00
  • 5e27d037bc Bugfix: Work item 14980 - Images not getting copyied with the ->clone function Mark Baker 2011-01-28 23:09:02 +00:00
  • c1fe7016ab Feature: Added support for superscript/subscript in HTML/PDF Writers Mark Baker 2011-01-28 16:02:33 +00:00
  • 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 +00:00
  • 545c2a0f19 Bugfix: Work item 15172 - rangeToarray function modified for non-existent cells Mark Baker 2011-01-27 16:09:37 +00:00
  • 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 +00:00
  • 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 +00:00
  • 585ee1514e Feature: Added initial support for cell comments in the Excel5 Reader for BIFF8 Mark Baker 2011-01-25 09:46:30 +00:00
  • db2fb8158a Feature: Added initial support for cell comments in the Excel5 Reader for BIFF8 Mark Baker 2011-01-24 12:26:06 +00:00
  • 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 +00:00
  • 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 +00:00
  • 9cc2f8d50b Feature: Added basic support for cell comments in the OOCalc Reader Mark Baker 2011-01-21 14:36:28 +00:00
  • 2b4c15b92f Feature: Added support for cell comments in the Gnumeric and Excel2003XML Readers Mark Baker 2011-01-21 13:11:28 +00:00
  • 5a2830c499 Bugfix: Work item 15129 - Worksheet fromArray() only working with 2-D arrays Mark Baker 2011-01-21 10:47:20 +00:00
  • dd4f5252ea Added BAHTTEXT to reader/writer list of Excel functions, though not supported in the calculation engine yet Mark Baker 2011-01-14 18:01:41 +00:00
  • d154e853b2 Bugfix: Work item 15094 - Merge cells 'un-merge' when using an existing spreadsheet (Excel5 Reader) Mark Baker 2011-01-13 16:01:29 +00:00
  • 9f252c9e80 Bugfix: Work item 15089 - PHPExcel_Worksheet->toArray() index problem Mark Baker 2011-01-12 16:48:54 +00:00
  • 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(). Mark Baker 2011-01-12 15:20:29 +00:00
  • 56d7506cf5 Bugfix: Minor patchfix for Excel2003XML Reader when XML is defined with a charset attribute Mark Baker 2011-01-10 17:51:55 +00:00
  • 1ec263ee94 General: Improved performance (speed), for building the Shared Strings table in the Excel2007 Writer. Mark Baker 2011-01-07 14:52:28 +00:00
  • 1c6fa7b5ab Bugfix: Work item 15046 - 1.7.5 fails cell->getCalculatedValue() Mark Baker 2011-01-05 17:53:17 +00:00
  • 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 Mark Baker 2011-01-04 23:14:59 +00:00
  • 59b831c4f1 Speed boost and memory reduction in the Worksheet toArray() method. Mark Baker 2011-01-04 13:52:05 +00:00
  • b321f33fed Bugfix: Work item 15029 - coordinateFromString throws exception for rows greater than 99,999 Mark Baker 2011-01-03 22:39:51 +00:00
  • fd95065240 Work item 11583 - Need method for removing autoFilter Maarten Balliauw 2011-01-03 10:26:43 +00:00
  • ccbb28167b Updated headers to reflect the new year. Happy new year 2011! Maarten Balliauw 2011-01-03 09:20:10 +00:00
  • 6ed30f559a git-svn-id: https://phpexcel.svn.codeplex.com/svn/trunk@66316 2327b42d-5241-43d6-9e2a-de5ac946f064 Mark Baker 2011-01-02 12:14:18 +00:00
  • 1911d4a48f Updated 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 +00:00
  • 6da04eb1d2 Performance improvements to the Excel2003XML Reader Mark Baker 2010-12-28 22:38:20 +00:00
  • c644f9816c Feature: Work item 14979 - Added listWorksheetNames() method to Excel2003XML Reader, and fixed a namespace bug Mark Baker 2010-12-28 21:37:11 +00:00
  • 14cc952323 Feature: Work item 14979 - Added listWorksheetNames() method to OOCalc and Gnumeric Readers Mark Baker 2010-12-28 19:34:21 +00:00
  • 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. Mark Baker 2010-12-28 18:46:23 +00:00
  • 457f826fa6 Bugfix: Work item 14973 - PHPExcel_Cell::isInRange() incorrect results - offset by one column Mark Baker 2010-12-27 22:43:11 +00:00
  • d027a3d0a7 Bugfix: Calc engine needs to use Ungreedy regexp in parser Mark Baker 2010-12-24 12:08:31 +00:00
  • 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 Mark Baker 2010-12-23 21:18:23 +00:00
  • f71aeebd30 Minor performance/memory tweaks to the Excel2007 Writer Mark Baker 2010-12-15 17:19:30 +00:00
  • ad3d9dc853 Bugfix: Work item 14888 - Simple =IF() formula disappears Mark Baker 2010-12-15 10:07:21 +00:00
  • 20eec570ff Minor performance/memory tweaks to the Excel2007 Writer Mark Baker 2010-12-14 17:57:15 +00:00
  • 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. Mark Baker 2010-12-13 23:56:51 +00:00
  • ba4b73c536 Removed _sheetIndex property (and related getter/setter methods) from Readers that don't use it Mark Baker 2010-12-12 11:57:59 +00:00
  • 5a5e920444 Allow 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 +00:00
  • 5168f49b36 Preparations for PHPExcel 1.7.5 Maarten Balliauw 2010-12-10 07:53:41 +00:00
  • 1def6cae75 Reworked 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 +00:00
  • 1fad8bd2dd General performance improvements, and specific improvements in the CSV Reader Mark Baker 2010-12-09 12:07:50 +00:00
  • 500a8e763e First steps toward reading cell comments Mark Baker 2010-12-08 17:20:03 +00:00
  • 2e86645775 Prevent warnings if worksheeet dimensions are empty Mark Baker 2010-12-08 17:19:31 +00:00
  • 0ea41c7996 Removed 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 +00:00
  • ac13feadec Fix references to private PHPExcel_Reader_Excel5 methods in PHPExcel_Reader_Excel5_Escher Mark Baker 2010-12-07 22:54:29 +00:00
  • c5ea92442d Performance improvements for the Excel5 Reader and Writer Mark Baker 2010-12-07 17:34:47 +00:00
  • 1238c6086d Bugfix: Work item 14831 - Style : applyFromArray() for 'allborders' not working Mark Baker 2010-12-06 12:45:41 +00:00
  • 9cacc2fda7 Feature: (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 +00:00