Bug #62126 for Spreadsheet-WriteExcel: Bug: no data is displayed, after changing the row height with set_row() method

• Active bugs
• Resolved bugs
• Rejected bugs

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.

History Show all quoted text

  Thu Oct 14 08:58:23 2010 Benjamin.Gerzen [...] webtrekk.com - Ticket created

Subject:	Bug: no data is displayed, after changing the row height with set_row() method
Date:	Thu, 14 Oct 2010 14:58:18 +0200
To:	"bug-Spreadsheet-WriteExcel [...] rt.cpan.org" <bug-Spreadsheet-WriteExcel [...] rt.cpan.org>
From:	Benjamin Gerzen <Benjamin.Gerzen [...] webtrekk.com>

Hello, we found this bug after viewing the exported excel document on an iPhone OS 4. After setting a row height with method set_row() in Spreadsheet::WriteExcel, all data in a documents hidden. The problem appears only with iPhone excel viewer, on a computer with windows XP and MS Office 2007 and 2010 are no problems detected. Also after opening the created document with MS Office and copying the sheet to a new workbook makes it viewable on iPhone device. In attachment one excel document generated with Spreadsheet::WriteExcel. Distribution: Spreadsheet-WriteExcel-2.37 Perl version: v 5.8.8 OS: Red Hat Enterprise Linux Server v5.2 Best regards Benjamin Gerzen Show quoted text

______________________________________ Benjamin Gerzen, Software Developer Webtrekk GmbH Boxhagener Str. 76-78, 10245 Berlin fon +49 030 - 755 415 - 319 fax +49 030 - 755 415 - 100 mailto:benjamin.gerzen@webtrekk.com<mailto:benjamin.gerzen@webtrekk.de> http://www.webtrekk.com<http://www.webtrekk.com/?wt_mc=signatur.homepage> [cid:image001.png@01CB6BAD.06D13800]<http://wt.webtrekk.net/294915650484552/re.pl?t=http://twitter.com/webtrekk&c=signatur.twitter> Follow us on Twitter<http://wt.webtrekk.net/294915650484552/re.pl?t=http://twitter.com/webtrekk&c=signatur.twitter> [cid:image002.png@01CB6BAD.06D13800]<http://wt.webtrekk.net/294915650484552/re.pl?t=http://www.facebook.com/pages/Berlin/Webtrekk/140386818648&c=signatur.facebook> Like us on Facebook<http://wt.webtrekk.net/294915650484552/re.pl?t=http://www.facebook.com/pages/Berlin/Webtrekk/140386818648&c=signatur.facebook> Amtsgericht Berlin, HR 93435 B Geschäftsführer: Christian Sauer

______________________________________ [cid:image003.jpg@01CB6BAD.06D13800]<http://www.webtrekk.de/?wt_mc=signatur>

Download image001.png
image/png 619b

Download image002.png
image/png 649b

Download image003.jpg
image/jpeg 11.4k

Download report.xls
application/vnd.ms-excel 25.5k

Message body not shown because it is not plain text.

  Thu Oct 14 09:51:31 2010 jmcnamara [...] cpan.org - Correspondence added

Hi Benjamin, Can you try the compatibility_mode() Workbook option and see if that fixes the issue: http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.37/lib/Spreadsheet/WriteExcel.pm#compatibility_mode%28%29 John. --

  Thu Oct 14 09:51:32 2010 The RT System itself - Status changed from 'new' to 'open'

  Wed Nov 21 18:30:23 2012 jmcnamara [...] cpan.org - Correspondence added

Closing. Not feedback. Use suggested workaround or Excel::Writer::XLSX.

  Wed Nov 21 18:30:23 2012 jmcnamara [...] cpan.org - Status changed from 'open' to 'resolved'

---