Subject: PR/30934 CVS commit: pkgsrc/math/p5-Spreadsheet-WriteExcel
To: None <,,>
From: Thomas Klausner <>
List: pkgsrc-bugs
Date: 03/08/2006 06:05:04
The following reply was made to PR pkg/30934; it has been noted by GNATS.

From: Thomas Klausner <>
Subject: PR/30934 CVS commit: pkgsrc/math/p5-Spreadsheet-WriteExcel
Date: Wed,  8 Mar 2006 06:04:59 +0000 (UTC)

 Module Name:	pkgsrc
 Committed By:	wiz
 Date:		Wed Mar  8 06:04:59 UTC 2006
 Modified Files:
 	pkgsrc/math/p5-Spreadsheet-WriteExcel: Makefile distinfo
 Log Message:
 Update to 2.16, provided by Mark E. Perkins in PR 30934:
 2.16 January 6 2005 - Major
     + Rewrote and reinstated the write_comment() method to take
       account of the changes in the Excel 97+ comment format.
       Currently conflicts with insert_bitmap(), see docs.
     + Added standard styles such as comma, percent and currency.
     ! Changed write_url() methods to allow numbers or formulas
       as well as strings as the optional text.
       Requested by many.
     + Documented use of encoding flag in add_worksheet() to allow
       handling of UTF-16 sheet names.
     + Added encoding flag to merge_range() method to allow
       handling of UTF-16 strings. Requested by many.
       Added example program.
     + Added hide_zero() worksheet method to allow hiding of zero
       values in cells.
     + Added print_across() worksheet method to allow changing of
       the default print direction.
     + Added right_to_left() worksheet method to allow changing of
       the default worksheet direction in eastern versions of Excel.
     + Documented the Worksheet hide() method.
     + Added and example programs.
     + Added tests for the internal methods used by write_comment().
 2.15 September 18 2005 - Minor
     ! Changed OLE container stream name from "Book" to "Workbook"
       for compatibility with some third party apps.
       Thanks Wieland Pusch and Kevin McMahon.
     ! Fixed bug that caused all worksheets to be selected in
       OpenOfficeOrg causing strange linking of data between
       Worksheets. Thanks  M. Brodbelt. See
     ! Changed file creation from end of program to the start of
       program in order to avoid race conditions and extra file
       creation on VMS.
     + Added optional user supplied results for formulas as a
       workaround for uncalcuated values in some non-Excel apps.
       Added example of above.
 2.14 May 9 2005 - Minor
     ! Fixed handling of Unicode font names.
 2.13 April 20 2005 - Minor
     ! Made it a fatal error to use a merged format in a non-
       merged cell (and vice-versa). This is a temporary measure
       to prevent people from shooting themselves in the foot
       until the code can be refactored.
     + Add 01_merge_formats.t test for above.
     + Added date_time tests.
 2.12 March 22 2005 - Minor
     + Added further Unicode support. The following methods now
       handle uft8 in perl 5.8:
     + Added example.
     + Added 01_add_worksheet.t test.
 2.11 September 30 2004 - Minor
     - Removed undocumented date_time handling from write() to
       avoid potential false matches.
     + Added add_write_handler() method to allow users to add
       their own data handlers to write().
     + Added 4 write_handler examples.
 2.10 September 23 2004 - Major
     + Added chart support via external templates.
       Added and add_chart_ext() method to Workbook object.
       Added /charts directory with examples and documentation
     + Added write_date_time() worksheet method for writing dates
       and times in Excel date format.
       Added example.
     + Added automatic Unicode handling via utf8 in perl 5.8 and
       later. Thanks Mark Fowler.
       Added several unicode_*.pl examples in different encodings.
       Thanks to Sean Burke for the sample encodings.
     + Added example in order to answer frequently
       asked question about writing an Excel file to a scalar.
 2.04 August 18 2004 - Minor
     ! Fixed handling of Euro symbol in num_format() strings.
     ! Renamed the Excel 5 style merge() format to the more correct
       center_across(). Updated examples accordingly.
     ! Added bug warning about using merge formats outside of
       merged ranges.
     + Fixed handling of doubled double quotes in formula strings.
       Thanks to a tip from merlyn.
     + The 2.xx versions are now compatible with MS Access. Removed
       statements to the contrary.
 2.03 July 4 2004 - Minor
     ! Fixed bug that prevented column outlines from displaying.
       Thanks to Marc Rosenthal.
     ! Enhanced add_worksheet() name checking to exclude case-
       insensitive duplicate names.
       Thanks to James Wilkinson.
     ! Internal fix to number of rows in several (unseen) places.
     + Added mod_perl 2 example program from Matisse Enzer. Thanks.
 2.02 May 28 2004 - Minor
     + Fixed internal version numbers to keep happy.
       Thanks to David Dyck.
     + Minor changes to and the html docs.
 2.01 May 27 2004 - Major
     This version is a MAJOR revision to Spreadsheet::WriteExcel. The
     format of the Excel file that it produces has been updated from
     Excel 5 to Excel 97. This allows support for long, 32k character
     strings and Unicode.
     Also note that this version can be 1.5 to 2 times slower than
     previous versions and the write_comment() method has been
     temporarily removed. These issues will be fixed in later releases.
     + Changed the default Excel format to Excel 97.
     + Added support for strings up to 32767 character.
     + Added support for Unicode strings.
     + Improved speed in relation to pre-release versions.
       However, it is still slower than the 1.xx versions.
     + Improved support.
     + Added more examples:,,,,
     + Changed the distro dir structure.
     - Temporarily removed write_comment() support since the Excel 5
       version isn't compatible with Excel 97+.
 1.01 May 24 2004 - Minor
     ! Small non-bug fix to write_comment().
 0.43 April 28 2004 - Minor
     ! Fixed longstanding bug where page setup features didn't
       show up in
     ! Fixed localised @_ bug when using threaded perls.
       Thanks Tamas Gulacsi and Stephan Loescher.
 0.42 August 26 2003 - Minor
     ! Fixed bug when using IO::Sclalar object as a filehandle.
       Thanks to Kyle R. Burton and David Robins.
     ! Fixed minor formula parser bug.
       Thanks Michael Braig
     ! Fixed handling of column sizing for widths less than 1
       unit (again). Thanks to Rubio (again).
     ! Failed new() returns undef instead of croak()ing as per docs.
 To generate a diff of this commit:
 cvs rdiff -r1.11 -r1.12 pkgsrc/math/p5-Spreadsheet-WriteExcel/Makefile
 cvs rdiff -r1.4 -r1.5 pkgsrc/math/p5-Spreadsheet-WriteExcel/distinfo
 Please note that diffs are not public domain; they are subject to the
 copyright notices on the relevant files.