Top Level :: File Formats

Package Information: Spreadsheet_Excel_Writer

Show All Changelogs
» Version » Information
0.9.1Download

Release date: 2006-09-26 18:22 UTC
Release state: beta

Changelog:

Bug fixes:
- Fixed Bug #6509, Object of class Spreadsheet_Excel_Writer_Format could not be converted to int (Christian Schmidt)
- Fixed Bug #7840, Notices on default formats (Christian Schmidt)

Dependencies:
  • PEAR Package: OLE 0.5 or newer
  • PHP Version: PHP 4.1.0 or newer
0.9.0Download

Release date: 2005-11-22 03:11 UTC
Release state: beta

Changelog:

New features:
- adding new methods Format::setVAlign() and Format::setHAlign()
- adding support for uncapitalized functions in formulas (ej: "=sum(B27:B31)")
- adding support for different charsets with method Worksheet::setInputEncoding()
- adding support for sheetnames longer than 31 chars when using setVersion(8).
Bug fixes:
- Fixed Bug #1796, wrong regular expression in _writeUrlInternal
- Fixed Bug #2363, wrong export filename with spaces
- Fixed Bug #2425, Error using writeFormula with Now() and TODAY()
- Fixed Bug #2876, German Umlauts destroy sheet references
- Fixed Bug #1706, Formulas refer to other Worksheets with "spezial" names don't work
- Fixed Bug #2748, setMargins(), setHeader() and setFooter() work in excel but not in openoffice.
- Fixed Bug #5698, preg_replace in _writeUrlInternal
- Fixed Bug #2823, Inpropper results from writeUrl() method

Dependencies:
  • PEAR Package: OLE 0.5 or newer
  • PHP Version: PHP 4.1.0 or newer
0.8Download

Release date: 2004-06-22 23:34 UTC
Release state: beta

Changelog:

New features:
- added hideScreenGridlines() (Paul Osman)
Bug fixes:
- Fixed SST table (long strings) (Bernd Jaenichen)
- Fixed bug #1218, SST table (boucher dot stephane at free dot fr)
- Fixed bug #781, insertBitmap ignores row height
- Fixed bug #578, setVPageBreaks doesn't handle multiple value arrays (natel at tocquigny dot com)

Dependencies:
  • PEAR Package: OLE 0.5 or newer
0.7Download

Release date: 2004-02-27 22:31 UTC
Release state: beta

Changelog:

New features:
- allow setting temp dir other than default using setTempDir() (using OLE 5.0 for this).
- added setMerge() for merging (only for experimental Excel97 generation)
- added setCountry() method.
- added setLocked() method.
Bug fixes:
- Fixed bug #415, typo in BIFF8 code (papercrane at reversefold dot com)

Dependencies:
  • PEAR Package: OLE 0.5 or newer
0.6Download

Release date: 2003-11-15 20:37 UTC
Release state: beta

Changelog:

New features:
- allow semicolon as argument separator (Axel Pratzner)
- added experimental Excel97 generation. You can test it with setVersion():
Beware! this method will be deprecated in a future release (when
Excel97 becomes the default). It is only available for testing
purposes. Use it at your own risk.
- strings longer than 255 bytes are now available using the experimental
Excel97 generation. But not all Excel97 features are available yet!
Bug fixes:
- Fixed bug #225, error in writeUrl() (jamesn at tocquigny dot com)
- Fixed bug #59, retval undefined for writeRow() (Bertrand)

Dependencies:
  • PEAR Package: OLE 0.3 or newer
0.5Download

Release date: 2003-10-01 19:56 UTC
Release state: beta

Changelog:

New features:
-added rowcolToCell() utility method for easy writing of formula's cell references (JT Hughes).
-added Worksheet::setOutline() method (Herman Kuiper)
-added Format::setFontFamily() method (Donnie Miller)
Bug fixes:
-fixed bug #21, cyrillic characters in sheet references (arhip at goldentele dot com)

Dependencies:
  • PEAR Package: OLE 0.3 or newer
0.4Download

Release date: 2003-08-24 22:23 UTC
Release state: beta

Changelog:

New features:
-using OLE package to generate files bigger than 7MB
-changed setFgColor() and setBgColor()'s behavior to something more intuitive.
Bug fixes:
-fixed bug #25133, lowercase cell references (jkwiat03 at hotmail dot com)
-fixed Bug #23730, worksheet names containing spaces in formulas (Robin Ericsson)
-fixed Bug #24147, formulas ended in '0' (paul at classical dot com)
-fixed swapping of arguments in variable arguments functions (JT Hughes)

Dependencies:
  • PEAR Package: OLE 0.3 or newer
0.3Download

Release date: 2003-05-03 01:33 UTC
Release state: beta

Changelog:

New features:
-added support for row ranges (JT Hughes)
-added method Format::setUnLocked() (Ajit Dixit)
-added Worksheet::writeRow() and Worksheet::writeCol()
Bug fixes:
-fixed problem with unparenthesized expresions in formulas (Brent Laminack)
-fixed problems with non ISO-8859-1 characters (KUBO Atsuhiro)
-fixed swapping of columns in formulas (JT Hughes)
-fixed assorted bugs in tokenizing formulas (JT Hughes)
-fixed Worksheet::activate() (JT Hughes)

0.2Download

Release date: 2003-03-18 05:32 UTC
Release state: beta

Changelog:

-added several formatting methods: setTextRotation(), setStrikeOut(),
setOutLine(), setShadow(), setScript().
-fixed bug in Workbook::sheets() (Björn Schotte).
-fixed range for references in formulas (Edward).
-added support for external references in formulas.
-added support for comparisons in formulas.
-added support for strings in formulas.

0.1Download

Release date: 2003-01-03 17:45 UTC
Release state: devel

Changelog:

This is the initial release of the package.