Skip Menu | will be shut down on March 1st, 2021.

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

Report information
The Basics
Id: 67755
Status: open
Priority: 0/
Queue: Spreadsheet-XLSX

Owner: mikeb [...]
Requestors: ethandbrown [...]

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

Subject: Lots of "Use of uninitialized value" errors
Date: Mon, 25 Apr 2011 15:33:11 -0700
To: bug-Spreadsheet-XLSX [...]
From: Ethan Brown <ethandbrown [...]>
Download (untitled) / with headers
text/plain 723b
First, my thanks for providing this module. I found the module to print many errors of the form (test file attached). Use of uninitialized value within @styles in hash element at /usr/share/perl5/Spreadsheet/ line 189. Use of uninitialized value $thisstyle in pattern match (m//) at /usr/share/perl5/Spreadsheet/ line 190. I tried checking for a defined $sty on line 189, and it fixed things for this particular test file, however other files displayed the same error. I found the following to fix the manifestation of the problem: Replace $thisstyle = $style_info{$styles[$sty]} with $thisstyle = $style_info{$styles[$sty]} if defined($sty) && $styles[$sty]; Hi hope you find this helpful. --Ethan
Download test.xlsx
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet 6.3k

Message body not shown because it is not plain text.

Download (untitled) / with headers
text/plain 140b
to "fix" this, change the line 189 to $thisstyle = exists $styles[$sty] ? $style_info{$styles[$sty]} : ''; this should fix that warning.
Download (untitled) / with headers
text/plain 111b
Despite the statement that this issue is fixed in 0.12, it appears that it is NOT fixed in either 0.12 or 0.13.

This service is sponsored and maintained by Best Practical Solutions and runs on infrastructure.

Please report any issues with to