Revision history for Spreadsheet::Read
0.40 Wed 31 Mar 2010
- Default option for clip fixed (RT#56151 - Alan James)
0.39 Tue 16 Mar 2010
- Doc fix (RT#54507, Patrick Cronin)
- Upped Copyright notices to 2010
- Drop YAML version to 1.0
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