[ANN] Spreadsheet::Read 0.20

0.20 Fri 30 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)

has entered CPAN as

file: $CPAN/authors/id/H/HM/HMBRAND/Spreadsheet-Read-0.20.tgz
size: 64234 bytes
md5: a74f3c99d5181748cdbdefa9a2178d88

Re: Spreadsheet::Read 0.20

On May 31, 8:38 am, "H.Merijn Brand" wrote:
> 0.20 Fri 30 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)
>
> has entered CPAN as
>
> file: $CPAN/authors/id/H/HM/HMBRAND/Spreadsheet-Read-0.20.tgz
> size: 64234 bytes
> md5: a74f3c99d5181748cdbdefa9a2178d88

Hi, Merijn,

I was trying to install Spreadsheet::Read 0.22 but met some failed
testing. The following is the report from the whole installation
procedure, what should I do?

I'm on Solaris 9/Sparc, I believe I've installed all the
prerequisites.

TIA.
Alan

#########################################
# perl Makefile.PL
Do you want to install 'xlscat' (Convert Spreadsheet to plain text or
CSV) ? [n] y
Do you want to install 'ss2tk' (Show a Spreadsheet in Perl/Tk) ? [n]
y
Writing Makefile for Spreadsheet::Read
# make
cp Read.pm blib/lib/Spreadsheet/Read.pm
cp examples/ss2tk blib/script/ss2tk
/usr/local/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/
ss2tk
cp examples/xlscat blib/script/xlscat
/usr/local/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script/
xlscat
Manifying blib/man3/Spreadsheet::Read.3
# make test
PERL_DL_NONLAZY=1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e"
"test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
t/00_pod.......skipped
all skipped: Test::Pod 1.00 required for testing POD
t/01_pod.......skipped
all skipped: Test::Pod::Covarage required for testing POD
Coverage
t/
10_basics....ok
t/
11_call......ok
t/
20_csv.......ok
t/
21_csv.......ok
t/30_xls.......NOK
53
# Failed test 'Sheet count'
# in t/30_xls.t at line 39.
# got: undef
# expected: '2'
t/30_xls.......NOK
55
# Failed test 'Sheet list count'
# in t/30_xls.t at line 41.
# got: '0'
# expected: '2'
t/30_xls.......NOK
58
# Failed test 'Unformatted cell A1'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'A1'
t/30_xls.......NOK
59
# Failed test 'Formatted cell A1'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'A1'
t/30_xls.......NOK
60
# Failed test 'Unformatted cell A2'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'A2'
t/30_xls.......NOK
61
# Failed test 'Formatted cell A2'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'A2'
t/30_xls.......NOK
62
# Failed test 'Unformatted cell A3'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'A3'
t/30_xls.......NOK
63
# Failed test 'Formatted cell A3'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'A3'
t/30_xls.......NOK
64
# Failed test 'Unformatted cell A4'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'A4'
t/30_xls.......NOK
65
# Failed test 'Formatted cell A4'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'A4'
t/30_xls.......NOK
66
# Failed test 'Unformatted cell B1'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'B1'
t/30_xls.......NOK
67
# Failed test 'Formatted cell B1'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'B1'
t/30_xls.......NOK
68
# Failed test 'Unformatted cell B2'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'B2'
t/30_xls.......NOK
69
# Failed test 'Formatted cell B2'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'B2'
t/30_xls.......NOK
70
# Failed test 'Unformatted cell B4'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'B4'
t/30_xls.......NOK
71
# Failed test 'Formatted cell B4'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'B4'
t/30_xls.......NOK
72
# Failed test 'Unformatted cell C3'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'C3'
t/30_xls.......NOK
73
# Failed test 'Formatted cell C3'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'C3'
t/30_xls.......NOK
74
# Failed test 'Unformatted cell C4'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'C4'
t/30_xls.......NOK
75
# Failed test 'Formatted cell C4'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'C4'
t/30_xls.......NOK
76
# Failed test 'Unformatted cell D1'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'D1'
t/30_xls.......NOK
77
# Failed test 'Formatted cell D1'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'D1'
t/30_xls.......NOK
78
# Failed test 'Unformatted cell D3'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'D3'
t/30_xls.......NOK
79
# Failed test 'Formatted cell D3'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'D3'

# Failed test 'Row'ed rows'
# in t/30_xls.t at line 59.
# got: '0'
# expected: '4'
Can't use an undefined value as an ARRAY reference at t/30_xls.t line
60.
# Looks like you planned 217 tests but only ran 91.
# Looks like you failed 25 tests of 91 run.
# Looks like your test died just after 91.
t/
30_xls.......dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 53, 55, 58-79, 91-217
Failed 151/217 tests, 30.41% okay
t/
31_clr.......ok
t/
32_fmt.......ok
t/
33_misc......ok
t/
40_sxc.......ok
t/
45_ods.......ok
t/46_clr.......skipped
all skipped: Spreadsheet::ReadSXC version 0.20 doesn't support
field attributes
t/
50_sc........ok
Failed Test Stat Wstat Total Fail Failed List of Failed
------------------------------------------------------------ -------------------
t/30_xls.t 255 65280 217 277 127.65% 53 55 58-79 91-217
3 tests skipped.
Failed 1/14 test scripts, 92.86% okay. 151/1471 subtests failed,
89.73% okay.
make: *** [test_dynamic] Error 29
# perl -Mblib t/30_xls.t
1..217
ok 1 - Nonexistent file
ok 2 - Empty file
ok 3 - Read/Parse xls file
ok 4 - Base values
ok 5 - Return type
ok 6 - Spreadsheet type
ok 7 - Sheet count
ok 8 - Sheet list
ok 9 - Sheet list count
ok 10 - Parser version
ok 11 - Defined fields
ok 12 - Unformatted cell A1
ok 13 - Formatted cell A1
ok 14 - Unformatted cell A2
ok 15 - Formatted cell A2
ok 16 - Unformatted cell A3
ok 17 - Formatted cell A3
ok 18 - Unformatted cell A4
ok 19 - Formatted cell A4
ok 20 - Unformatted cell B1
ok 21 - Formatted cell B1
ok 22 - Unformatted cell B2
ok 23 - Formatted cell B2
ok 24 - Unformatted cell B4
ok 25 - Formatted cell B4
ok 26 - Unformatted cell C3
ok 27 - Formatted cell C3
ok 28 - Unformatted cell C4
ok 29 - Formatted cell C4
ok 30 - Unformatted cell D1
ok 31 - Formatted cell D1
ok 32 - Unformatted cell D3
ok 33 - Formatted cell D3
ok 34 - Undefined fields
ok 35 - Unformatted cell B3
ok 36 - Formatted cell B3
ok 37 - Unformatted cell C1
ok 38 - Formatted cell C1
ok 39 - Unformatted cell C2
ok 40 - Formatted cell C2
ok 41 - Unformatted cell D2
ok 42 - Formatted cell D2
ok 43 - Unformatted cell D4
ok 44 - Formatted cell D4
ok 45 - Row'ed rows
ok 46 - Row'ed columns
ok 47 - Row'ed value D1
ok 48 - Row'ed value C4
ok 49 - Parse xls data
ok 50 - Base values
ok 51 - Return type
ok 52 - Spreadsheet type
not ok 53 - Sheet count
# Failed test 'Sheet count'
# in t/30_xls.t at line 39.
# got: undef
# expected: '2'
ok 54 - Sheet list
not ok 55 - Sheet list count
# Failed test 'Sheet list count'
# in t/30_xls.t at line 41.
# got: '0'
# expected: '2'
ok 56 - Parser version
ok 57 - Defined fields
not ok 58 - Unformatted cell A1
# Failed test 'Unformatted cell A1'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'A1'
not ok 59 - Formatted cell A1
# Failed test 'Formatted cell A1'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'A1'
not ok 60 - Unformatted cell A2
# Failed test 'Unformatted cell A2'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'A2'
not ok 61 - Formatted cell A2
# Failed test 'Formatted cell A2'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'A2'
not ok 62 - Unformatted cell A3
# Failed test 'Unformatted cell A3'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'A3'
not ok 63 - Formatted cell A3
# Failed test 'Formatted cell A3'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'A3'
not ok 64 - Unformatted cell A4
# Failed test 'Unformatted cell A4'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'A4'
not ok 65 - Formatted cell A4
# Failed test 'Formatted cell A4'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'A4'
not ok 66 - Unformatted cell B1
# Failed test 'Unformatted cell B1'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'B1'
not ok 67 - Formatted cell B1
# Failed test 'Formatted cell B1'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'B1'
not ok 68 - Unformatted cell B2
# Failed test 'Unformatted cell B2'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'B2'
not ok 69 - Formatted cell B2
# Failed test 'Formatted cell B2'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'B2'
not ok 70 - Unformatted cell B4
# Failed test 'Unformatted cell B4'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'B4'
not ok 71 - Formatted cell B4
# Failed test 'Formatted cell B4'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'B4'
not ok 72 - Unformatted cell C3
# Failed test 'Unformatted cell C3'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'C3'
not ok 73 - Formatted cell C3
# Failed test 'Formatted cell C3'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'C3'
not ok 74 - Unformatted cell C4
# Failed test 'Unformatted cell C4'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'C4'
not ok 75 - Formatted cell C4
# Failed test 'Formatted cell C4'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'C4'
not ok 76 - Unformatted cell D1
# Failed test 'Unformatted cell D1'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'D1'
not ok 77 - Formatted cell D1
# Failed test 'Formatted cell D1'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'D1'
not ok 78 - Unformatted cell D3
# Failed test 'Unformatted cell D3'
# in t/30_xls.t at line 48.
# got: undef
# expected: 'D3'
not ok 79 - Formatted cell D3
# Failed test 'Formatted cell D3'
# in t/30_xls.t at line 49.
# got: undef
# expected: 'D3'
ok 80 - Undefined fields
ok 81 - Unformatted cell B3
ok 82 - Formatted cell B3
ok 83 - Unformatted cell C1
ok 84 - Formatted cell C1
ok 85 - Unformatted cell C2
ok 86 - Formatted cell C2
ok 87 - Unformatted cell D2
ok 88 - Formatted cell D2
ok 89 - Unformatted cell D4
ok 90 - Formatted cell D4
not ok 91 - Row'ed rows
# Failed test 'Row'ed rows'
# in t/30_xls.t at line 59.
# got: '0'
# expected: '4'
Can't use an undefined value as an ARRAY reference at t/30_xls.t line
60.
# Looks like you planned 217 tests but only ran 91.
# Looks like you failed 25 tests of 91 run.
# Looks like your test died just after 91.

Re: Spreadsheet::Read 0.20

Thanks to David Cantrell, who ran into the same problems on OpenBSD, and=
=

kindly
offered my access to the failing box, I think I have nailed it down.

0.23 has entered CPAN as

file: $CPAN/authors/id/H/HM/HMBRAND/Spreadsheet-Read-0.23.tar.gz
size: 64710 bytes
md5: 8d9c6b8f7ca38ef6966724ccc3090b45

No action is required on your part
Request entered by: HMBRAND (H.Merijn Brand)
Request entered on: Thu, 21 Jun 2007 10:51:24 GMT
Request completed: Thu, 21 Jun 2007 10:52:58 GMT

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 th=
at
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 199=
7)

On Wed, 20 Jun 2007 18:00:57 +0200, wrote:

> On May 31, 8:38 am, "H.Merijn Brand" wrote:
>> 0.20 Fri 30 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)
>
> Hi, Merijn,
>
> I was trying to install Spreadsheet::Read 0.22 but met some failed
> testing. The following is the report from the whole installation
> procedure, what should I do?
>
> I'm on Solaris 9/Sparc, I believe I've installed all the
> prerequisites.
>
> TIA.
> Alan
>
> #########################################
> # perl Makefile.PL
> Do you want to install 'xlscat' (Convert Spreadsheet to plain text or
> CSV) ? [n] y
> Do you want to install 'ss2tk' (Show a Spreadsheet in Perl/Tk) ? [n]
> y
> Writing Makefile for Spreadsheet::Read
> # make
> cp Read.pm blib/lib/Spreadsheet/Read.pm
> cp examples/ss2tk blib/script/ss2tk
> /usr/local/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script=
/
> ss2tk
> cp examples/xlscat blib/script/xlscat
> /usr/local/bin/perl "-MExtUtils::MY" -e "MY->fixin(shift)" blib/script=
/
> xlscat
> Manifying blib/man3/Spreadsheet::Read.3
> # make test
> PERL_DL_NONLAZY=3D1 /usr/local/bin/perl "-MExtUtils::Command::MM" "-e"=

> "test_harness(0, 'blib/lib', 'blib/arch')" t/*.t
> t/00_pod.......skipped
> all skipped: Test::Pod 1.00 required for testing POD
> t/01_pod.......skipped
> all skipped: Test::Pod::Covarage required for testing POD
> Coverage
> t/
> 10_basics....ok
> t/
> 11_call......ok
> t/
> 20_csv.......ok
> t/
> 21_csv.......ok
> t/30_xls.......NOK
> 53
> # Failed test 'Sheet count'
> # in t/30_xls.t at line 39.
> # got: undef
> # expected: '2'
> t/30_xls.......NOK
> 55
> # Failed test 'Sheet list count'
> # in t/30_xls.t at line 41.
> # got: '0'
> # expected: '2'
> t/30_xls.......NOK
> 58
> # Failed test 'Unformatted cell A1'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'A1'
> t/30_xls.......NOK
> 59
> # Failed test 'Formatted cell A1'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'A1'
> t/30_xls.......NOK
> 60
> # Failed test 'Unformatted cell A2'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'A2'
> t/30_xls.......NOK
> 61
> # Failed test 'Formatted cell A2'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'A2'
> t/30_xls.......NOK
> 62
> # Failed test 'Unformatted cell A3'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'A3'
> t/30_xls.......NOK
> 63
> # Failed test 'Formatted cell A3'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'A3'
> t/30_xls.......NOK
> 64
> # Failed test 'Unformatted cell A4'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'A4'
> t/30_xls.......NOK
> 65
> # Failed test 'Formatted cell A4'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'A4'
> t/30_xls.......NOK
> 66
> # Failed test 'Unformatted cell B1'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'B1'
> t/30_xls.......NOK
> 67
> # Failed test 'Formatted cell B1'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'B1'
> t/30_xls.......NOK
> 68
> # Failed test 'Unformatted cell B2'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'B2'
> t/30_xls.......NOK
> 69
> # Failed test 'Formatted cell B2'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'B2'
> t/30_xls.......NOK
> 70
> # Failed test 'Unformatted cell B4'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'B4'
> t/30_xls.......NOK
> 71
> # Failed test 'Formatted cell B4'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'B4'
> t/30_xls.......NOK
> 72
> # Failed test 'Unformatted cell C3'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'C3'
> t/30_xls.......NOK
> 73
> # Failed test 'Formatted cell C3'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'C3'
> t/30_xls.......NOK
> 74
> # Failed test 'Unformatted cell C4'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'C4'
> t/30_xls.......NOK
> 75
> # Failed test 'Formatted cell C4'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'C4'
> t/30_xls.......NOK
> 76
> # Failed test 'Unformatted cell D1'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'D1'
> t/30_xls.......NOK
> 77
> # Failed test 'Formatted cell D1'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'D1'
> t/30_xls.......NOK
> 78
> # Failed test 'Unformatted cell D3'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'D3'
> t/30_xls.......NOK
> 79
> # Failed test 'Formatted cell D3'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'D3'
>
> # Failed test 'Row'ed rows'
> # in t/30_xls.t at line 59.
> # got: '0'
> # expected: '4'
> Can't use an undefined value as an ARRAY reference at t/30_xls.t line
> 60.
> # Looks like you planned 217 tests but only ran 91.
> # Looks like you failed 25 tests of 91 run.
> # Looks like your test died just after 91.
> t/
> 30_xls.......dubious
> Test returned status 255 (wstat 65280, 0xff00)
> DIED. FAILED tests 53, 55, 58-79, 91-217
> Failed 151/217 tests, 30.41% okay
> t/
> 31_clr.......ok
> t/
> 32_fmt.......ok
> t/
> 33_misc......ok
> t/
> 40_sxc.......ok
> t/
> 45_ods.......ok
> t/46_clr.......skipped
> all skipped: Spreadsheet::ReadSXC version 0.20 doesn't support=

> field attributes
> t/
> 50_sc........ok
> Failed Test Stat Wstat Total Fail Failed List of Failed
> ------------------------------------------------------------ ----------=
---------
> t/30_xls.t 255 65280 217 277 127.65% 53 55 58-79 91-217
> 3 tests skipped.
> Failed 1/14 test scripts, 92.86% okay. 151/1471 subtests failed,
> 89.73% okay.
> make: *** [test_dynamic] Error 29
> # perl -Mblib t/30_xls.t
> 1..217
> ok 1 - Nonexistent file
> ok 2 - Empty file
> ok 3 - Read/Parse xls file
> ok 4 - Base values
> ok 5 - Return type
> ok 6 - Spreadsheet type
> ok 7 - Sheet count
> ok 8 - Sheet list
> ok 9 - Sheet list count
> ok 10 - Parser version
> ok 11 - Defined fields
> ok 12 - Unformatted cell A1
> ok 13 - Formatted cell A1
> ok 14 - Unformatted cell A2
> ok 15 - Formatted cell A2
> ok 16 - Unformatted cell A3
> ok 17 - Formatted cell A3
> ok 18 - Unformatted cell A4
> ok 19 - Formatted cell A4
> ok 20 - Unformatted cell B1
> ok 21 - Formatted cell B1
> ok 22 - Unformatted cell B2
> ok 23 - Formatted cell B2
> ok 24 - Unformatted cell B4
> ok 25 - Formatted cell B4
> ok 26 - Unformatted cell C3
> ok 27 - Formatted cell C3
> ok 28 - Unformatted cell C4
> ok 29 - Formatted cell C4
> ok 30 - Unformatted cell D1
> ok 31 - Formatted cell D1
> ok 32 - Unformatted cell D3
> ok 33 - Formatted cell D3
> ok 34 - Undefined fields
> ok 35 - Unformatted cell B3
> ok 36 - Formatted cell B3
> ok 37 - Unformatted cell C1
> ok 38 - Formatted cell C1
> ok 39 - Unformatted cell C2
> ok 40 - Formatted cell C2
> ok 41 - Unformatted cell D2
> ok 42 - Formatted cell D2
> ok 43 - Unformatted cell D4
> ok 44 - Formatted cell D4
> ok 45 - Row'ed rows
> ok 46 - Row'ed columns
> ok 47 - Row'ed value D1
> ok 48 - Row'ed value C4
> ok 49 - Parse xls data
> ok 50 - Base values
> ok 51 - Return type
> ok 52 - Spreadsheet type
> not ok 53 - Sheet count
> # Failed test 'Sheet count'
> # in t/30_xls.t at line 39.
> # got: undef
> # expected: '2'
> ok 54 - Sheet list
> not ok 55 - Sheet list count
> # Failed test 'Sheet list count'
> # in t/30_xls.t at line 41.
> # got: '0'
> # expected: '2'
> ok 56 - Parser version
> ok 57 - Defined fields
> not ok 58 - Unformatted cell A1
> # Failed test 'Unformatted cell A1'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'A1'
> not ok 59 - Formatted cell A1
> # Failed test 'Formatted cell A1'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'A1'
> not ok 60 - Unformatted cell A2
> # Failed test 'Unformatted cell A2'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'A2'
> not ok 61 - Formatted cell A2
> # Failed test 'Formatted cell A2'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'A2'
> not ok 62 - Unformatted cell A3
> # Failed test 'Unformatted cell A3'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'A3'
> not ok 63 - Formatted cell A3
> # Failed test 'Formatted cell A3'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'A3'
> not ok 64 - Unformatted cell A4
> # Failed test 'Unformatted cell A4'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'A4'
> not ok 65 - Formatted cell A4
> # Failed test 'Formatted cell A4'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'A4'
> not ok 66 - Unformatted cell B1
> # Failed test 'Unformatted cell B1'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'B1'
> not ok 67 - Formatted cell B1
> # Failed test 'Formatted cell B1'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'B1'
> not ok 68 - Unformatted cell B2
> # Failed test 'Unformatted cell B2'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'B2'
> not ok 69 - Formatted cell B2
> # Failed test 'Formatted cell B2'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'B2'
> not ok 70 - Unformatted cell B4
> # Failed test 'Unformatted cell B4'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'B4'
> not ok 71 - Formatted cell B4
> # Failed test 'Formatted cell B4'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'B4'
> not ok 72 - Unformatted cell C3
> # Failed test 'Unformatted cell C3'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'C3'
> not ok 73 - Formatted cell C3
> # Failed test 'Formatted cell C3'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'C3'
> not ok 74 - Unformatted cell C4
> # Failed test 'Unformatted cell C4'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'C4'
> not ok 75 - Formatted cell C4
> # Failed test 'Formatted cell C4'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'C4'
> not ok 76 - Unformatted cell D1
> # Failed test 'Unformatted cell D1'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'D1'
> not ok 77 - Formatted cell D1
> # Failed test 'Formatted cell D1'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'D1'
> not ok 78 - Unformatted cell D3
> # Failed test 'Unformatted cell D3'
> # in t/30_xls.t at line 48.
> # got: undef
> # expected: 'D3'
> not ok 79 - Formatted cell D3
> # Failed test 'Formatted cell D3'
> # in t/30_xls.t at line 49.
> # got: undef
> # expected: 'D3'
> ok 80 - Undefined fields
> ok 81 - Unformatted cell B3
> ok 82 - Formatted cell B3
> ok 83 - Unformatted cell C1
> ok 84 - Formatted cell C1
> ok 85 - Unformatted cell C2
> ok 86 - Formatted cell C2
> ok 87 - Unformatted cell D2
> ok 88 - Formatted cell D2
> ok 89 - Unformatted cell D4
> ok 90 - Formatted cell D4
> not ok 91 - Row'ed rows
> # Failed test 'Row'ed rows'
> # in t/30_xls.t at line 59.
> # got: '0'
> # expected: '4'
> Can't use an undefined value as an ARRAY reference at t/30_xls.t line
> 60.
> # Looks like you planned 217 tests but only ran 91.
> # Looks like you failed 25 tests of 91 run.
> # Looks like your test died just after 91.
>