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

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

Report information
The Basics
Id: 50705
Status: new
Priority: 0/
Queue: Spreadsheet-XLSX

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

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



Subject: Worksheet names with html characters not getting decoded
Date: Wed, 21 Oct 2009 18:37:05 +0530
To: bug-Spreadsheet-XLSX [...] rt.cpan.org
From: mrinal roushan <mrinalroushan [...] gmail.com>
Download (untitled) / with headers
text/plain 785b
Hi, I am using *Spreadsheet::XLSX 0.12* and I encountered the following problem : If the xlsx file being processed has *html characters(&,<,>,'') in the worksheet names*, this causes Spreadsheet::XLSX to dump the sheet names without decoding the characters to their original form and this *appears as &amp;,&lt;,&gt;,&quot;* in the dumped output. Therefore I *added a line after 119 in Spreadsheet::XLSX* as *$sheet -> {Name} = Spreadsheet::XLSX::Utility2007::unescape_HTML($sheet->{Name});* This then results in decoding the sheet name correctly. I am *using the following test script* to get the dumped output : my $converter = Text::IConv->new("utf-8","windows-1251"); my $ref = Spreadsheet::XLSX->new("file_name",$converter); print Dumper $ref; -- Regards Mrinal Roushan


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

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.