Revision history for Perl module Spreadsheet::WriteExcel.

0.41 April 24 2003 - Minor

    + Added facility for adding outlines to worksheets. Added example. Thanks to Franco Venturi.

    + Moved write_comment() code into the core modules. It is now
      possible to write cell comments.

    + Added option to return a slice from the sheets() method.
    + Added link to latest Excel97 pre-release.    

    ! Changed, once more, the handling of temp files to avoid several
      file closing bugs. Thanks to many.

    ! Fixed handling of column sizing for widths less than 1 unit.
      Thanks Rubio.

    ! Renamed addworksheet() and addformat() to add_worksheet()
      and add_format() for consistency with other method names.
      Older names are supported but deprecated.

0.40 December 21 2002 - Minor

    ! Fixed internal sheet indexing in formulas on some platforms.
      This caused multi-sheet workbooks with formulas to crash.
      Thanks Troy Daniels.

    ! Fixed non-lexical filehandles to prevent problems in
      multi-threaded environments.
      Thanks Ning Xie.

0.39 September 23 2002 - Minor

    + Added the set_codepage() workbook method. This is mainly to
      prevent a bug that caused Gnumeric to crash but it is also
      useful for people working with non ascii chars on the Macintosh.
      Thanks Jody Goldberg.

    ! Fixed the non-deletion of temporary files. Users of version
      0.38 should probably clean up their tmp dirs manually.
      Thanks Pierre Laplante.

    ! Changed default handling of set_fg_color and set_bg_color from
      what Excel expected to what everyone else expected. Setting the
      fill colour of a cell should now be more intuitive.

    + Replaced the merge_cells() method with the merge_range() method.
      This is mainly to prevent the Excel 97 crashing bug that occurs
      when merge_cells() is used correctly. It also provide a simpler
      interface to the merge feature. Updated merge example programs.

    ! Refactored the error raising mechanism for formulas. The source
      of errors should now be clearer.

    ! Minor internal fixes to

0.38 August 29 2002 - Minor

    + Added formula caching to speed up the writing of formulas.
      Thanks to Ron McKelvey.

    + Added handling of A:A column notation in formulas and
      applicable worksheet methods.

    + Changed handling of numbers with leading zeroes so that they
      can be treated as strings and the zeroes maintained.

    + Modified $workbook->close() to return the value of the system
      file close.

    + Made file size exceeded a die() error instead of a warning.

    + Added option to hide row with the set_row() method

    + Added more examples:,, and

    ! Fixed write_url() when handling relative links in the current
      directory. Thanks Bob Mackay Andre de Bruin

    ! Fixed handling of multiple AND()'s and OR()'s in formulas.

    ! Fixed bug when creating a very large number of files within a
      single program on Windows.

    ! Added warning about Excel97 crashing bug with merge_cells().

    ! Fixed handling of parentheses in Worksheet names.
      Thanks Jann Linder.

    ! Fixed minor bugs in Thanks Johann Hanne.

    ! Fixed File::Temp dependency in Makefile. Thanks to many.

0.37 April 29 2002 - Minor

    + Added set_tempdir() method to allow a user defined temp
      directory. This is mainly of use to IIS users.

    + Fixed default format behaviour for formats set via the set_row()
      and set_column() methods.

    + Extended the hide_gridlines() method to allow hiding of screen
      gridlines as well as print gridlines.

    + Added a workaround example for the 255 char

    + Added https match to url regex. Thanks The Tilghman.

0.36 April 9 2002 - Minor

    + Added user definable colour palette. Thanks Bill Young.

    + Added and examples.

0.35 March 18 2002 - Minor

    + Added internal and external hyperlinks. Thanks Ian Penman.

    + Added worksheet set_zoom() and set_print_scale().

    ! Changed default value of fit_to_pages() to allow printed output
      to be one page wide and as long as required.
      Thanks Michael Erickson.

    ! Changed handling of undefs in write() method. Thanks Hanc Pavel.

    ! Changed new() to return undef for file creation errors
      Thanks Felipe PĂ©rez Galiana.

    ! Added check for header/footer length. Thanks Peter Dintelmann.

    ! Added check for duplicate worksheet names. Thanks Keith Miller.

    - Removed spurious return() to fix bug in set_repeat_rows().
      Thanks Brian White.

    ! Added "use integer" when using shift << to avoid bug with
	  Perl 5.6.0 on HP-UX. Thanks Markus Schmitz, VSarkiss.

    ! Fixed minor bug in Thanks Sven Passig.

0.34 October 23 2001 - Major

    + Added Spreadsheet::WriteExcel::Utility module with helper
      functions for row/col and dates.

    + Added write_row and write_col methods after many requests.

    + Added ability to insert bitmap images.

    + Added cell protection and formula hiding.

    + Added more examples.

0.33 July 30 2001 - Minor

    + Added (hopefully) easier mechanism to add format properties.

    + Added more page setup options: repeat rows and columns, hide
      gridlines, print area, fit to pages and page breaks.

    ! Added fix to protect print() from -l on the command line.
      Thanks Cedric Bouvier and Kyle Krom.

    + Added more examples.

0.32 May 17 2001 - Minor

    + Added panes option.

    + Added page setup options: paper type, orientation, headers
      footers, centering.

    + Added panes example.

0.31 April 12 2001 - Major

    ! Fixed several minor and major bugs in
      Thanks Shane Ashby and Borgar Olsen and Christian Kirsch.

    + Added external worksheet references to formulas.

    + Added A1 notation.

    + Added facility to new() to accept valid filehandles.
      Thanks  Peter Dintelmann.

    + Added more examples. Thanks Tom O'Sullivan.

    ! Updated example. Thanks to Takanori Kawai.

0.30 Feb 26 2001 - Major

    + Added formulas.

    ! Fixed docs for write_url(). Thanks James Holmes.

    ! Fixed bug when using a numeric format string of zeros.
      Thanks Kenneth Stacey.

0.26 Feb 1 2001 - Minor

    ! Fixed bug when using a border with the default colour. This
      caused the cell format to become unchangeable from within Excel.
      Thanks Shenyu Zheng.

    ! Changed worksheet code to automatically fall back to storing
      data in memory if opening a tmp file fails.

0.25 Jan 19 2001 - Minor

    ! Changed distro file format back to Unix line endings. The
      accidental DOS format was causing install problems.

0.24 Jan 14 2001 - Minor

    + Added write_url method.

    + Added set_merge() alias for set_align('merge') method.

    + Added warnings about deprecated code when running under -w flag.

    ! Documentation changes.

0.23 Dec 10 2000 - Minor

    + Added customisable numeric formats.

    + Added set_row() method.

    + Added set_1904() method.

    + Added extra examples including contributions. Thanks to all.

    + Moved secondary modules to WriteExcel namespace to clean-up
      Spreadsheet namespace which is now shared with ParseExcel.

    ! Fixed class data bug. Thanks Cedric Bouvier.

    ! Fixed Excel crashing!! bug in STYLE. Thanks Rich Sorden.

    ! Tidied up internal storage of FONTs and XFs.

    + Renamed set_col_width() method to set_column().

    + Renamed set_format() method to set_num_format().

0.22 Oct 22 2000 - Major

    + Added and the facility for cell formatting.

0.21 Oct 1 2000 - Minor

    + Replaced direct access to worksheets array with a workbook

    + Added set_selection() and set_col_width() worksheet methods.

    ! Replaced the missing thats, including the that that were
      in the icebox.

    + Added MS Access bug warning; thanks Harold Bamford.

0.20 Aug 27 2000 - Major

    + Added multiple worksheets and OLE wrapper. Now compatible with
      Star Office, Gnumeric and XESS.

0.11 Aug 25 2000 - Minor

    ! Changes to documentation. Explanation of how to use WriteExcel
      in CGI's. Thanks Daniel Gardner.

0.10 May 13 2000 - Minor

    ! Bug in close() and DESTROY sequence fixed. Thanks John Wren.

    ! Biff version number fixed. Thanks Aurthur@ais, and then unfixed.

    ! Shakey test and distro fixed. Thanks to many.

0.09 Feb 1 2000 - Minor

    ! Code for writing DIMENSIONS updated to account for bug when
      reading files with QuickView.

    + Renamed xl_write methods to write.

0.08 Jan 16 2000

    First CPAN release. Spreadsheet::WriteExcel - Write text and
    numbers to minimal Excel binary file.