Subject: PR/30934 CVS commit: pkgsrc/math/p5-Spreadsheet-WriteExcel
To: None <pkg-manager@netbsd.org, gnats-admin@netbsd.org,>
From: Thomas Klausner <wiz@netbsd.org>
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 <wiz@netbsd.org>
To: gnats-bugs@netbsd.org
Cc: 
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 merge6.pl 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 comments1.pl and comments2.pl 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
       http://rt.cpan.org/NoAuth/Bug.html?id=14094
       http://www.openoffice.org/issues/show_bug.cgi?id=52955
 
     ! 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 formula_result.pl 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 Format.pm 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:
       add_worksheet()
       set_header()
       set_footer()
       set_font()
       set_num_format()
 
     + Added unicode_cyrillic.pl 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 Chart.pm 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 date_time.pl 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 write_to_scalar.pl 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 CPAN.pm happy.
       Thanks to David Dyck.
 
     + Minor changes to demo.pl merge5.pl 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.
 
     DUE TO THE MAJOR INTERNAL CHANGES IT IS RECOMMENDED THAT YOU TEST
     THIS UPGRADE FULLY BEFORE DEPLOYING IT.
 
     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 OpenOffice.org support.
 
     + Added more examples: diag_border.pl, indent.pl,
       unicode.pl, unicode_japan.pl, unicode_list.pl
 
     + 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 OpenOffice.org.
 
     ! 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.