| 1 |
0.95 - 25 Jan 2026, H.Merijn Brand |
| 2 |
* It's 2026 |
| 3 |
|
| 4 |
0.94 - 09 Dec 2025, H.Merijn Brand |
| 5 |
* Add label2col () |
| 6 |
* $sheet->{attr} should always be there, might be empty (issue#56) |
| 7 |
* Skip type tests when unsupported (issue#56) |
| 8 |
* Skip merge tests when unsupported (issue#56) |
| 9 |
* Update SECURITY.md |
| 10 |
|
| 11 |
0.93 - 17 Mar 2025, H.Merijn Brand |
| 12 |
* Add ranges and cellranges |
| 13 |
|
| 14 |
0.92 - 06 Jan 2025, H.Merijn Brand |
| 15 |
* Make strict_eol default to 1 for CSV when supported |
| 16 |
* Show detected EOL for CSV in xlscat when known |
| 17 |
* Add SECURITY.md |
| 18 |
* It's 2025 |
| 19 |
|
| 20 |
0.91 - 27 Aug 2024, H.Merijn Brand |
| 21 |
* Exclude OLE::Storage_Lite-0.21 |
| 22 |
* xlscat --head[=10], --tail[=10], --first=C |
| 23 |
* Make (re)defining ->get_active_sheet safer |
| 24 |
* Tested with perl-5.40 |
| 25 |
* xlscat --no-empty to skip empty columns too |
| 26 |
* Spreadsheet::ParseExcel::FmtDefault might not be available |
| 27 |
|
| 28 |
0.90 - 13 Feb 2024, H.Merijn Brand |
| 29 |
* Consistent return value for parses ($type) on failure (issue#52) |
| 30 |
* New options for xlscat (--no-empty, --clip=N) |
| 31 |
* Support for hidden sheets |
| 32 |
|
| 33 |
0.89 - 02 Jan 2024, H.Merijn Brand |
| 34 |
* Auto-use BOM in CSV *files* with xlscat script |
| 35 |
* Fix duplicate option letter (typo) (Erix) |
| 36 |
* It's 2024 |
| 37 |
|
| 38 |
0.88 - 07 Nov 2023, H.Merijn Brand |
| 39 |
* Guard $_ globbering from external bitrotted code |
| 40 |
* Use recommended and suggested versions based on known CVEs |
| 41 |
* Improve user feedback on failing xlsx2csv & xlscat |
| 42 |
* Fix static docs for groff-1.24 |
| 43 |
* Basic support for Excel::ValueReader::XLSX (issue#50) |
| 44 |
* Allow backend for parser option without version check |
| 45 |
|
| 46 |
0.87 - 22 Feb 2023, H.Merijn Brand |
| 47 |
* Change default #! to /usr/bin/perl (Tinita) |
| 48 |
* Improve ->sheets (safer and docs) |
| 49 |
* Update to Spreadsheet::ReadGnumeric 0.2 (attributes and small fixes) |
| 50 |
|
| 51 |
0.86 - 07 Feb 2023, H.Merijn Brand |
| 52 |
* Add Gnumeric support (Bob Rogers, THANKS!) |
| 53 |
- work in progress, use with care, feedback welcome |
| 54 |
|
| 55 |
0.85 - 04 Jan 2023, H.Merijn Brand |
| 56 |
* Suggest the preferred parser if none found |
| 57 |
* It's 2022 |
| 58 |
* xlscat --box and improvements for -L |
| 59 |
* Add balloons to ss2tk buttons |
| 60 |
* Fix typo in help (Erix) |
| 61 |
* It's 2023 |
| 62 |
|
| 63 |
0.84 - 26 Feb 2021, H.Merijn Brand |
| 64 |
* It's 2021 |
| 65 |
* Alias pivot to transpose (issue#36) |
| 66 |
* Alias strip to trim (issue#36) |
| 67 |
* Check for consistent return values of parses () |
| 68 |
|
| 69 |
0.83 - 21 Dec 2020, H.Merijn Brand |
| 70 |
* Require ParseODS 0.26 |
| 71 |
* Add ::parsers to get list of supported formats |
| 72 |
* Add --list to xlscat and xls2csv |
| 73 |
* Update xls2csv to be identical to xlsx2csv |
| 74 |
* ::parses ("") will return list of supported types |
| 75 |
* Move installables from examples/ to scripts/ |
| 76 |
* Tested on FreeBSD-12.2-RELEASE with all supported backends |
| 77 |
* Fix META issue for bugtracker |
| 78 |
|
| 79 |
0.82 - 26 Sep 2020, H.Merijn Brand |
| 80 |
* Move pod tests to xt (and do not distribute) |
| 81 |
* Fix some links in the docs |
| 82 |
* Add ".xlsm" to known XLSX file extensions |
| 83 |
* Spreadsheet::ReadSXC has a new maintainer (Corion) |
| 84 |
- support file handles |
| 85 |
- suggest version 0.24 (0.22 causes fails) |
| 86 |
* First attempt in supporting Spreadsheet::ParseODS (alpha code) |
| 87 |
- version 0.25 should now pass the limited tests |
| 88 |
- thanks to Corion for making this happen! |
| 89 |
* It's 2020 |
| 90 |
* Fallback to Pod::Text if nroff not available in tools |
| 91 |
* Extended support for merged cells with merge option |
| 92 |
- Added $sheet->merged_from ("C2") |
| 93 |
* Add --no-nl[=x] to xlscat |
| 94 |
* xlscat: Align-right more numerics on -L (was only positive integers) |
| 95 |
* xlsx2csv -Z : generate a ZIP file with a CSV for every sheet |
| 96 |
* Doc fix (issue#33) |
| 97 |
|
| 98 |
0.81 - 25 Aug 2019, H.Merijn Brand |
| 99 |
* It's 2019 |
| 100 |
* Allow -c + --sep in xlscat |
| 101 |
* Add --sep= to xls2csv for -A |
| 102 |
* Add xlsx2csv to distribution (xlsx2csv has -A) |
| 103 |
* Add -J s / --join str to xlsx2csv |
| 104 |
* Add cpanfile |
| 105 |
* Add explicit documentation about formatted vs unformatted |
| 106 |
* Improve ->new behavior |
| 107 |
* Auto-detect fallback for CSV now includes '|' for sep_char (PR#26) |
| 108 |
|
| 109 |
0.80 - 31 Dec 2018, H.Merijn Brand |
| 110 |
* Raise Spreadsheet::ParseXLSX minimum version to 0.24 |
| 111 |
* Improve docs on attributes |
| 112 |
* Add attribute accessors |
| 113 |
|
| 114 |
0.79 - 29 Aug 2018, H.Merijn Brand |
| 115 |
* Environmant control hardening |
| 116 |
* ReadData () docs (opening from scalar ref: issue#21) |
| 117 |
* Check for XLSX content on opening from plain scalar content |
| 118 |
* Fix typo in ss-dup-tk.pl (PRC, Branislav Zahradnik) |
| 119 |
* Allow source from command line option in xls2csv (PRC, Branislav Zahradnik) |
| 120 |
* Allow --in-sep=tab in xlscat/xlsgrep |
| 121 |
* Add --hash to xlscat/xlsgrep |
| 122 |
* Help and usage for examples/xls2csv (PR#23) |
| 123 |
|
| 124 |
0.78 - 29 Jan 2018, H.Merijn Brand |
| 125 |
* Spreadsheet::ParseExcel supports the active flag as of version 0.61 |
| 126 |
* Fix typo in docs (SPROUT, RT#124214) |
| 127 |
|
| 128 |
0.77 - 22 Jan 2018, H.Merijn Brand |
| 129 |
* Note possible name clashes with example/tool files |
| 130 |
* Clipping and stripping more efficient |
| 131 |
|
| 132 |
0.76 - 01 Jan 2018, H.Merijn Brand |
| 133 |
* Allow streaming in xlscat |
| 134 |
* Add --dump to xlscat |
| 135 |
* Add error for opening ODS/SXC from reference |
| 136 |
* It's 2018 |
| 137 |
|
| 138 |
0.75 - 09 Nov 2017, H.Merijn Brand |
| 139 |
* Windows does not like an exec with arguments that have spaces (PR#15) |
| 140 |
Three fixes by Andrew Gregory <[email protected]>). Thanks! |
| 141 |
* Fix column clipping |
| 142 |
* Manually generate cells to delete when clipping |
| 143 |
* Skip cell deletion if they were never generated |
| 144 |
* File names cannot have \0 in newer perls |
| 145 |
|
| 146 |
0.74 - 27 Aug 2017, H.Merijn Brand |
| 147 |
* Re-enable opening files with bad characters in the filename (issue#14) |
| 148 |
|
| 149 |
0.73 - 30 Jul 2017, H.Merijn Brand |
| 150 |
* Spreadsheet::XLSX::Reader::LibXML support completely dropped |
| 151 |
* New options for ss2tk (font specs and SS labels) |
| 152 |
* Safer xls2csv option parsing/passing |
| 153 |
* Pass unknown command-line options to the parser |
| 154 |
* Fix ReadData ("a,b,c\n1,2,3\n", parser => "csv") |
| 155 |
* Drop 5.8.0 support. 5.8.1 is now minimum |
| 156 |
|
| 157 |
0.72 - 25 May 2017, H.Merijn Brand |
| 158 |
* get_active_sheet is only available as of Spreadsheet::ParseExcel 0.61 |
| 159 |
* Support password protected spreadsheets (implementation just for Excel) |
| 160 |
* Do not warn on undefined labels (xlscat) |
| 161 |
|
| 162 |
0.71 - 13 May 2017, H.Merijn Brand |
| 163 |
* Use -w as intended |
| 164 |
* Add option pivot |
| 165 |
* No trailing spaces on xlscat -L |
| 166 |
* Lexicalize code snippet (issue#12) |
| 167 |
* Add attr method |
| 168 |
* Remove special chars from worksheet name component (Windows, PR#13) |
| 169 |
* Add refresh to ss2tk / csv2tk |
| 170 |
* Add shortcut for UTF-8 output to xlscat |
| 171 |
* Upgrade recommended modules to required for cpancover |
| 172 |
|
| 173 |
0.70 - 02 Mar 2017, H.Merijn Brand |
| 174 |
* Add label functionality to ::Sheet |
| 175 |
* Add ->column and ->cellcolumn for ::Sheet |
| 176 |
* Add col2label sub/method |
| 177 |
* Sanitize xls2csv export filenames |
| 178 |
* Fix sorting in xlscat for un-aligned columns |
| 179 |
* It's 2017 |
| 180 |
* Be overly verbose about maxrow and maxcol being 1-based (RT#120476) |
| 181 |
|
| 182 |
0.69 - 02 Dec 2016, H.Merijn Brand |
| 183 |
* Several OO fixes, more tests, more docs |
| 184 |
|
| 185 |
0.68 - 29 Nov 2016, H.Merijn Brand |
| 186 |
* List non-core modules/version used on very verbose in xlscat |
| 187 |
* Option to export all sheets in a spreadsheet to CSV (UTF-8 only) |
| 188 |
* Add OO interface |
| 189 |
* Feature: add new spreadsheets to existing book (even of different types) |
| 190 |
|
| 191 |
0.67 - 17 Jun 2016, H.Merijn Brand |
| 192 |
* CPANTESTERS showed that some versions really messed op numeric/percentage |
| 193 |
|
| 194 |
0.66 - 16 Jun 2016, H.Merijn Brand |
| 195 |
* Remove Spreadsheet::XLSX::Reader::LibXML test files from distribution |
| 196 |
* Allow old versions of Spreadsheet::ParseXLSX to "fail" on percentage tests |
| 197 |
|
| 198 |
0.65 - 15 Jun 2016, H.Merijn Brand |
| 199 |
* Test with perl-5.24.0 |
| 200 |
* Show parser-version used under debug |
| 201 |
* No more Spreadsheet::XLSX::Reader::LibXML |
| 202 |
* Cells will inherit hidden state from hidden rows and columns |
| 203 |
* Require 5.8.0 as 5.6.x does not include required Encode |
| 204 |
|
| 205 |
0.64 - 22 Apr 2016, H.Merijn Brand |
| 206 |
* It's 2016 |
| 207 |
* Allow inconsistent Spreadsheet::XLSX releases on Debian (tests) |
| 208 |
* Decode utf-16be entries in Excel when appropriate |
| 209 |
* Two examples in xlscat |
| 210 |
|
| 211 |
0.63 - 10 Oct 2015, H.Merijn Brand |
| 212 |
* Guard against negative MinRow in XLSX |
| 213 |
* Documentation updated |
| 214 |
* Support Spreadsheet::XLSX::Reader::LibXML disabled on author request |
| 215 |
* Fix warning in utilities |
| 216 |
* Check minimum parser version for pre-selected parser |
| 217 |
|
| 218 |
0.62 - 16 Aug 2015, H.Merijn Brand |
| 219 |
* Fix documentation structure |
| 220 |
* Test all supported parsers (not just the preferred one) |
| 221 |
* Basic support for Spreadsheet::XLSX::Reader::LibXML (work in progress) |
| 222 |
* Copy example file if link fails (Alan Berndt) |
| 223 |
* Add a contributing guide |
| 224 |
|
| 225 |
0.61 - 13 Jun 2015, H.Merijn Brand |
| 226 |
* Discourage Spreadsheet::XLSX |
| 227 |
* A space is not an empty field in XLS |
| 228 |
* Strip the correct selection (RT#105197) |
| 229 |
|
| 230 |
0.60 - 30 Mar 2015, H.Merijn Brand |
| 231 |
* No merged cell support in Spreadsheet::XLSX |
| 232 |
|
| 233 |
0.59 - 26 Mar 2015, H.Merijn Brand |
| 234 |
* Minimal support (+ docs) for merged cells |
| 235 |
* Make parser errors report at one level up |
| 236 |
* Don't select non-existing columns in xlscat |
| 237 |
|
| 238 |
0.58 - 11 Feb 2015, H.Merijn Brand |
| 239 |
* Remove perl recommendation from META as it breaks cpan clients |
| 240 |
* Move sort instruction to correct place in xlscat's help |
| 241 |
|
| 242 |
0.57 - 08 Feb 2015, H.Merijn Brand |
| 243 |
* Moved project to github |
| 244 |
* Add --sort to xlscat |
| 245 |
* Clip before conversion |
| 246 |
* Removed an unneeded localizing of $/ (related to p5 RT#123218) |
| 247 |
|
| 248 |
0.56 - 05 Jan 2015, H.Merijn Brand |
| 249 |
* printf does not play nice with encoding (related to RT#98436) |
| 250 |
* default output UTF-8 if whole line is UTF-8 |
| 251 |
|
| 252 |
0.55 - 01 Jan 2015, H.Merijn Brand |
| 253 |
* Mention Spreadsheet::CSV in documentation |
| 254 |
* Add ssdiff to examples |
| 255 |
* Amend xlscat -n to also number in HTML |
| 256 |
* Updated copyright to 2015 |
| 257 |
|
| 258 |
0.54 - 30 Jan 2014, H.Merijn Brand |
| 259 |
* Optional features required versions now builtin |
| 260 |
|
| 261 |
0.53 - 29 Jan 2014, H.Merijn Brand |
| 262 |
* Updated copyright to 2014 |
| 263 |
* Prefer Data::Peek over Data::Dumper |
| 264 |
* Support (and prefer) Spreadsheet::ParseXLSX for .xlsx |
| 265 |
|
| 266 |
0.52 - 05 Dec 2013, H.Merijn Brand |
| 267 |
* Store CSV parse error - if any - in $ss->[0]{error} |
| 268 |
|
| 269 |
0.51 - 30 Oct 2013, H.Merijn Brand |
| 270 |
* Link xlsgrep during install |
| 271 |
|
| 272 |
0.50 - 24 Oct 2013, H.Merijn Brand |
| 273 |
* Added xlsgrep to examples |
| 274 |
* Allow -C B,D for xlscat |
| 275 |
* More prominent reference to xlscat in docs |
| 276 |
|
| 277 |
0.49 - 11 May 2013, H.Merijn Brand |
| 278 |
* /dev/null cannot be used for tests on Windows |
| 279 |
|
| 280 |
0.48 - 14 Mar 2013, H.Merijn Brand |
| 281 |
* Improve documentation consistency (RT#80409) |
| 282 |
* Updated copyright to 2013 |
| 283 |
* Force old(er) tar format (ustar) - assumes GNU tar on release box |
| 284 |
* Fix yml/json optional_features |
| 285 |
* Install utilities from example by default |
| 286 |
* Several minor changes (for maint) |
| 287 |
|
| 288 |
0.47 - 30 Jun 2012, H.Merijn Brand |
| 289 |
* Note that empty sheets are skipped when clip is true (RT#75277) |
| 290 |
* Allow undef as valid value for the options (Max Maischein) |
| 291 |
* Don't generate warnings when stripping whitespace and only |
| 292 |
generating one of cells or rc. (Max Maschein) |
| 293 |
* Fix test warning under perl-5.17.x |
| 294 |
|
| 295 |
0.46 - 14 Feb 2012, H.Merijn Brand |
| 296 |
* Updated copyright to 2012 |
| 297 |
* Support passing attributes to the underlying parser |
| 298 |
* Do not strip fields in sheets with no cells at all (RT#74976) |
| 299 |
|
| 300 |
0.45 - 07 Sep 2011, H.Merijn Brand |
| 301 |
* NAME / DISTNAME in Makefile.PL |
| 302 |
|
| 303 |
0.44 - 07 Sep 2011, H.Merijn Brand |
| 304 |
* More cross-checks for META data |
| 305 |
|
| 306 |
0.43 - 02 Aug 2011, H.Merijn Brand |
| 307 |
* Changed name in META.yml (RT#69574) |
| 308 |
|
| 309 |
0.42 - 01 Jun 2011, H.Merijn Brand |
| 310 |
* Add --html output option to xlscat |
| 311 |
* Force CSV parser when in-sep is given |
| 312 |
* Prefer Data::Peek over Data::Dumper if available |
| 313 |
|
| 314 |
0.41 - 06 Oct 2010, H.Merijn Brand |
| 315 |
* Spell-check |
| 316 |
* Fixed requiring optional modules (RT#61928 - Roderick Schupp) |
| 317 |
|
| 318 |
0.40 - 31 Mar 2010, H.Merijn Brand |
| 319 |
* Default option for clip fixed (RT#56151 - Alan James) |
| 320 |
|
| 321 |
0.39 - 16 Mar 2010, H.Merijn Brand |
| 322 |
* Doc fix (RT#54507, Patrick Cronin) |
| 323 |
* Upped Copyright notices to 2010 |
| 324 |
* Drop YAML version to 1.0 |
| 325 |
|
| 326 |
0.38 - 15 Dec 2009, H.Merijn Brand |
| 327 |
* Add row () and cellrow () |
| 328 |
* Updated META.yml to meet most recent specs (optional_features = map) |
| 329 |
|
| 330 |
0.37 - 09 Nov 2009, H.Merijn Brand |
| 331 |
* IO streams improvements |
| 332 |
* MANIFEST fix |
| 333 |
|
| 334 |
0.36 - 06 Nov 2009, H.Merijn Brand |
| 335 |
* Add strip option |
| 336 |
* Spreadsheet::XLSX 0.12 still does not support attributes |
| 337 |
* Require Text::CSV_XS-0.69 for CSV for auto-detection of \r |
| 338 |
* New attribute "parser" to force format |
| 339 |
* Allow CSV streams |
| 340 |
* Allow SC streams |
| 341 |
* Allow XLS streams |
| 342 |
|
| 343 |
0.35 - 03 Jun 2009, H.Merijn Brand |
| 344 |
* Add Test::NoWarnings, which is not run in AUTOMATED_TESTING |
| 345 |
* Switched to Test::More using tests_done () |
| 346 |
* Text::CSV_XS requires 0.43 or up, as we use ->eof () |
| 347 |
still prefer a really new release, like 0.65, which |
| 348 |
is Test::NoWarnings safe |
| 349 |
* Spreadsheet::XLSX 0.10 still does not support attributes |
| 350 |
* Added -n to xlscat |
| 351 |
* XLSX tests skip on feature, not on version |
| 352 |
|
| 353 |
0.34 - 27 Jan 2009, H.Merijn Brand |
| 354 |
* Spreadsheet::XLSX 0.09 still does not support attributes |
| 355 |
still think it is better to follow closely. 0.09 is much |
| 356 |
better than 0.08 |
| 357 |
|
| 358 |
0.33 - 23 Jan 2009, H.Merijn Brand |
| 359 |
* A few Perl::Critic inspired changes |
| 360 |
* Modified tests to prevent rounding errors (we were not checking for that) |
| 361 |
* Added examples/ss-dups-tk.pl |
| 362 |
|
| 363 |
0.32 - 06 Jan 2009, H.Merijn Brand |
| 364 |
* Add basic support for M$ Excel 2007 using Spreadsheet::XLSX |
| 365 |
* Test suite reports the parsers it found |
| 366 |
|
| 367 |
0.31 - 04 Jan 2009, H.Merijn Brand |
| 368 |
* Upped Copyright notices to 2009 |
| 369 |
* Detection of percentage type |
| 370 |
* Even more reliable detection of Date types |
| 371 |
|
| 372 |
0.30 - 22 Dec 2008, H.Merijn Brand |
| 373 |
* Wrong e-mail in META.yml |
| 374 |
* CSV files from a Mac, with \r as eol, would not parse |
| 375 |
|
| 376 |
0.29 - 19 Oct 2008, H.Merijn Brand |
| 377 |
* Make Read safer for files that do not match extension, |
| 378 |
like HTML in foo.xls |
| 379 |
* YAML declared 1.4 (META.yml) instead of 1.1 (YAML) |
| 380 |
* Bring Makefile.PL in sync with META.yml |
| 381 |
* Recommend Text-CSV-0.56 |
| 382 |
|
| 383 |
0.28 - 04 Sep 2008, H.Merijn Brand |
| 384 |
* More tests on date formats |
| 385 |
* Declare Spreadsheet::ParseExcel::FmtDefault in META.yml |
| 386 |
* Add 'size' from Excel font size |
| 387 |
* Update docs about Excel quirks and CPAN links |
| 388 |
* Reference to public git repo |
| 389 |
* Some typo's |
| 390 |
|
| 391 |
0.27 - 31 Aug 2008, H.Merijn Brand |
| 392 |
* Fixed META.yml (the specs are inconsistent) |
| 393 |
* Added --dtfmt to xlscat |
| 394 |
|
| 395 |
0.26 - 29 Aug 2008, H.Merijn Brand |
| 396 |
* Added examples/xls2csv |
| 397 |
* Upped copyright to 2008 in examples |
| 398 |
* Don't ask to install examples under automated testing |
| 399 |
* die => croak |
| 400 |
* Added tgzdist target |
| 401 |
* Added encoding options to examples/xlscat |
| 402 |
* Added date-type checks for SS:PE > 0.32 |
| 403 |
|
| 404 |
0.25 - 02 Jan 2008, H.Merijn Brand |
| 405 |
* Spreadsheet-Read now under git |
| 406 |
* Upped copyrights to 2008 |
| 407 |
* Added all prereq's to Makefile.PL, even core mods |
| 408 |
* Tested under perl-5.10.0 |
| 409 |
* Text::CSV as of 1.00 is OK |
| 410 |
|
| 411 |
0.24 - 05 Oct 2007, H.Merijn Brand |
| 412 |
* -? and --help in utils moved to Getopt::Long |
| 413 |
* Adjusted copyright notice in utils |
| 414 |
* removed prototypes in utils |
| 415 |
* next is illegal in do {} while (); (Johan Vromans) |
| 416 |
only happens with old Text::CSV_XS |
| 417 |
|
| 418 |
0.23 - 21 Jun 2007, H.Merijn Brand |
| 419 |
* Use IO::Scalar instead of File::Temp when installed |
| 420 |
Thanks to David Cantrell for making a OpenBSD test box available! |
| 421 |
* use binmode () when opening files |
| 422 |
* Also use 3-arg open in test files |
| 423 |
* die if test files cannot be opene'ed |
| 424 |
|
| 425 |
0.22 - 18 Jun 2007, H.Merijn Brand |
| 426 |
* 0.21 should already support Text::CSV_PP 1.05 |
| 427 |
Tested Text::CSV_PP 1.05 on bleadperl. |
| 428 |
* Better detection of (not) installed modules |
| 429 |
* Module requires perl 5.6.x |
| 430 |
|
| 431 |
0.21 - 18 Jun 2007, H.Merijn Brand |
| 432 |
* Text::CSV_XS uses keep_meta_info instead of get_flags |
| 433 |
* Removed always_quote from xlscat's CSV output |
| 434 |
|
| 435 |
0.20 - 31 May 2007, H.Merijn Brand |
| 436 |
* perlcritic OK |
| 437 |
* CSV parsing now uses getline (), and auto-detects eol |
| 438 |
Assumes first line does not contain embedded eol. This implies that |
| 439 |
parsing CSV with embedded eol sequences is now safe. |
| 440 |
* As I now also maintain Text::CSV_XS, I changed the references |
| 441 |
* Changed TODO's from Text::CSV to Text::CSV_PP (::CSV is dated 1997) |
| 442 |
|
| 443 |
0.19 - 04 May 2007, H.Merijn Brand |
| 444 |
* Could not retreive '0' fields from OpenOffice (Jim Kelly) |
| 445 |
|
| 446 |
0.18 - 27 Apr 2007, H.Merijn Brand |
| 447 |
* use strict in Makefile.PL |
| 448 |
* Added test_cover make target |
| 449 |
* Added "ods" for OpenOffice conversions |
| 450 |
* Added color tests for ods (but SR::RS doesn't support that yet) |
| 451 |
* Switched from \d to 0-9 in regexp |
| 452 |
* Added more test files and tests (increase coverage) |
| 453 |
|
| 454 |
0.17 - 04 Jul 2006, H.Merijn Brand |
| 455 |
* xlscat new option: --ansii to (try to) use the ansi colors for fields |
| 456 |
* Fixed a color attribute off-by-one error |
| 457 |
* Added test cases (not yet complete) |
| 458 |
* Added bold and underline |
| 459 |
|
| 460 |
0.16 - 04 Jul 2006, H.Merijn Brand |
| 461 |
* xlscat new option: --in-sep-char to force-define input sep-char for CSV |
| 462 |
* More debug lines |
| 463 |
* Parser name info in $ref->[0] |
| 464 |
* SquirrelCalc now reports Spreadsheet::Read and its version for parser info |
| 465 |
* Most of the attributes for Excel now implemented. Tested, but no test case |
| 466 |
|
| 467 |
0.15 - 21 Jun 2006, H.Merijn Brand |
| 468 |
* Small doc change from AnnoCPAN |
| 469 |
* Sheets with undefined labels might cause havoc |
| 470 |
* Clip now skips empty xls sheets (TODO: sxc) |
| 471 |
* xlscat clips by default |
| 472 |
* xlscat new options -d and --noclip |
| 473 |
* xlscat usage () from -?/--help to STDOUT from fault to STDERR |
| 474 |
|
| 475 |
0.14 - 20 Jan 2006, H.Merijn Brand |
| 476 |
* maxrow and maxcol were swapped in csv sheets |
| 477 |
* promoted internal debug flag to option |
| 478 |
* small doc changes |
| 479 |
|
| 480 |
0.13 - 04 Nov 2005, H.Merijn Brand |
| 481 |
* Control attrib 'cells' was misinterpreted |
| 482 |
* New option: clip, default is true if {cell} is selected, false otherwise |
| 483 |
Removes trailing lines and columns in each sheet that have no visible data |
| 484 |
* new test t/11_call.t for checking options. Not complete yet |
| 485 |
* Added test_cover target to Makefile.PL |
| 486 |
|
| 487 |
0.12 - 31 Oct 2005, H.Merijn Brand |
| 488 |
* Added ss2tk to examples |
| 489 |
|
| 490 |
0.11 - 26 Oct 2005, H.Merijn Brand |
| 491 |
* Allow ods (OpenOffice 2.0) for sxc |
| 492 |
* include real ods test files and new test |
| 493 |
* Check if sc.version is undef, not 0 |
| 494 |
|
| 495 |
0.10 - 19 Sep 2005, H.Merijn Brand |
| 496 |
* More test coverage |
| 497 |
* cr2cell () returns "" for illegal col/row values |
| 498 |
* cell2cr () returns (0, 0) for illegal cell values |
| 499 |
* rows () tests even better for valid reference pointer |
| 500 |
* Renamed the test files |
| 501 |
|
| 502 |
0.09 - 18 Sep 2005, H.Merijn Brand |
| 503 |
* Added Test::Pod |
| 504 |
* Added Test::Pod::Coverage |
| 505 |
* Spreadsheet::ReadSXC 0.20 now required (too many tests fail on 0.12) |
| 506 |
* Small changes to the docs |
| 507 |
* More secure handling of false values |
| 508 |
* Mention a bug in Spreadsheet::ParseExcel |
| 509 |
|
| 510 |
0.08 - 22 Aug 2005, H.Merijn Brand |
| 511 |
* Slightly changed the Synopsis |
| 512 |
|
| 513 |
0.07 - 06 Jul 2005, H.Merijn Brand |
| 514 |
* Added function rows () |
| 515 |
* Added function parses () |
| 516 |
* Made all modules optional |
| 517 |
* Prepared for Spreadsheet::Perl |
| 518 |
* Doc updates |
| 519 |
|
| 520 |
0.06 - 22 Jun 2005, H.Merijn Brand |
| 521 |
* Repaired error in label names in metadata for SXC |
| 522 |
|
| 523 |
0.05 - 17 Jun 2005, H.Merijn Brand |
| 524 |
* Spreadsheet::ReadSXC >= 0.20 supports sheet order |
| 525 |
* Spreadsheet::ReadSXC has new data structure (we still support the old) |
| 526 |
* Added "version" to the meta data for parser version |
| 527 |
* More tests |
| 528 |
|
| 529 |
0.04 - 14 Jun 2005, H.Merijn Brand |
| 530 |
* Changed TODO |
| 531 |
* Added options "rc", and "cell" |
| 532 |
* Added CSV |
| 533 |
* Added CSV options "sep", and "quote" |
| 534 |
* Support xls from content |
| 535 |
* Added basic support for SquirrelCalc format |
| 536 |
* Updated pod |
| 537 |
* xlscat -R option for row selection was a one-off |
| 538 |
* xlscat now supports selecting fields with -F |
| 539 |
|
| 540 |
0.03 - 19 May 2005, H.Merijn Brand |
| 541 |
* Expanded xlscat to support -i for index |
| 542 |
* Optionally install xlscat |
| 543 |
|
| 544 |
0.02 - 19 May 2005, H.Merijn Brand |
| 545 |
* Typoes in the doc |
| 546 |
* Small change in organization so it actually installs |
| 547 |
|
| 548 |
0.01 - 12 May 2005, H.Merijn Brand |
| 549 |
* Initial CPAN version. A lot can still change |