Path to this page:
Subject: CVS commit: pkgsrc/math/p5-Spreadsheet-WriteExcel
From: Martin J. Laubach
Date: 2003-04-25 19:18:45
Message id: 20030425171845.91BDFB004@cvs.netbsd.org
Log Message:
Update p5-Spreadsheet-WriteExcel to 0.41
+ Added facility for adding outlines to worksheets. Added
outline.pl example.
+ 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.
! Fixed handling of column sizing for widths less than 1 unit.
! Renamed addworksheet() and addformat() to add_worksheet()
and add_format() for consistency with other method names.
Older names are supported but deprecated.
! Fixed internal sheet indexing in formulas on some platforms.
This caused multi-sheet workbooks with formulas to crash.
! Fixed non-lexical filehandles to prevent problems in
multi-threaded environments.
+ 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.
! Fixed the non-deletion of temporary files. Users of version
0.38 should probably clean up their tmp dirs manually.
! 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.
+ Added formula caching to speed up the writing of formulas.
+ 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.
! 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.
! Fixed minor bugs in Format.pm. Thanks Johann Hanne.
! Fixed File::Temp dependency in Makefile. Thanks to many.
+ Added set_tempdir() method to allow a user defined temp directory.
+ 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.
+ Added user definable colour palette.
+ Added headers.pl and colors.pl examples.
Files: