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.

Maintainer(s)

JMCNAMARA

Bugs

ID Subject Status Severity Last Updated Broken in Fixed in
117235 filter_column expression with more than 2 valid values doesn't work resolved 4 years ago
104685 write_url() with undef's for url/description results in somewhat bad .xls resolved 5 years ago
112448 Cannot add chart if the worksheet name contains parenthesis resolved 5 years ago
106721 Bug in write_number (only can write to a cell ONE TIME) resolved 5 years ago
94797 Problem with UTF-8 and formulars resolved 7 years ago
88725 Invalid row value produces confusing error resolved 7 years ago
85897 [PATCH] Fix POD encoding resolved 7 years ago
90061 Can't call method "isa" on an undefined value at /usr/local/share/perl5/Math/BigInt.pm line 1128 resolved 7 years ago
17465 references in second argument to COUNTIF doesn't work resolved Normal 8 years ago 2.12
37991 Workbook::close returns false if > 7MB and filehandle passed to new() resolved 8 years ago
39939 add_format() limitation ? resolved 8 years ago
40662 add_write_handler() and write_datetime() resolved Wishlist 8 years ago 2.21
42355 valign overrides align parameter resolved 8 years ago
44742 data validation using a range in another worksheet doesn't work resolved Normal 8 years ago 2.25
50361 Include images generated by Perl, (and not only from file) resolved Wishlist 8 years ago 2.25
52266 Spreadsheet-WriteExcel-2.30: make test failed resolved 8 years ago
56939 Bug in Spreadsheet::WriteExcel related to worksheet names that begin with a number resolved 8 years ago
56913 Encoding problem with worksheet names if string is marked as utf8 resolved Important 8 years ago 2.37
57952 formatting bug with add_format() resolved 8 years ago
58424 Foreground (text) Color Issue --- Module Version: 2.37 resolved 8 years ago
61149 Typos resolved 8 years ago 2.37
61150 Feature request: get_format($row, $cell), set_cell($row, $cell, $format) resolved 8 years ago
61878 Unhiding columns with width undef or 8.43 disapears in Excel2010 resolved Normal 8 years ago 2.35
2.37
61560 Spurious error writing undef formulas resolved Unimportant 8 years ago 2.37
62126 Bug: no data is displayed, after changing the row height with set_row() method resolved 8 years ago
63348 write_comment interaction with reformatting (probably affects bitmaps as well) resolved Wishlist 8 years ago 2.37
64746 Problem writing to stdout resolved 8 years ago
54902 Request for Excel 2007 row and column limits resolved Wishlist 8 years ago
67014 Bug in the create chart with data in an page resolved Important 8 years ago 2.37
53812 Excel 2003: "File error: data may have been lost." on extra parens resolved Unimportant 8 years ago 2.35
68954 Rounding problem when configure with longdoubles resolved 8 years ago
71085 center_across only works the first time the format is used resolved 8 years ago
70432 Syntax error in Pod example resolved Unimportant 8 years ago 2.37
75452 Rare digest error on image insert resolved Unimportant 8 years ago 2.37
76997 repeat_formula fails if stored formula refers to a 2D range and the replacement is a 3D range resolved Normal 8 years ago 2.37
76883 merge_range doesn't adjusts the height, with text_wrap is true. But write with formats does. resolved Normal 9 years ago 2.37
74408 same chart in different worksheets of the same workbook uses always the data from first worksheet resolved 9 years ago
64724 Images stretch when they cross an explicitly sized row resolved Important 10 years ago 2.37
63941 Broken cell values with utf 8 ( in: abcde out: a\0b\0c\0d\0e ) resolved Important 10 years ago 2.37
62675 Potential bug in Spreadsheet::WriteExcel resolved 10 years ago
62398 Install fails: 2.37 on perl 5.10.0 resolved Normal 10 years ago 2.37
59629 Re: charts bug with worksheet names starting with a number resolved 10 years ago
59628 charts bug with worksheet names starting with a number resolved 10 years ago
60772 Can't call method "Worksheets" resolved 10 years ago
39416 Issue with repeat_rows and SpreadSheet-WriteExcel 2.25 resolved 11 years ago
38099 strange name conflict with autofilter resolved 11 years ago
53346 Add an index.html resolved Wishlist 11 years ago 2.33
53251 Error while entering SUMPRODUCT formula resolved Important 11 years ago 2.31
53266 Spelling Mistakes resolved Wishlist 11 years ago 2.32
41048 UTF8 URLs cause generation of corrupted file resolved Normal 11 years ago 2.25
37674 Office2003-SP3 cannot read the xls files generated with Spreadsheet-WriteExcel-2.21 anymore resolved 11 years ago
42289 $worksheet->workbook resolved Wishlist 11 years ago
45513 2 Pbs with Spreadsheet-WriteExcel resolved 11 years ago
40375 (No subject) resolved Critical 12 years ago
36113 set_bg_color() does not update in for loop resolved 13 years ago
33662 hiding rows does not close outline folds resolved Normal 13 years ago 2.20 2.21
30368 Bug with utf-8 strings in Formula.pm resolved 13 years ago 2.21
32544 worksheet-> write() is missing Row Record tag / can not be parsed by Apache POI (WriteExcel's Java counterpart) resolved Critical 13 years ago 2.20 2.21
30500 Cannot write() embedded newlines resolved 13 years ago
14539 Format Error : cannot use "0" as a num_format resolved 13 years ago 2.14
28535 Allow creation of worksheets with >65536 rows resolved Wishlist 13 years ago 2.18
8526 Using write_merge() renders write() cells invisible resolved Normal 13 years ago
21731 random column doubling resolved 13 years ago
20149 Compress images resolved Wishlist 13 years ago 2.17
19841 args inverted in add_chart_ext() docblock resolved Unimportant 14 years ago 2.17 2.18
20059 Formula::_get_sheet_index resolved Important 14 years ago 2.18
9090 Garbage characters at the end of external hyperlink URLs resolved Normal 14 years ago 2.11
20948 Man page broken resolved 14 years ago 2.18
22934 WriteExcel: generates bad Excel files resolved 14 years ago
17801 Bad File Descriptor error on close resolved Normal 15 years ago 0.22
14796 Hyperlinks are always formatted as text resolved Normal 15 years ago 2.14
14094 Module generates Excel files with multiple active WINDOW2 records resolved Normal 15 years ago 2.14
13133 workbook->close() returns 'Bad file descriptor' error resolved Normal 15 years ago 0.10
12370 POD links for Microsoft samples for cell formatting appear to have gone bad. resolved Normal 15 years ago 2.12
4110 close() doesn't prevent DESTROY problem resolved Normal 15 years ago 0.42
12342 In case you wondered why ActiveState fails this module resolved Critical 16 years ago 2.12
12308 some resolved Normal 16 years ago 2.10 2.10
6038 Creating Excel file containing 48043 rows and 76columns resolved 16 years ago 0.42
11700 Non-ascii sheet names and perl's utf8 resolved Normal 16 years ago 2.11
8242 Would like to see Validation resolved Wishlist 16 years ago
7234 Bad Excel file structure created. resolved Important 16 years ago 2.02
2.03
7168 SpreadSheet::WriteExcel::Big constructor does not accept a filehandle resolved Unimportant 16 years ago 2.03
7163 File created in UNIX crashes Excel resolved Important 16 years ago 2.03
7040 Create a damaged xls file resolved Important 16 years ago
6975 WriteExcel: incorrect file created with ::big resolved Important 16 years ago 2.03
5955 new( \*STDOUT ) Broken resolved Critical 17 years ago 0.42
6009 Problems with OpenOffice.org resolved Important 17 years ago 0.41
5431 Leading zero gets dropped off resolved Normal 17 years ago
6411 OUTLOOK destroys generated files resolved Important 17 years ago 0.42
5913 Cannot specify an Array Formula (e.g. {=function...}) resolved Normal 17 years ago 0.42
5750 Error when generate extra BIG Excel file (300MB) resolved Critical 17 years ago 0.42 0.42
2925 Writing a long formula (>255 chars) to the same cell twice causes Excel crash resolved Unimportant 17 years ago 0.37
774 Excel file not created. resolved Normal 18 years ago 0.37
773 Excel file not created. resolved Normal 18 years ago 0.37
775 Excel file not created. resolved Normal 18 years ago 0.37
1222 File::Temp not in prerquisite list resolved Important 18 years ago 0.37
1418 merging cells not displaying correctly resolved Normal 18 years ago 0.37
1382 WriteExcel not processing text formats properly resolved Important 18 years ago 0.37
1272 $worksheet->print_area resolved Important 18 years ago 0.37
11 Module slows down when running on IIS resolved Important 19 years ago 0.34 0.37