The London Perl and Raku Workshop takes place on 26th Oct 2024. If your company depends on Perl, please consider sponsoring and/or attending.
HMBRAND / Spreadsheet-Read-0.38 / Changes 
Revision history for Spreadsheet::Read

0.38	Tue 15 Dec 2009

    - Add row () and cellrow ()
    - Updated META.yml to meet most recent specs (optional_features = map)

0.37	Mon 09 Nov 2009

    - IO streams improvements
    - MANIFEST fix

0.36	Thu 06 Nov 2009

    - Add strip option
    - Spreadsheet::XLSX 0.12 still does not support attributes
    - Require Text::CSV_XS-0.69 for CSV for auto-detection of \r
    - New attribute "parser" to force format
    - Allow CSV streams
    - Allow SC  streams
    - Allow XLS streams

0.35	Wed 03 Jun 2009

    - Add Test::NoWarnings, which is not run in AUTOMATED_TESTING
    - Switched to Test::More using tests_done ()
    - Text::CSV_XS requires 0.43 or up, as we use ->eof ()
      still prefer a really new release, like 0.65, which
      is Test::NoWarnings safe
    - Spreadsheet::XLSX 0.10 still does not support attributes
    - Added -n to xlscat
    - XLSX tests skip on feature, not on version

0.34	Tue 27 Jan 2009

    - Spreadsheet::XLSX 0.09 still does not support attributes
      still think it is better to follow closely. 0.09 is much
      better than 0.08

0.33	Fri 23 Jan 2009

    - A few Perl::Critic inspired changes
    - Modified tests to prevent rounding errors (we were not checking for that)
    - Added examples/ss-dups-tk.pl

0.32	Tue 06 Jan 2009

    - Add basic support for M$ Excel 2007 using Spreadsheet::XLSX
    - Test suite reports the parsers it found

0.31	Sun 04 Jan 2009

    - Upped Copyright notices to 2009
    - Detection of percentage type
    - Even more reliable detection of Date types

0.30	Mon 22 Dec 2008

    - Wrong e-mail in META.yml
    - CSV files from a Mac, with \r as eol, would not parse

0.29	Sun 19 Oct 2008

    - Make Read safer for files that do not match extension,
      like HTML in foo.xls
    - YAML declared 1.4 (META.yml) instead of 1.1 (YAML)
    - Bring Makefile.PL in sync with META.yml
    - Recommend Text-CSV-0.56

0.28	Wed 04 Sep 2008

    - More tests on date formats
    - Declare Spreadsheet::ParseExcel::FmtDefault in META.yml
    - Add 'size' from Excel font size
    - Update docs about Excel quirks and CPAN links
    - Reference to public git repo
    - Some typo's

0.27	Sun 31 Aug 2008

    - Fixed META.yml (the specs are inconsistent)
    - Added --dtfmt to xlscat

0.26	Fri 29 Aug 2008

    - Added examples/xls2csv
    - Upped copyright to 2008 in examples
    - Don't ask to install examples under automated testing
    - die => croak
    - Added tgzdist target
    - Added encoding options to examples/xlscat
    - Added date-type checks for SS:PE > 0.32

0.25	Wed 02 Jan 2008

    - Spreadsheet-Read now under git
    - Upped copyrights to 2008
    - Added all prereq's to Makefile.PL, even core mods
    - Tested under perl-5.10.0
    - Text::CSV as of 1.00 is OK

0.24	Thu 05 Oct 2007

    - -? and --help in utils moved to Getopt::Long
    - Adjusted copyright notice in utils
    - removed prototypes in utils
    - next is illegal in do {} while (); (Johan Vromans)
      only happens with old Text::CSV_XS

0.23	Thu 21 Jun 2007

    - Use IO::Scalar instead of File::Temp when installed
      Thanks to David Cantrell for making a OpenBSD test box available!
    - use binmode () when opening files
    - Also use 3-arg open in test files
    - die if test files cannot be opene'ed

0.22	Mon 18 Jun 2007

    - 0.21 should already support Text::CSV_PP 1.05
      Tested Text::CSV_PP 1.05 on bleadperl.
    - Better detection of (not) installed modules
    - Module requires perl 5.6.x

0.21	Mon 18 Jun 2007

    - Text::CSV_XS uses keep_meta_info instead of get_flags
    - Removed always_quote from xlscat's CSV output

0.20	Thu 31 May 2007

    - perlcritic OK
    - CSV parsing now uses getline (), and auto-detects eol
      Assumes first line does not contain embedded eol. This implies that
      parsing CSV with embedded eol sequences is now safe.
    - As I now also maintain Text::CSV_XS, I changed the references
    - Changed TODO's from Text::CSV to Text::CSV_PP (::CSV is dated 1997)

0.19	Fri 04 May 2007

    - Could not retreive '0' fields from OpenOffice (Jim Kelly)

0.18	Fri 27 Apr 2007

    - use strict in Makefile.PL
    - Added test_cover make target
    - Added "ods" for OpenOffice conversions
    - Added color tests for ods (but SR::RS doesn't support that yet)
    - Switched from \d to 0-9 in regexp
    - Added more test files and tests (increase coverage)

0.17	Tue 04 Jul 2006

    - xlscat new option: --ansii to (try to) use the ansi colors for fields
    - Fixed a color attribute off-by-one error
    - Added test cases (not yet complete)
    - Added bold and underline

0.16	Tue 04 Jul 2006

    - xlscat new option: --in-sep-char to force-define input sep-char for CSV
    - More debug lines
    - Parser name info in $ref->[0]
    - SquirrelCalc now reports Spreadsheet::Read and its version for parser info
    - Most of the attributes for Excel now implemented. Tested, but no test case

0.15	Wed 21 Jun 2006

    - Small doc change from AnnoCPAN
    - Sheets with undefined labels might cause havoc
    - Clip now skips empty xls sheets (TODO: sxc)
    - xlscat clips by default
    - xlscat new options -d and --noclip
    - xlscat usage () from -?/--help to STDOUT from fault to STDERR

0.14	Fri 20 Jan 2006

    - maxrow and maxcol were swapped in csv sheets
    - promoted internal debug flag to option
    - small doc changes

0.13	Thu 04 Nov 2005

    - Control attrib 'cells' was misinterpreted
    - New option: clip, default is true if {cell} is selected, false otherwise
      Removes trailing lines and columns in each sheet that have no visible data
    - new test t/11_call.t for checking options. Not complete yet
    - Added test_cover target to Makefile.PL

0.12	Mon 31 Oct 2005

    - Added ss2tk to examples

0.11	Wed 26 Oct 2005

    - Allow ods (OpenOffice 2.0) for sxc
    - include real ods test files and new test
    - Check if sc.version is undef, not 0

0.10	Mon 19 Sep 2005

    - More test coverage
    - cr2cell () returns ""     for illegal col/row values
    - cell2cr () returns (0, 0) for illegal cell    values
    - rows () tests even better for valid reference pointer
    - Renamed the test files

0.09	Sun 18 Sep 2005

    - Added Test::Pod
    - Added Test::Pod::Coverage
    - Spreadsheet::ReadSXC 0.20 now required (too many tests fail on 0.12)
    - Small changes to the docs
    - More secure handling of false values
    - Mention a bug in Spreadsheet::ParseExcel

0.08	Mon 22 Aug 2005

    - Slightly changed the Synopsis

0.07	Wed 06 Jul 2005

    - Added function rows ()
    - Added function parses ()
    - Made all modules optional
    - Prepared for Spreadsheet::Perl
    - Doc updates

0.06	Wed 22 Jun 2005

    - Repaired error in label names in metadata for SXC

0.05	Thu 17 Jun 2005

    - Spreadsheet::ReadSXC >= 0.20 supports sheet order
    - Spreadsheet::ReadSXC has new data structure (we still support the old)
    - Added "version" to the meta data for parser version
    - More tests

0.04	Tue 14 Jun 2005

    - Changed TODO
    - Added options "rc", and "cell"
    - Added CSV
    - Added CSV options "sep", and "quote"
    - Support xls from content
    - Added basic support for SquirrelCalc format
    - Updated pod
    - xlscat -R option for row selection was a one-off
    - xlscat now supports selecting fields with -F

0.03	Thu 19 May 2005

    - Expanded xlscat to support -i for index
    - Optionally install xlscat

0.02	Thu 19 May 2005

    - Typoes in the doc
    - Small change in organization so it actually installs

0.01	Thu 12 May 2005

    - Initial CPAN version. A lot can still change