Subject: CVS commit: pkgsrc/math/p5-Spreadsheet-WriteExcel
To: None <>
From: Martin J. Laubach <>
List: pkgsrc-changes
Date: 04/25/2003 17:18:45
Module Name:	pkgsrc
Committed By:	mjl
Date:		Fri Apr 25 17:18:45 UTC 2003

Modified Files:
	pkgsrc/math/p5-Spreadsheet-WriteExcel: Makefile distinfo

Log Message:
Update p5-Spreadsheet-WriteExcel to 0.41

    + Added facility for adding outlines to worksheets. Added 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
    + 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:,, and
    ! Fixed write_url() when handling relative links in the current
    ! 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 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 a workaround example for the 255 char
    + Added https match to url regex.
    + Added user definable colour palette.
    + Added and examples.

To generate a diff of this commit:
cvs rdiff -r1.2 -r1.3 pkgsrc/math/p5-Spreadsheet-WriteExcel/Makefile \

Please note that diffs are not public domain; they are subject to the
copyright notices on the relevant files.