Skip Menu |

Preferred bug tracker

Please visit the preferred bug tracker to report your issue.

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

Maintainer(s)' notes

If you are reporting a bug in Spreadsheet::ParseExcel 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::ParseExcel
                      Scalar::Util
                      Unicode::Map
                      Spreadsheet::WriteExcel
                      Parse::RecDescent
                      File::Temp
                      OLE::Storage_Lite
                      IO::Stringy
                    );

    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::ParseExcel (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 example program that demonstrates your problem. The program should be as small as possible. A few lines of codes are worth tens of lines of text when trying to describe a bug.

5) Supply an Excel file that demonstrates the problem. This is very important. If the file is big, or contains confidential information, try to reduce it down to the smallest Excel file that represents the issue. If you don't wish to post a file here then send it to me directly: jmcnamara@cpan.org

6) Say if the test file was created by Excel, OpenOffice, Gnumeric or something else. Say which version of that application you used.

7) If you are submitting a patch you should check with the maintainer 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::ParseExcel Google Group.

Maintainer(s)

DOUGW, JMCNAMARA, KWITKNR

Bugs

ID Subject Status Severity Last Updated Broken in Fixed in
103919 Uninitialized value errors when parsing file open 6 years ago
16786 RSTRING doesn't know about BIFF8 (unicode) strings open Normal 7 years ago 0.2603
60092 Partially able to parse file from scientific plate reader open 7 years ago
72146 Potential bug with ParseExcel open 7 years ago
63386 Better detection of date-fields open Wishlist 7 years ago 0.58
43042 row_range returns erroneous results when CellHandler is being used open Normal 7 years ago 0.49
81737 $cell->unformatted() does not handle UTF-8 correctly open Normal 7 years ago
24830 new methods FreezePanes() / ThawPanes() (SaveParser) open Normal 7 years ago 0.33
93366 Column formats are not applied new 7 years ago 0.59
93067 Need API to return accurate Width and height units new 7 years ago 0.59
87974 Feature request: conditional formatting open 7 years ago
76677 Fields that straddle columns do not return the value of the first cell. open 9 years ago
67814 SaveParser doesn't copy formulas open Critical 10 years ago 0.59
67056 Problem with use Spreadsheet::ParseExcel::SaveParser; open 10 years ago
60165 SaveParser doesn't map source colour palette to new workbook new 10 years ago
59028 Parse fails to properly interpret spreadsheet containing an EMBED open 10 years ago
46995 Saveparse unhides hidden worksheets (SaveParser) new 12 years ago
42446 Formulas which reference subsequent worksheets cannot be saved (SaveParser) new Normal 12 years ago 0.45
32997 SaveParser does not handle merged cells correctly (SaveParser) new Important 12 years ago 0.32
14430 "Rich" formatting is not written (Saveparser) new Normal 12 years ago 0.2603
28476 Path to CP932.map must be fixed in FmtJapan2.pm open 12 years ago
39203 Patch against v0.33 enabling Excel formula parsing and evaluation open Wishlist 12 years ago 0.33