summaryrefslogtreecommitdiff
path: root/archivers
diff options
context:
space:
mode:
authormjl <mjl>2003-04-25 17:18:45 +0000
committermjl <mjl>2003-04-25 17:18:45 +0000
commitac908b13b68c3fbd1e49084aace016178e3c168e (patch)
tree77ef5d5aa228ac1cd13e5275fcea0c09aa547b75 /archivers
parent9230a7a690e877094c9c6da6c710e80e2608f6a7 (diff)
downloadpkgsrc-ac908b13b68c3fbd1e49084aace016178e3c168e.tar.gz
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.
Diffstat (limited to 'archivers')
0 files changed, 0 insertions, 0 deletions