Re: Spread***::Read 0.20

On May 31, 8:38 am, "H.Merijn Brand" <h.m.br...@xxxxxxxxx> 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/Spread***-Read-0.20.tgz
size: 64234 bytes
md5: a74f3c99d5181748cdbdefa9a2178d88

Hi, Merijn,

I was trying to install Spread***::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 Spread*** to plain text or
CSV) ? [n] y
Do you want to install 'ss2tk' (Show a Spread*** in Perl/Tk) ? [n]
y
Writing Makefile for Spread***::Read
# make
cp Read.pm blib/lib/Spread***/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/Spread***::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 '*** count'
# in t/30_xls.t at line 39.
# got: undef
# expected: '2'
t/30_xls.......NOK
55
# Failed test '*** 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: Spread***::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 - Spread*** type
ok 7 - *** count
ok 8 - *** list
ok 9 - *** 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 - Spread*** type
not ok 53 - *** count
# Failed test '*** count'
# in t/30_xls.t at line 39.
# got: undef
# expected: '2'
ok 54 - *** list
not ok 55 - *** list count
# Failed test '*** 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.

.