0.91 - 27 Aug 2024, H.Merijn Brand
* Exclude OLE::Storage_Lite-0.21
* xlscat --head[=10], --tail[=10], --first=C
* Make (re)defining ->get_active_sheet safer
* Tested with perl-5.40
* xlscat --no-empty to skip empty columns too
* Spreadsheet::ParseExcel::FmtDefault might not be available
0.90 - 13 Feb 2024, H.Merijn Brand
* Consistent return value for parses ($type) on failure (issue#52)
* New options for xlscat (--no-empty, --clip=N)
* Support for hidden sheets
0.89 - 02 Jan 2024, H.Merijn Brand
* Auto-use BOM in CSV *files* with xlscat script
* Fix duplicate option letter (typo) (Erix)
* It's 2024
0.88 - 07 Nov 2023, H.Merijn Brand
* Guard $_ globbering from external bitrotted code
* Use recommended and suggested versions based on known CVEs
* Improve user feedback on failing xlsx2csv & xlscat
* Fix static docs for groff-1.24
* Basic support for Excel::ValueReader::XLSX (issue#50)
* Allow backend for parser option without version check
0.87 - 22 Feb 2023, H.Merijn Brand
* Change default #! to /usr/bin/perl (Tinita)
* Improve ->sheets (safer and docs)
* Update to Spreadsheet::ReadGnumeric 0.2 (attributes and small fixes)
0.86 - 07 Feb 2023, H.Merijn Brand
* Add Gnumeric support (Bob Rogers, THANKS!)
- work in progress, use with care, feedback welcome
0.85 - 04 Jan 2023, H.Merijn Brand
* Suggest the preferred parser if none found
* It's 2022
* xlscat --box and improvements for -L
* Add balloons to ss2tk buttons
* Fix typo in help (Erix)
* It's 2023
0.84 - 26 Feb 2021, H.Merijn Brand
* It's 2021
* Alias pivot to transpose (issue#36)
* Alias strip to trim (issue#36)
* Check for consistent return values of parses ()
0.83 - 21 Dec 2020, H.Merijn Brand
* Require ParseODS 0.26
* Add ::parsers to get list of supported formats
* Add --list to xlscat and xls2csv
* Update xls2csv to be identical to xlsx2csv
* ::parses ("") will return list of supported types
* Move installables from examples/ to scripts/
* Tested on FreeBSD-12.2-RELEASE with all supported backends
* Fix META issue for bugtracker
0.82 - 26 Sep 2020, H.Merijn Brand
* Move pod tests to xt (and do not distribute)
* Fix some links in the docs
* Add ".xlsm" to known XLSX file extensions
* Spreadsheet::ReadSXC has a new maintainer (Corion)
- support file handles
- suggest version 0.24 (0.22 causes fails)
* First attempt in supporting Spreadsheet::ParseODS (alpha code)
- version 0.25 should now pass the limited tests
- thanks to Corion for making this happen!
* It's 2020
* Fallback to Pod::Text if nroff not available in tools
* Extended support for merged cells with merge option
- Added $sheet->merged_from ("C2")
* Add --no-nl[=x] to xlscat
* xlscat: Align-right more numerics on -L (was only positive integers)
* xlsx2csv -Z : generate a ZIP file with a CSV for every sheet
* Doc fix (issue#33)
0.81 - 25 Aug 2019, H.Merijn Brand
* It's 2019
* Allow -c + --sep in xlscat
* Add --sep= to xls2csv for -A
* Add xlsx2csv to distribution (xlsx2csv has -A)
* Add -J s / --join str to xlsx2csv
* Add cpanfile
* Add explicit documentation about formatted vs unformatted
* Improve ->new behavior
* Auto-detect fallback for CSV now includes '|' for sep_char (PR#26)
0.80 - 31 Dec 2018, H.Merijn Brand
* Raise Spreadsheet::ParseXLSX minimum version to 0.24
* Improve docs on attributes
* Add attribute accessors
0.79 - 29 Aug 2018, H.Merijn Brand
* Environmant control hardening
* ReadData () docs (opening from scalar ref: issue#21)
* Check for XLSX content on opening from plain scalar content
* Fix typo in ss-dup-tk.pl (PRC, Branislav Zahradnik)
* Allow source from command line option in xls2csv (PRC, Branislav Zahradnik)
* Allow --in-sep=tab in xlscat/xlsgrep
* Add --hash to xlscat/xlsgrep
* Help and usage for examples/xls2csv (PR#23)
0.78 - 29 Jan 2018, H.Merijn Brand
* Spreadsheet::ParseExcel supports the active flag as of version 0.61
* Fix typo in docs (SPROUT, RT#124214)
0.77 - 22 Jan 2018, H.Merijn Brand
* Note possible name clashes with example/tool files
* Clipping and stripping more efficient
0.76 - 01 Jan 2018, H.Merijn Brand
* Allow streaming in xlscat
* Add --dump to xlscat
* Add error for opening ODS/SXC from reference
* It's 2018
0.75 - 09 Nov 2017, H.Merijn Brand
* Windows does not like an exec with arguments that have spaces (PR#15)
Three fixes by Andrew Gregory <andrew.gregory.8@gmail.com>). Thanks!
* Fix column clipping
* Manually generate cells to delete when clipping
* Skip cell deletion if they were never generated
* File names cannot have \0 in newer perls
0.74 - 27 Aug 2017, H.Merijn Brand
* Re-enable opening files with bad characters in the filename (issue#14)
0.73 - 30 Jul 2017, H.Merijn Brand
* Spreadsheet::XLSX::Reader::LibXML support completely dropped
* New options for ss2tk (font specs and SS labels)
* Safer xls2csv option parsing/passing
* Pass unknown command-line options to the parser
* Fix ReadData ("a,b,c\n1,2,3\n", parser => "csv")
* Drop 5.8.0 support. 5.8.1 is now minimum
0.72 - 25 May 2017, H.Merijn Brand
* get_active_sheet is only available as of Spreadsheet::ParseExcel 0.61
* Support password protected spreadsheets (implementation just for Excel)
* Do not warn on undefined labels (xlscat)
0.71 - 13 May 2017, H.Merijn Brand
* Use -w as intended
* Add option pivot
* No trailing spaces on xlscat -L
* Lexicalize code snippet (issue#12)
* Add attr method
* Remove special chars from worksheet name component (Windows, PR#13)
* Add refresh to ss2tk / csv2tk
* Add shortcut for UTF-8 output to xlscat
* Upgrade recommended modules to required for cpancover
0.70 - 02 Mar 2017, H.Merijn Brand
* Add label functionality to ::Sheet
* Add ->column and ->cellcolumn for ::Sheet
* Add col2label sub/method
* Sanitize xls2csv export filenames
* Fix sorting in xlscat for un-aligned columns
* It's 2017
* Be overly verbose about maxrow and maxcol being 1-based (RT#120476)
0.69 - 02 Dec 2016, H.Merijn Brand
* Several OO fixes, more tests, more docs
0.68 - 29 Nov 2016, H.Merijn Brand
* List non-core modules/version used on very verbose in xlscat
* Option to export all sheets in a spreadsheet to CSV (UTF-8 only)
* Add OO interface
* Feature: add new spreadsheets to existing book (even of different types)
0.67 - 17 Jun 2016, H.Merijn Brand
* CPANTESTERS showed that some versions really messed op numeric/percentage
0.66 - 16 Jun 2016, H.Merijn Brand
* Remove Spreadsheet::XLSX::Reader::LibXML test files from distribution
* Allow old versions of Spreadsheet::ParseXLSX to "fail" on percentage tests
0.65 - 15 Jun 2016, H.Merijn Brand
* Test with perl-5.24.0
* Show parser-version used under debug
* No more Spreadsheet::XLSX::Reader::LibXML
* Cells will inherit hidden state from hidden rows and columns
* Require 5.8.0 as 5.6.x does not include required Encode
0.64 - 22 Apr 2016, H.Merijn Brand
* It's 2016
* Allow inconsistent Spreadsheet::XLSX releases on Debian (tests)
* Decode utf-16be entries in Excel when appropriate
* Two examples in xlscat
0.63 - 10 Oct 2015, H.Merijn Brand
* Guard against negative MinRow in XLSX
* Documentation updated
* Support Spreadsheet::XLSX::Reader::LibXML disabled on author request
* Fix warning in utilities
* Check minimum parser version for pre-selected parser
0.62 - 16 Aug 2015, H.Merijn Brand
* Fix documentation structure
* Test all supported parsers (not just the preferred one)
* Basic support for Spreadsheet::XLSX::Reader::LibXML (work in progress)
* Copy example file if link fails (Alan Berndt)
* Add a contributing guide
0.61 - 13 Jun 2015, H.Merijn Brand
* Discourage Spreadsheet::XLSX
* A space is not an empty field in XLS
* Strip the correct selection (RT#105197)
0.60 - 30 Mar 2015, H.Merijn Brand
* No merged cell support in Spreadsheet::XLSX
0.59 - 26 Mar 2015, H.Merijn Brand
* Minimal support (+ docs) for merged cells
* Make parser errors report at one level up
* Don't select non-existing columns in xlscat
0.58 - 11 Feb 2015, H.Merijn Brand
* Remove perl recommendation from META as it breaks cpan clients
* Move sort instruction to correct place in xlscat's help
0.57 - 08 Feb 2015, H.Merijn Brand
* Moved project to github
* Add --sort to xlscat
* Clip before conversion
* Removed an unneeded localizing of $/ (related to p5 RT#123218)
0.56 - 05 Jan 2015, H.Merijn Brand
* printf does not play nice with encoding (related to RT#98436)
* default output UTF-8 if whole line is UTF-8
0.55 - 01 Jan 2015, H.Merijn Brand
* Mention Spreadsheet::CSV in documentation
* Add ssdiff to examples
* Amend xlscat -n to also number in HTML
* Updated copyright to 2015
0.54 - 30 Jan 2014, H.Merijn Brand
* Optional features required versions now builtin
0.53 - 29 Jan 2014, H.Merijn Brand
* Updated copyright to 2014
* Prefer Data::Peek over Data::Dumper
* Support (and prefer) Spreadsheet::ParseXLSX for .xlsx
0.52 - 05 Dec 2013, H.Merijn Brand
* Store CSV parse error - if any - in $ss->[0]{error}
0.51 - 30 Oct 2013, H.Merijn Brand
* Link xlsgrep during install
0.50 - 24 Oct 2013, H.Merijn Brand
* Added xlsgrep to examples
* Allow -C B,D for xlscat
* More prominent reference to xlscat in docs
0.49 - 11 May 2013, H.Merijn Brand
* /dev/null cannot be used for tests on Windows
0.48 - 14 Mar 2013, H.Merijn Brand
* Improve documentation consistency (RT#80409)
* Updated copyright to 2013
* Force old(er) tar format (ustar) - assumes GNU tar on release box
* Fix yml/json optional_features
* Install utilities from example by default
* Several minor changes (for maint)
0.47 - 30 Jun 2012, H.Merijn Brand
* Note that empty sheets are skipped when clip is true (RT#75277)
* Allow undef as valid value for the options (Max Maischein)
* Don't generate warnings when stripping whitespace and only
generating one of cells or rc. (Max Maschein)
* Fix test warning under perl-5.17.x
0.46 - 14 Feb 2012, H.Merijn Brand
* Updated copyright to 2012
* Support passing attributes to the underlying parser
* Do not strip fields in sheets with no cells at all (RT#74976)
0.45 - 07 Sep 2011, H.Merijn Brand
* NAME / DISTNAME in Makefile.PL
0.44 - 07 Sep 2011, H.Merijn Brand
* More cross-checks for META data
0.43 - 02 Aug 2011, H.Merijn Brand
* Changed name in META.yml (RT#69574)
0.42 - 01 Jun 2011, H.Merijn Brand
* Add --html output option to xlscat
* Force CSV parser when in-sep is given
* Prefer Data::Peek over Data::Dumper if available
0.41 - 06 Oct 2010, H.Merijn Brand
* Spell-check
* Fixed requiring optional modules (RT#61928 - Roderick Schupp)
0.40 - 31 Mar 2010, H.Merijn Brand
* Default option for clip fixed (RT#56151 - Alan James)
0.39 - 16 Mar 2010, H.Merijn Brand
* Doc fix (RT#54507, Patrick Cronin)
* Upped Copyright notices to 2010
* Drop YAML version to 1.0
0.38 - 15 Dec 2009, H.Merijn Brand
* Add row () and cellrow ()
* Updated META.yml to meet most recent specs (optional_features = map)
0.37 - 09 Nov 2009, H.Merijn Brand
* IO streams improvements
* MANIFEST fix
0.36 - 06 Nov 2009, H.Merijn Brand
* 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 - 03 Jun 2009, H.Merijn Brand
* 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 - 27 Jan 2009, H.Merijn Brand
* 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 - 23 Jan 2009, H.Merijn Brand
* 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 - 06 Jan 2009, H.Merijn Brand
* Add basic support for M$ Excel 2007 using Spreadsheet::XLSX
* Test suite reports the parsers it found
0.31 - 04 Jan 2009, H.Merijn Brand
* Upped Copyright notices to 2009
* Detection of percentage type
* Even more reliable detection of Date types
0.30 - 22 Dec 2008, H.Merijn Brand
* Wrong e-mail in META.yml
* CSV files from a Mac, with \r as eol, would not parse
0.29 - 19 Oct 2008, H.Merijn Brand
* 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 - 04 Sep 2008, H.Merijn Brand
* 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 - 31 Aug 2008, H.Merijn Brand
* Fixed META.yml (the specs are inconsistent)
* Added --dtfmt to xlscat
0.26 - 29 Aug 2008, H.Merijn Brand
* 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 - 02 Jan 2008, H.Merijn Brand
* 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 - 05 Oct 2007, H.Merijn Brand
* -? 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 - 21 Jun 2007, H.Merijn Brand
* 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 - 18 Jun 2007, H.Merijn Brand
* 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 - 18 Jun 2007, H.Merijn Brand
* Text::CSV_XS uses keep_meta_info instead of get_flags
* Removed always_quote from xlscat's CSV output
0.20 - 31 May 2007, H.Merijn Brand
* 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 - 04 May 2007, H.Merijn Brand
* Could not retreive '0' fields from OpenOffice (Jim Kelly)
0.18 - 27 Apr 2007, H.Merijn Brand
* 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 - 04 Jul 2006, H.Merijn Brand
* 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 - 04 Jul 2006, H.Merijn Brand
* 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 - 21 Jun 2006, H.Merijn Brand
* 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 - 20 Jan 2006, H.Merijn Brand
* maxrow and maxcol were swapped in csv sheets
* promoted internal debug flag to option
* small doc changes
0.13 - 04 Nov 2005, H.Merijn Brand
* 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 - 31 Oct 2005, H.Merijn Brand
* Added ss2tk to examples
0.11 - 26 Oct 2005, H.Merijn Brand
* 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 - 19 Sep 2005, H.Merijn Brand
* 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 - 18 Sep 2005, H.Merijn Brand
* 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 - 22 Aug 2005, H.Merijn Brand
* Slightly changed the Synopsis
0.07 - 06 Jul 2005, H.Merijn Brand
* Added function rows ()
* Added function parses ()
* Made all modules optional
* Prepared for Spreadsheet::Perl
* Doc updates
0.06 - 22 Jun 2005, H.Merijn Brand
* Repaired error in label names in metadata for SXC
0.05 - 17 Jun 2005, H.Merijn Brand
* 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 - 14 Jun 2005, H.Merijn Brand
* 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 - 19 May 2005, H.Merijn Brand
* Expanded xlscat to support -i for index
* Optionally install xlscat
0.02 - 19 May 2005, H.Merijn Brand
* Typoes in the doc
* Small change in organization so it actually installs
0.01 - 12 May 2005, H.Merijn Brand
* Initial CPAN version. A lot can still change