Changelog for
php5-pear-phpexcel-1.7.9-13.3.noarch.rpm :
Thu Oct 17 14:00:00 2013 jweberhoferAATTweberhofer.at
- Version 1.7.9
* Feature Include charts option for HTML Writer
* Feature Added composer file
* Feature Added getStyle() method to Cell object
* Bugfix #18777 - Error in PHPEXCEL/Calculation.php script on line 2976
(stack pop check)
* Bugfix #18794 - CSV files without a file extension being
identified as HTML
* Bugfix gh:PHPOffice/PHPExcel#66 - Wrong check for maximum number of rows in
Excel5 Writer
* Bugfix gh:PHPOffice/PHPExcel#67 - Cache directory for DiscISAM
cache storage cannot be set
* Bugfix #17976 - Fix to Excel2007 Reader for hyperlinks with an anchor
fragment (following a #), otherwise they were treated as sheet references
* Bugfix #18963 - getSheetNames() fails on numeric (floating point style)
names with trailing zeroes
* Bugfix gh:PHPOffice/PHPExcel#130 - Single cell print area
* General gh:PHPOffice/PHPExcel#69 - Improved AdvancedValueBinder for currency
* General #17936 and 17840 - Fix for environments where there is no access to
/tmp but to upload_tmp_dir:
Provided an option to set the sys_get_temp_dir() call to use the
upload_tmp_dir; though by default the standard temp directory will still be
used
* General gh:PHPOffice/PHPExcel#84 - Search style by identity in
* PHPExcel_Worksheet
* General gh:PHPOffice/PHPExcel#85 - Fill SheetView IO in Excel5
* General #18958 - Memory and Speed improvements in PHPExcel_Reader_Excel5
* General gh:PHPOffice/PHPExcel#78 - Modify listWorksheetNames() and
listWorksheetInfo to use XMLReader with streamed XML rather than SimpleXML
* General Restructuring of PHPExcel Exceptions
* General #16926 and 15145 - Refactor Calculation Engine from singleton to a
Multiton
Ensures that calculation cache is maintained independently for different workbooks
* General Modify cell\'s getCalculatedValue() method to return the content of
RichText objects rather than the RichText object itself
* Bugfix gh:PHPOffice/PHPExcel#70 - Fixed formula/formatting bug when removing rows
* Bugfix gh:PHPOffice/PHPExcel#63 - Fix to cellExists for non-existent namedRanges
* Bugfix #18844 - cache_in_memory_gzip \"eats\" last worksheet line,
cache_in_memory doesn\'t
* Feature gh:PHPOffice/PHPExcel#22 - Sheet View in Excel5 Writer
* Bugfix gh:PHPOffice/PHPExcel#82 - PHPExcel_Worksheet may not return last
cached cell
* Bugfix #18551 - Rich Text containing UTF-8 characters creating unreadable
content with Excel5 Writer
* Bugfix gh:PHPOffice/PHPExcel#104 - echo statements in HTML.php
* Feature gh:PHPOffice/PHPExcel#8/CP11704 : Conditional formatting in Excel 5
Writer
* Bugfix gh:PHPOffice/PHPExcel#113 - canRead() Error for GoogleDocs ODS files:
in ODS files from Google Docs there is no mimetype file
* Bugfix gh:PHPOffice/PHPExcel#80 - \"Sheet index is out of bounds.\" Exception
* Bugfix gh:PHPOffice/PHPExcel#105 - Fixed number format fatal error
* Bugfix - Add DROP TABLE in destructor for SQLite and SQLite3 cache
controllers
* Bugfix gh:PHPOffice/PHPExcel#154 - Fix merged-cell borders on HTML/PDF output
* Bugfix gh:PHPOffice/PHPExcel#161 - Fix: Hyperlinks break when removing rows
* Bugfix gh:PHPOffice/PHPExcel#166 - Fix Extra Table Row From Images and Charts
- BREAKING CHANGE! As part of the planned changes for handling array formulae in
workbooks, there are some changes that will affect the PHPExcel_Cell object
methods.
* The following methods are now deprecated, and will be removed in or after version 1.8.0:
- getCalculatedValue() The getValue() method will return calculated
values for cells containing formulae instead.
- setCalculatedValue() The cell value will always contain the result of a
any formula calculation.
- setFormulaAttributes() Will now be determined by the arguments to the
- setFormula() method.
- getFormulaAttributes() This will be replaced by the getArrayFormulaRange()
method.
* The following methods will be added in version 1.8.0
- getFormula() Use to retrieve a cell formula, will return the cell
value if the cell doesn\'t contain a formula, or
is not part of an array formula range.
- setFormula() Use to set a cell formula. It will still be possible
to set formulae using the setValue() and
- setValueExplicit() methods.
calculate() Use to execute a formula calculation to update the
cell value.
- isFormula() Use to determine if a cell contains a formula, or is
part of an array formula range or not.
- isArrayFormula() Use to determine if a cell contains an array formula,
or is part of an array formula range or not.
- getArrayFormulaRange() Use to retrieve an array formula range.
* The following methods will be changed in version 1.8.0
- setValue() The logic behind this will be modified to store
formula values in the new cell property structure,
but it will still perform the same function.
- setValueExplicit() The logic behind this will be modified to store
formula values in the new cell property structure,
but it will still perform the same function.
- getValue() Will no longer return a formula if the cell contains
a formula, but will return the calculated value
instead. For cells that don\'t contain a formula,
it will still return the stored value.
- getDataType() Will return the datatype of the calculated value for
cells that contain formulae.
- setDataType() Error handling will be added to prevent setting a
cell datatype to an inappropriate value.
Thu Feb 21 13:00:00 2013 jweberhoferAATTweberhofer.at
- Version 1.7.8
- BREAKING CHANGE! As part of the planned changes for handling array formulae
in workbooks, there are some changes that will affect the PHPExcel_Cell
object methods.
- More changes
* Phar builder script to add phar file as a distribution option
* Refactor PDF Writer to allow use with a choice of PDF Rendering library
- rather than restricting to tcPDF
- Current options are tcPDF, mPDF, DomPDF
- tcPDF Library has now been removed from the deployment bundle
* Initial version of HTML Reader
* Implement support for AutoFilter in PHPExcel_Writer_Excel5
* Modified ERF and ERFC Engineering functions to accept Excel 2010\'s modified
acceptance of negative arguments
* Support SheetView `view` attribute (Excel2007)
* Excel compatibility option added for writing CSV files
- While Excel 2010 can read CSV files with a simple UTF-8 BOM, Excel2007
and earlier require UTF-16LE encoded tab-separated files.
* option for the CSV Writer will generate files with this formatting for easy
import into Excel2007 and below.
* Language implementations for Turkish (tr)
* Added fraction tests to advanced value binder
* Allow call to font setUnderline() for underline format to specify a simple
* boolean for UNDERLINE_NONE or UNDERLINE_SINGLE
* Add Currency detection to the Advanced Value Binder
* setCellValueExplicitByColumnAndRow() do not return PHPExcel_Worksheet
* Reader factory doesn\'t read anymore XLTX and XLT files
* Magic __toString() method added to Cell object to return raw data value as
a string
* Add cell indent to html rendering
* ZeroHeight for rows in sheet format
* OOCalc cells containing
inside the tag
* Fix to listWorksheetInfo() method for OOCalc Reader
* Support for \"e\" (epoch) date format mask
- Rendered as a 4-digit CE year in non-Excel outputs
* Background color cell is always black when editing cell
* Allow \"no impact\" to formats on Conditional Formatting
* OOCalc Reader fix for NULL cells
* Fix to excel2007 Chart Writer when a $plotSeriesValues is empty
* Various fixes to Chart handling
* Error loading xlsx file with column breaks
* OOCalc Reader now handles percentage and currency data types
* mb_stripos empty delimiter
* getNestingLevel() Error on Excel5 Read
* Fix to Excel5 Reader when cell annotations are defined before their
referenced text objects
* OOCalc Reader modified to process number-rows-repeated
* Chart Title compatibility on Excel 2007
* Chart Refresh returning cell reference rather than values
* Autoshape being identified in twoCellAnchor when includeCharts is TRUE
triggering load error
* v-type texts for series labels now recognised and parsed correctly
* load file failed if the file has no extensionType
* Pattern fill colours in Excel2007 Style Writer
* Excel2007 Writer order of font style elements to conform with Excel2003
using compatibility pack
* Problems with $_activeSheetIndex when decreased below 0.
* PHPExcel_CachedObjectStorage_SQLite3::cacheMethodIsAvailable() uses
class_exists - autoloader throws error
* Cannot access private property
* PHPExcel_CachedObjectStorageFactory::$_cacheStorageMethod
* Data titles for charts
- PHPExcel_Chart_Layout now has methods for getting/setting switches for
displaying/hiding chart data labels
* Discard single cell merge ranges when reading (stupid that Excel allows
them in the first place)
* Discard hidden autoFilter named ranges
- Version 1.7.7
* Support for Rich-Text in PHPExcel_Writer_Excel5
* OOCalc cells contain same data bug?
* listWorksheetInfo() method added to Readers... courtesy of Christopher
Mullins
* Options for cell caching using Igbinary and SQLite/SQlite3.
* Additional row iterator options: allow a start row to be defined in the
constructor; seek(), and prev() methods added.
* Implement document properties in Excel5 writer
* Implement chart functionality (EXPERIMENTAL)
- Initial definition of chart objects.
- Reading Chart definitions through the Excel2007 Reader
- Facility to render charts to images using the 3rd-party jpgraph library
- Writing Charts using the Excel2007 Writer
* Fix to build to ensure that Examples are included with the documentation
* Reduce cell caching overhead using dirty flag to ensure that cells are only
rewritten to the cache if they have actually been changed
* Improved memory usage in CSV Writer
* Improved speed and memory usage in Excel5 Writer
* Experimental - getHighestDataRow(), getHighestRowAndColumn() and
calculateWorksheetDataDimension() methods for the worksheet that return the
highest row and column that have cell records
* Change iterators to implement Iterator rather than extend CachingIterator,
as a fix for PHP 5.4. changes in SPL
* Invalid cell coordinate in Autofilter for Excel2007 Writer
* PCLZip library issue
* Excel2007 Reader canRead function bug 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
* ini_set() call in Calculation class destructor
* RangeToArray strange array keys
* INDIRECT() function doesn\'t work with named ranges
* Locale-specific fix to text functions when passing a boolean argument
instead of a string
* reader/CSV fails on this file auto_detect_line_endings now set in CSV
reader
* $arguments improperly used in CachedObjectStorage/PHPTemp.php
Bug In Cache System (cell reference when throwing caching errors)
* PHP Invalid index notice on writing excel file when active sheet has been
deleted
* External links in Excel2010 files cause Fatal error
* Previous calculation engine error conditions trigger cyclic reference
errors
* PHPExcel_Style::applyFromArray() returns null rather than style object in
advanced mode
* Cell::getFormattedValue returns RichText object instead of string
Indexed colors do not refer to Excel\'s indexed colors?
* Indexed colors should be consistent with Excel and start from 1 (current
index starts at 0)
* Named Range definition in .xls when sheet reeference is quote wrapped
* duplicateStyle() method doesn\'t duplicate conditional formats
* method for duplicating conditional styles
* =sumproduct(A,B) <> =sumproduct(B,A) in xlsx
* Support for Rich-Text in PHPExcel_Writer_Excel5
* Two easy to fix Issues concerning PHPExcel_Token_Stack (l10n/UC)
* Locale file paths not fit for windows
* Add file directory as a cache option for cache_to_discISAM
* Datatype.php & constant TYPE_NULL
* Ensure use of system temp directory for all temporary work files, unless
explicitly specified
* [Patch] faster stringFromColumnIndex()
* Fix for projects that still use old autoloaders
* Unknown codepage: 10007 Additional Mac codepages
Sat Apr 14 14:00:00 2012 jweberhoferAATTweberhofer.at
- Fix requirements for non-suse based distributions
Sat Apr 14 14:00:00 2012 jweberhoferAATTweberhofer.at
- Fix for environments where there is no access to /tmp but to upload_tmp_dir
See: http://phpexcel.codeplex.com/workitem/17840
Mon Dec 5 13:00:00 2011 jweberhoferAATTweberhofer.at
- Improved Provide/Obsoletes section
Fri May 20 14:00:00 2011 opendevelAATTweberhofer.at
- package version 1.7.6
- Fixed Fedora-based Require issue
- Fixed some dependency issues
