Skip Menu |

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

Report information
The Basics
Id: 75277
Status: resolved
Priority: 0/
Queue: Spreadsheet-Read

People
Owner: Nobody in particular
Requestors: johnfribeiro [...] gmail.com
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: (no value)
Fixed in: 0.47



Subject: Error When Reading Label of Empty Sheet
Date: Fri, 24 Feb 2012 10:54:07 -0500
To: bug-Spreadsheet-Read [...] rt.cpan.org
From: John Ribeiro <johnfribeiro [...] gmail.com>
Dear Sir or Madam, Thanks for responding so quickly to my recent bug report. I have another related issue. I'd like to be able to report that a given sheet is blank using the label. Unfortunately, if a sheet is empty, the label data element is undefined. Therefore I am unable to report with certainty, which individual sheets are empty. Regards, John Ribeiro
Subject: Re: [rt.cpan.org #75277] Error When Reading Label of Empty Sheet
Date: Mon, 27 Feb 2012 12:15:52 +0100
To: bug-Spreadsheet-Read [...] rt.cpan.org
From: "H.Merijn Brand" <h.m.brand [...] xs4all.nl>
On Fri, 24 Feb 2012 10:54:15 -0500, "John Ribeiro via RT" <bug-Spreadsheet-Read@rt.cpan.org> wrote: Show quoted text
> Dear Sir or Madam,
Sir Show quoted text
> Thanks for responding so quickly to my recent bug report.
You're welcome Show quoted text
> I have another related issue. I'd like to be able to report that a > given sheet is blank using the label. Unfortunately, if a sheet is > empty, the label data element is undefined.
This all is inherent to the value of the "clip" attribute, which defaults to the truthness of the "cells" attribute, which is true by default. --8<--- From the docs If set, C<ReadData ()> will remove all trailing lines and columns per sheet that have no visual data. This option is only valid if C<cells> is true. The default value is true if C<cells> is true, and false otherwise. -->8--- If you want empty sheets to return as valid sheets including all rows and columns with possible empty data, you will have to set "clip" to a false value my $ss = ReadData ("file.xls", clip => 0); Show quoted text
> Therefore I am unable to report with certainty, which individual > sheets are empty.
If a sheet is completely empty, it is skipped when "clip" is true. That might be worth an extra note in the documentation. -- H.Merijn Brand http://tux.nl Perl Monger http://amsterdam.pm.org/ using perl5.00307 .. 5.14 porting perl5 on HP-UX, AIX, and openSUSE http://mirrors.develooper.com/hpux/ http://www.test-smoke.org/ http://qa.perl.org http://www.goldmark.org/jeff/stupid-disclaimers/
Sending the previous mail has failed. Please contact your admin, they can find more details in the logs.
Sending the previous mail has failed. Please contact your admin, they can find more details in the logs.