Skip Menu |

This queue is for tickets about the Spreadsheet-WriteExcel CPAN distribution.

Maintainer(s)' notes

If you are reporting a bug in Spreadsheet::WriteExcel here are some pointers

1) State the issues as clearly and as concisely as possible. A simple program or Excel test file (see below) will often explain the issue better than a lot of text.

2) Provide information on your system, version of perl and module versions. The following program will generate everything that is required. Put this information in your bug report. 

    #!/usr/bin/perl -w

    print "\n    Perl version   : $]";
    print "\n    OS name        : $^O";
    print "\n    Module versions: (not all are required)\n";

    my @modules = qw(
                      Spreadsheet::WriteExcel
                      Parse::RecDescent
                      File::Temp
                      OLE::Storage_Lite
                      IO::Stringy
                      Spreadsheet::ParseExcel
                      Scalar::Util
                      Unicode::Map
                    );

    for my $module (@modules) {
        my $version;
        eval "require $module";

        if (not $@) {
            $version = $module->VERSION;
            $version = '(unknown)' if not defined $version;
        }
        else {
            $version = '(not installed)';
        }

        printf "%21s%-24s\t%s\n", "", $module, $version;
    }

    __END__

3) Upgrade to the latest version of Spreadsheet::WriteExcel (or at least test on a system with an upgraded version). The issue you are reporting may already have been fixed.

4) Create a small but complete example program that demonstrates your problem. The program should be as small as possible. At the same time it should be a complete program that generates an Excel file. If the Spreadsheet::WriteExcel section is part of a much larger program then simplify it down to the essentials. Simulate any DB reads with an array.

5) Say if you tested with Excel, OpenOffice, Gnumeric or something else. Say which version of that application you used.

6) If you are submitting a patch you should check with the author whether the issue has already been patched or if a fix is in the works. Patches should be accompanied by test cases.

Asking a question

If you would like to ask a more general question there is the Spreadsheet::WriteExcel Google Group.

Report information
The Basics
Id: 52266
Status: resolved
Priority: 0/
Queue: Spreadsheet-WriteExcel
People
Owner: Nobody in particular
Requestors: D.BARBE [...] csb.nc
Cc:
AdminCc:
Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: (no value)

History Show all quoted text
  Sun Nov 29 18:49:38 2009 D.BARBE [...] csb.nc - Ticket created
CC: EDI <EDI [...] csb.nc>
Subject: Spreadsheet-WriteExcel-2.30: make test failed
Date: Mon, 30 Nov 2009 10:49:02 +1100
To: "'bug-Spreadsheet-WriteExcel [...] rt.cpan.org'" <bug-Spreadsheet-WriteExcel [...] rt.cpan.org>
From: BARBE David <D.BARBE [...] csb.nc>
Hi, I try to install Spreadsheet-WriteExcel-2.30 in this environment : OS : Red Hat Linux release 8.0 (Psyche) Perl : 5.8.0 printenv command gives : (...) LC_ALL=fr_FR.UTF-8 LANG=fr_FR.UTF-8 LANGUAGE=fr_FR.UTF-8 LC_CTYPE=fr_FR.UTF-8 (...) but make test failed. t/40_property_types...........1..13 ok 1 - Doc properties: _pack_VT_I2(1252) ok 2 - Doc properties: _pack_VT_LPSTR('', 1252') ok 3 - Doc properties: _pack_VT_LPSTR('a', 1252') ok 4 - Doc properties: _pack_VT_LPSTR('bb', 1252') ok 5 - Doc properties: _pack_VT_LPSTR('ccc', 1252') ok 6 - Doc properties: _pack_VT_LPSTR('dddd', 1252') ok 7 - Doc properties: _pack_VT_LPSTR('Username', 1252') not ok 8 - Doc properties: _pack_VT_LPSTR('$smiley', 65001') # Failed test (t/40_property_types.t at line 155) # got: '1E 00 00 00 02 00 00 00 E2 98 BA 00 00 00' # expected: '1E 00 00 00 04 00 00 00 E2 98 BA 00' not ok 9 - Doc properties: _pack_VT_LPSTR('a$smiley', 65001') # Failed test (t/40_property_types.t at line 177) # got: '1E 00 00 00 03 00 00 00 61 E2 98 BA 00 00' # expected: '1E 00 00 00 05 00 00 00 61 E2 98 BA 00 00 00 00' not ok 10 - Doc properties: _pack_VT_LPSTR('aa$smiley', 65001') # Failed test (t/40_property_types.t at line 199) # got: '1E 00 00 00 04 00 00 00 61 61 E2 98 BA 00' # expected: '1E 00 00 00 06 00 00 00 61 61 E2 98 BA 00 00 00' not ok 11 - Doc properties: _pack_VT_LPSTR('aaa$smiley', 65001') # Failed test (t/40_property_types.t at line 221) # got: '1E 00 00 00 05 00 00 00 61 61 61 E2 98 BA 00 00 00 00' # expected: '1E 00 00 00 07 00 00 00 61 61 61 E2 98 BA 00 00' not ok 12 - Doc properties: _pack_VT_LPSTR('aaaa$smiley', 65001') # Failed test (t/40_property_types.t at line 243) # got: '1E 00 00 00 06 00 00 00 61 61 61 61 E2 98 BA 00 00 00' # expected: '1E 00 00 00 08 00 00 00 61 61 61 61 E2 98 BA 00' ok 13 - Doc properties: _pack_VT_FILETIME() # Looks like you failed 5 tests of 13. dubious Test returned status 5 (wstat 1280, 0x500) DIED. FAILED tests 8-12 Failed 5/13 tests, 61.54% okay (...) t/42_set_properties...........1..17 ok 1 - _get_property_set_codepage('latin1') ok 2 - _get_property_set_codepage('utf8') ok 3 - _get_property_set_codepage('utf8') ok 4 - set_properties(codepage) ok 5 - set_properties('Title') ok 6 - set_properties('+ Subject') ok 7 - set_properties('+ Author') ok 8 - set_properties('+ Keywords') ok 9 - set_properties('+ Comments') ok 10 - set_properties('+ Last author') ok 11 - set_properties('+ Creation date') ok 12 - set_properties('+ Creation date') ok 13 - set_properties({hash}) not ok 14 - set_properties(utf8) # Failed test (t/42_set_properties.t at line 492) # got: 'C3 BE C3 BF 00 00 05 01 02 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 C3 A0 C2 85 C2 9F C3 B2 C3 B9 4F 68 10 C2 AB C2 91 08 00 2B 27 C2 B3 C3 99 30 00 00 00 30 00 00 00 02 00 00 00 01 00 00 00 18 00 00 00 02 00 00 00 20 00 00 00 02 00 00 00 C3 A9 C3 BD 00 00 1E 00 00 00 07 00 00 00 54 69 74 6C 65 E2 98 BA 00 00' # expected: 'FE FF 00 00 05 01 02 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 E0 85 9F F2 F9 4F 68 10 AB 91 08 00 2B 27 B3 D9 30 00 00 00 34 00 00 00 02 00 00 00 01 00 00 00 18 00 00 00 02 00 00 00 20 00 00 00 02 00 00 00 E9 FD 00 00 1E 00 00 00 09 00 00 00 54 69 74 6C 65 E2 98 BA 00 00 00 00' not ok 15 - set_properties(utf8) # Failed test (t/42_set_properties.t at line 523) # got: 'C3 BE C3 BF 00 00 05 01 02 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 C3 A0 C2 85 C2 9F C3 B2 C3 B9 4F 68 10 C2 AB C2 91 08 00 2B 27 C2 B3 C3 99 30 00 00 00 4C 00 00 00 03 00 00 00 01 00 00 00 20 00 00 00 02 00 00 00 28 00 00 00 03 00 00 00 3C 00 00 00 02 00 00 00 C3 A9 C3 BD 00 00 1E 00 00 00 09 00 00 00 54 69 74 6C 65 C3 A2 C2 98 C2 BA 00 00 00 00 1E 00 00 00 08 00 00 00 53 75 62 6A 65 63 74 00' # expected: 'FE FF 00 00 05 01 02 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 E0 85 9F F2 F9 4F 68 10 AB 91 08 00 2B 27 B3 D9 30 00 00 00 4C 00 00 00 03 00 00 00 01 00 00 00 20 00 00 00 02 00 00 00 28 00 00 00 03 00 00 00 3C 00 00 00 02 00 00 00 E9 FD 00 00 1E 00 00 00 09 00 00 00 54 69 74 6C 65 E2 98 BA 00 00 00 00 1E 00 00 00 08 00 00 00 53 75 62 6A 65 63 74 00' not ok 16 - set_properties(utf8) # Failed test (t/42_set_properties.t at line 554) # got: 'C3 BE C3 BF 00 00 05 01 02 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 C3 A0 C2 85 C2 9F C3 B2 C3 B9 4F 68 10 C2 AB C2 91 08 00 2B 27 C2 B3 C3 99 30 00 00 00 48 00 00 00 03 00 00 00 01 00 00 00 20 00 00 00 02 00 00 00 28 00 00 00 03 00 00 00 38 00 00 00 02 00 00 00 C3 A9 C3 BD 00 00 1E 00 00 00 07 00 00 00 54 69 74 6C 65 E2 98 BA 00 00 1E 00 00 00 08 00 00 00 53 75 62 6A 65 63 74 00' # expected: 'FE FF 00 00 05 01 02 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 E0 85 9F F2 F9 4F 68 10 AB 91 08 00 2B 27 B3 D9 30 00 00 00 4C 00 00 00 03 00 00 00 01 00 00 00 20 00 00 00 02 00 00 00 28 00 00 00 03 00 00 00 3C 00 00 00 02 00 00 00 E9 FD 00 00 1E 00 00 00 09 00 00 00 54 69 74 6C 65 E2 98 BA 00 00 00 00 1E 00 00 00 08 00 00 00 53 75 62 6A 65 63 74 00' not ok 17 - set_properties(utf8) # Failed test (t/42_set_properties.t at line 586) # got: 'C3 BE C3 BF 00 00 05 01 02 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 C3 A0 C2 85 C2 9F C3 B2 C3 B9 4F 68 10 C2 AB C2 91 08 00 2B 27 C2 B3 C3 99 30 00 00 00 4C 00 00 00 03 00 00 00 01 00 00 00 20 00 00 00 02 00 00 00 28 00 00 00 03 00 00 00 38 00 00 00 02 00 00 00 C3 A9 C3 BD 00 00 1E 00 00 00 06 00 00 00 54 69 74 6C 65 00 00 00 1E 00 00 00 09 00 00 00 53 75 62 6A 65 63 74 E2 98 BA 00 00 00 00' # expected: 'FE FF 00 00 05 01 02 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 01 00 00 00 E0 85 9F F2 F9 4F 68 10 AB 91 08 00 2B 27 B3 D9 30 00 00 00 4C 00 00 00 03 00 00 00 01 00 00 00 20 00 00 00 02 00 00 00 28 00 00 00 03 00 00 00 38 00 00 00 02 00 00 00 E9 FD 00 00 1E 00 00 00 06 00 00 00 54 69 74 6C 65 00 00 00 1E 00 00 00 0B 00 00 00 53 75 62 6A 65 63 74 E2 98 BA 00 00' Wide character in print at /usr/lib/perl5/site_perl/5.8.0/OLE/Storage_Lite.pm line 429. # Looks like you failed 4 tests of 17. dubious Test returned status 4 (wstat 1024, 0x400) DIED. FAILED tests 14-17 Failed 4/17 tests, 76.47% okay (...) Failed Test Stat Wstat Total Fail Failed List of Failed ------------------------------------------------------------------------------- t/40_property_types.t 5 1280 13 5 38.46% 8-12 t/42_set_properties.t 4 1024 17 4 23.53% 14-17 3 tests skipped. Failed 2/34 test scripts, 94.12% okay. 9/1134 subtests failed, 99.21% okay. make: *** [test_dynamic] Erreur 29 How to resolve this problem ? Thanks for your help. David BARBE Etudes et Développements Informatiques CSB - Calédonienne de Services Bancaires BP 415 - 98845 Nouméa Cedex Tél : (687) 26 56 94 @ : d.barbe@csb.nc

Message body is not shown because it is too large.

  Mon Nov 30 05:58:16 2009 jmcnamara [...] cpan.org - Correspondence added
On Sun Nov 29 18:49:38 2009, D.BARBE@csb.nc wrote: Show quoted text
> Hi, > > I try to install Spreadsheet-WriteExcel-2.30 in this environment : > > OS : Red Hat Linux release 8.0 (Psyche) > Perl : 5.8.0 > printenv command gives : > (...) > LC_ALL=fr_FR.UTF-8 > LANG=fr_FR.UTF-8 > LANGUAGE=fr_FR.UTF-8 > LC_CTYPE=fr_FR.UTF-8 > (...) > > but make test failed.
Hi, I think that this may be a perl 5.8.0 issue on Red Hat. I know that there were similar failures with perl 5.7.x and if you have a look at the failing tests you can see that they are marked SKIP for perl < 5.008. I don't see similar failures with perl 5.8.5 on Red Hat with the same env variables set: [Spreadsheet-WriteExcel-2.30]$ uname -a Linux hostname 2.6.9-55.EL #1 Fri Apr 20 16:35:59 EDT 2007 i686 i686 i386 GNU/Linux [Spreadsheet-WriteExcel-2.30]$ perl -v This is perl, v5.8.5 built for i386-linux-thread-multi ... [Spreadsheet-WriteExcel-2.30]$ env | grep FR LC_ALL=fr_FR.UTF-8 LANG=fr_FR.UTF-8 LANGUAGE=fr_FR.UTF-8 LC_CTYPE=fr_FR.UTF-8 [Spreadsheet-WriteExcel-2.30]$ prove t/4* t/40_property_types....ok t/41_properties........ok t/42_set_properties....ok All tests successful. Files=3, Tests=38, 1 wallclock secs Result: PASS I would recommend that you upgrade your perl version to 5.8.8 (or later) if possible or if you aren't using the set_properties() method then you can just ignore the failing tests and force the install. P.S. If you do upgrade your perl and still have problems, let me know. John. --
  Mon Nov 30 05:58:17 2009 The RT System itself - Status changed from 'new' to 'open'
  Wed Nov 21 18:47:50 2012 jmcnamara [...] cpan.org - Status changed from 'open' to 'resolved'