summaryrefslogtreecommitdiff
path: root/math/p5-Spreadsheet-WriteExcel
diff options
context:
space:
mode:
authormjl <mjl@pkgsrc.org>2003-04-25 17:18:45 +0000
committermjl <mjl@pkgsrc.org>2003-04-25 17:18:45 +0000
commit38456b0ddccfbf2c59aac217d9947f49a1a9bb05 (patch)
tree77ef5d5aa228ac1cd13e5275fcea0c09aa547b75 /math/p5-Spreadsheet-WriteExcel
parent3cc9d02e6217e7646df71c01c955aa65571b6f1a (diff)
downloadpkgsrc-38456b0ddccfbf2c59aac217d9947f49a1a9bb05.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 'math/p5-Spreadsheet-WriteExcel')
-rw-r--r--math/p5-Spreadsheet-WriteExcel/Makefile5
-rw-r--r--math/p5-Spreadsheet-WriteExcel/distinfo6
2 files changed, 6 insertions, 5 deletions
diff --git a/math/p5-Spreadsheet-WriteExcel/Makefile b/math/p5-Spreadsheet-WriteExcel/Makefile
index a8c7578cc66..5a58a5766d7 100644
--- a/math/p5-Spreadsheet-WriteExcel/Makefile
+++ b/math/p5-Spreadsheet-WriteExcel/Makefile
@@ -1,7 +1,7 @@
-# $NetBSD: Makefile,v 1.2 2002/10/20 17:46:05 seb Exp $
+# $NetBSD: Makefile,v 1.3 2003/04/25 17:18:45 mjl Exp $
#
-DISTNAME= Spreadsheet-WriteExcel-0.35
+DISTNAME= Spreadsheet-WriteExcel-0.41
PKGNAME= p5-${DISTNAME}
CATEGORIES= math perl5
MASTER_SITES= ${MASTER_SITE_PERL_CPAN:=../../authors/id/J/JM/JMCNAMARA/}
@@ -10,6 +10,7 @@ MAINTAINER= packages@netbsd.org
COMMENT= Create Excel data files
DEPENDS+= p5-Parse-RecDescent-*:../../devel/p5-Parse-RecDescent
+DEPENDS+= p5-File-Temp-*:../../devel/p5-File-Temp
USE_BUILDLINK2= YES
PERL5_PACKLIST= ${PERL5_SITEARCH}/auto/Spreadsheet/WriteExcel/.packlist
diff --git a/math/p5-Spreadsheet-WriteExcel/distinfo b/math/p5-Spreadsheet-WriteExcel/distinfo
index 33a7280ff5b..b555ad294f2 100644
--- a/math/p5-Spreadsheet-WriteExcel/distinfo
+++ b/math/p5-Spreadsheet-WriteExcel/distinfo
@@ -1,4 +1,4 @@
-$NetBSD: distinfo,v 1.2 2002/07/02 12:59:08 wiz Exp $
+$NetBSD: distinfo,v 1.3 2003/04/25 17:18:45 mjl Exp $
-SHA1 (Spreadsheet-WriteExcel-0.35.tar.gz) = 2e81697fc2f07e246dc8c3e13a7007a135fa03c4
-Size (Spreadsheet-WriteExcel-0.35.tar.gz) = 371712 bytes
+SHA1 (Spreadsheet-WriteExcel-0.41.tar.gz) = b507b6e62f1c5f0c5450d0f3b9a3936ead88f09c
+Size (Spreadsheet-WriteExcel-0.41.tar.gz) = 412049 bytes