Revision history for Perl module Spreadsheet::WriteExcel. 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. + Added link about Excel97/long string pre-release. http://freshmeat.net/projects/writeexcel/#comment-22753 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 Format.pm. 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: merge4.pl, merge5.pl, sendmail.pl and repeat.pl ! 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 Format.pm. 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 long_string.pl a workaround example for the 255 char limit. + Added https match to url regex. Thanks The Tilghman. 0.36 April 9 2002 - Minor + Added user definable colour palette. Thanks Bill Young. + Added headers.pl and colors.pl 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 Formula.pm. 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 Formula.pm. 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 bigfile.pl 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 Format.pm and the facility for cell formatting. 0.21 Oct 1 2000 - Minor + Replaced direct access to worksheets array with a workbook method;worksheets(). + 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.