Revision history for Perl module Spreadsheet::ParseExcel.
0.59 April 6 2011
+ Patch for decryption of default encrypted workbooks from Alexey Mazurin.
! Fix for invalid formatting of text cell that are numeric. http://rt.cpan.org/Public/Bug/Display.html?id=62073
0.58 September 17 2010
! Fix for text cells formatted with a leading apostrophe. http://rt.cpan.org/Public/Bug/Display.html?id=61299
! Documentation fixes. Thanks to Dan Dascalescu
Fix RT #61320 (typos)
http://rt.cpan.org/Public/Bug/Display.html?id=61320
! Fix for currency locales in format strings.
Reported by wjaguar.
http://rt.cpan.org/Public/Bug/Display.html?id=60547
! Fix for incomplete SETUP records. Reported by M.C. Deurloo.
0.57 January 24 2010
! Added fix for reading formatted data from Excel 4 files.
! Added example programs, a_simple_parser.pl and display_text_table.pl.
! Removed Build.PL from README. Thanks Ed Avis. https://rt.cpan.org/Ticket/Display.html?id=52670
0.56 November 9 2009
+ Added error() and error_code() error handling routines.
This allows encrypted files to be ignored.
Added t/10_error_codes.t for the above methods.
http://rt.cpan.org/Public/Bug/Display.html?id=51033
http://rt.cpan.org/Public/Bug/Display.html?id=47978
! Made version 0.19 of OLE::Storage_Lite a prerequisite to avoid issues when writing OLE header in SaveParser.
! Changed Parse() method name to parse() for consistency with the
rest of the API. The older method name is still supported but
not documented.
0.55 August 25 2009
+ Refactored Cell.pm documentation and method names and added regression suite, t/06_regression.t.
! Added float comparison test to avoid false failing tests on 64bit systems.
0.54 August 25 2009
! Fix for height/width of hidden rows/columns with additional.
tests in 05_regression.t. Thanks to Greger Leijonhufvud.
http://rt.cpan.org/Public/Bug/Display.html?id=48450
! Fix for mal-formed Print_Title Name block. Reported by Marc Elser.
0.53 August 24 2009
+ Made perl 5.8.0 a requirement for proper Unicode handling.
! Fixed minor int2col() bug thanks to David Black.
Added 28_int2col.t test for above.
http://rt.cpan.org/Public/Bug/Display.html?id=48967
+ Refactored Workbook API and docs.
0.52 August 21 2009
+ Added new FmtJapan module and tests written by Goro Fuji.
! Fixed bug in ExcelFmt() date handling where conversion to weekday
and month names wasn't handled correctly.
Add extra tests to 21_number_format_user.t for above.
! Fixed bug when checking $Config{useperlio}.
Reported by kbates and H.Merijn Brand.
http://rt.cpan.org/Public/Bug/Display.html?id=28861
! Fixed bug where CellHandler variables weren't scoped to package.
Reported by pomoxp.
http://rt.cpan.org/Public/Bug/Display.html?id=43250
+ Added tests for ExcelLocaltime() and LocaltimeExcel(). 26_localtime2excel.t and 27_localtime2excel.t.
+ Refactored SaveParser docs. Work still ongoing.
0.51 August 19 2009
! Added fix for incorrectly skipped charts. Thanks Guntram Blohm. https://rt.cpan.org/Ticket/Display.html?id=44009
! Added fix for locale [$-ddd] strings in number formats.
Reported by Jeff Mitchell.
https://rt.cpan.org/Ticket/Display.html?id=43638
! Added fix for multiple dots in number formats.
Thanks to Father Chrysostomos.
http://rt.cpan.org/Public/Bug/Display.html?id=45502
! Added fix to make half way rounding behave like Excel.
Thanks to Joshua Megerman.
http://rt.cpan.org/Public/Bug/Display.html?id=45626
! Added checks for valid dates in Utility::ExcelFmt.
Reported by Alan James.
http://rt.cpan.org/Public/Bug/Display.html?id=48831
0.50 August 18 2009
+ Refactored Worksheet interface and documentation. Added 04_regression.t and 05_regression.t to test above changes.
! Fixed column units conversion.
Added 24_row_col_sizes.t for above change.
! Fixed RK number conversion. The existing code was the source of several RT bugs and portability issues. Added 25_decode_rk_numbers.t testcase.
0.49 January 24 2009
! Added Text::CSV_XS to xls2csv() function to handle embedded commas
in csv data. Reported by Fredrik Linde.
http://rt.cpan.org/Public/Bug/Display.html?id=41337
+ Rewrote Utility.pm documentation.
0.48 January 23 2009
! Fixed bug where numbers with uppercase formats such as MM/DD/YY
were ignored. Applies to files created by OpenOffice.org and
some international versions of Excel. Added tests for above.
http://rt.cpan.org/Public/Bug/Display.html?id=20526
http://rt.cpan.org/Public/Bug/Display.html?id=31206
http://rt.cpan.org/Public/Bug/Display.html?id=40307
! Removed undocumented and counter-intuitive use of overload on SheetNo in
Worksheet.pm.
http://rt.cpan.org/Public/Bug/Display.html?id=14278
0.47 January 22 2009
! Fixed bug where multiple embedded charts on a worksheet caused the
worksheet order to be lost and data to get overwritten.
Reported by Steven Martin and others.
http://rt.cpan.org/Public/Bug/Display.html?id=13365
0.46 January 18 2009
! Heavily refactored the ExcelFmt() function for maintainability and
fixed several bugs, in particular for 12 hour clock times.
Added test cases for above.
! Removed use of $& match variables from ExcelFmt.
Reported by Aaron Wigley.
http://rt.cpan.org/Public/Bug/Display.html?id=42425
! Replaced lvalue substr() in ExcelFmt () with 4-arg substr()
for efficiency. Reported by Goro Fuji.
http://rt.cpan.org/Public/Bug/Display.html?id=42518
! Removed spurious t/examples dir from Makefile.PL and removed
unused t/lib dir. Reported by Peter (Stig) Edwards.
http://rt.cpan.org/Public/Bug/Display.html?id=42442
0.45 January 13 2009
! Fixed failed parsing of large (8-16k) Unicode strings.
Reported by Graham Stead and Moka.
http://rt.cpan.org/Public/Bug/Display.html?id=41813
http://rt.cpan.org/Public/Bug/Display.html?id=35678
! Fixed critical bug where data rows could be ignored.
Reported and isolated by Peter (Stig) Edwards.
http://rt.cpan.org/Public/Bug/Display.html?id=30677
0.44 January 8 2009
! Fix for OpenOffice.org GENERAL format.
http://rt.cpan.org/Public/Bug/Display.html?id=7206
Thanks to Niko Tyni and the Debian Perl team
+ Perltidyed source and added standard headers and Pod sections to all modules.
0.43 January 7 2009
+ Restructured and rewrote the main documentation. This is the start of
a general refactoring. If you would like to keep up to date with it
keep an eye on the Spreadsheet::ParseExcel Google Group.
http://groups.google.com/group/spreadsheet-parseexcel
+ Added worksheets() Workbook method to iterate over the Worksheet objects.
+ Added unformatted() method to get a Cell's unformatted value.
+ Renamed public methods RowRange(), ColRange() and Cell() to row_range(), col_range() and get_cell(). Old methods are still available.
! Turned on compatibility_mode() by default in SaveParser to avoid SP3 problems.
! Fixed minor SaveParser bug with font rotation. http://rt.cpan.org/Public/Bug/Display.html?id=41626
0.42 January 1 2009
+ Fix for world writeable files in distro to allow PAUSE indexing.
0.41 October 24 2008
+ Changed maintainership to John McNamara.
! Fixed bug when parsing RK numbers (generally ints or small floats). http://rt.cpan.org/Public/Bug/Display.html?id=39892
! Changed margin units to inches to (cleanly) avoid undef warning in SaveParser.
0.33 2008.09.07
0.32 2007.05.05
0.31 2007.05.03
0.30 2007.03.31
0.29 2007.03.30
0.28 Wed Jan 7, 2007
0.27 Wed Jan 3, 2007
0.27_03 Thu Nov 2, 2006
0.27_02
0.27_01 Mon Sep 11, 2006
0.2603 Mon May 30, 2004
adding Protect feature (Thank you, Eduardo J for patch)
adding GetContent (Thank you, C. Jon Larsen)
0.2602 Mon Jul 15, 2002
(Thank you, HIROSHIGE,Shigeru for report)
0.2601 Sat Jul 13, 2002
Thank you for Peter Marschall for PATCH.
(Thank you, RT? for report)
(Thank you, HIROSHIGE,Shigeru for report)
(Thank you, Khalid EZZARAOUI for new code)
0.26 Sat Jun 1, 2002
Thank you for Peter Marschall.
0.25 Fri May 10, 2002
Add page setting Add some documents
0.2407 Mon Apr 24, 2002
(Thank you, Jeff Shaffer for report) Fix MakeBun
(Thank you, Tuneyosi Fukusima for report) : Add {Val} in sample :-)
(Thank you, Ernst Kloppenburg for suggestion)
0.2406 Mon Apr 8, 2002
(Thank you for Xavier Catteau for patch) Add col2int int2col sheetRef xls2csv (Thank you for Xavier Catteau for patch)
0.2405 Tue Jan 29, 2002
(Thank you Marc Pohl for report)
(Thank you Nicholas Hamlin and Abe Daisuke for reports) Fix PrintArea detection (Thank you Todd A. Green for patch) Add custom palette support (Thank you Florian Pflug for patch) Fix _SetDimension prototype (Thank you David Dyck for patch)
(Thank you Iceman for patch)
(Thank you Stanislav Sukholet for patch)
0.2404 Tue Jul 24 7:30:00 2001 - Tue Dec 4 11:00:00 2001
(Thank you, Mikhail Turenko) : Add GLOB reference support
(Thank you, coral.) : Fix/Add Font name Unicode judge
(Thank you, Mikhail Turenko, Alex Edelman)
(Thank you, Bruno Wolff III. And sorry for TOO LATE) : Fix add number expressions
(Thank you, Jing Zhao)
0.2403 Tue Jul 24 7:30:00 2001
(Thank you, Jeremy Smartt)
0.2402 Thu Jul 12 20:30:00 2001
(Thank you, Kevin Ko)
0.2401 Mon Jul 9 19:00:00 2001
(Thank you, Kevin Ko) Sorry, it is not effective (ToT)
0.24 Wed Jul 5 06:30:00 2001
(Thank you, Ilya Sterin)
(Thank you, Maxime Alechine)
0.2301 Tue Jun 26 8:00:00 2001
:Fix not convert undefined or '' string
0.23 Thu Jun 21 21:00:00 2001
:Fix Unicode Latin1 adapt
(Thank you, Seiko Yamamura and Sadahiro)
(Thank you, Alex)
0.22.3 Thu May 16 8:00:00 2001
(Thank you, Dmitriy Litovchin)
0.22.2 Thu May 16 8:00:00 2001
(Thank you, Maxim Ovchinnikov)
0.22.1 Wed May 14 20:35:00 2001
(Thank you, Steve Sapovits) : Fix ignore Graph sheet (Thank you, Joel Defarge )
(Thank you, Alok K. Dhir)
0.22 Sat May 5 19:00:00 2001
0.21.2 Tue May 1 7:00:00 2001
(Thank you, Bradley M. Handy )
0.21.1 Sat Apr 29 14:00:00 2001
(Thank you, Vladimir Igrevsky)
0.21 Sat Apr 24 18:00:00 2001
(Thank you, Jeff Clark)
: Expanding format information to support (Supported by Nippon-RAD OP Division)
0.20.2 Wed Apr 18 9:00:00 2001
(Thank you, Jeff Clark)
0.20.1 Sun Apr 11 9:00:00 2001
(Thank you, Fukusima, Tuneyosi)
0.20 Mon Mar 30 20:00:00 2001
(Thank you, Morten Sickel)
(Thank you, Vladimir Igrevsky)
(Thank you, Fukusima, Tuneyosi)
(Thank you, Venkataramana Mokkapati)
0.19 Mon Mar 26 12:00:00 2001
(Thank you, Morten Sickel)
(Thank you, yusuf_najuddin)
(Thank you, Kawasaki)
0.18 Sat Mar 18 16:00:00 2001
(Thank you, yusuf_najmuddin)
0.17 Wed Mar 12 9:00:00 2001
(Thank you, Kawasaki)
(Thank you, John Dawson)
0.16 Wed Mar 7 22:00:00 2001
(Thank you Jimmy Sieben and Daniel Berger)
0.15 Wed Mar 6 10:00:00 2001
(Thank you Jimmy Sieben)
0.13 Sat Feb 21 20:40:00 2001
(Thank you, Punam Chordia )
(Thank you, Aldo Calpini)
(Thank you, Tim Wills)
0.12 Sat Feb 5 11:00:00 2001
(Thank you, Jeff Haferman)
(Thank you, Alfred Nathaniel)
0.11 Sat Jan 26 14:00:00 2001
0.10 Mon Jan 15 12:00:00 2001
0.09 Sat Dec 15 12:00:00 2000
0.08 Sat Nov 25 12:00:00 2000
0.07 Sat Nov 18 12:00:00 2000
0.05 Mon Oct 2 03:14:04 2000