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

Report information
The Basics
Id:
50705
Status:
new
Priority:
Low/Low

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

BugTracker
Severity:
(no value)
Broken in:
(no value)
Fixed in:
(no value)



MIME-Version: 1.0
X-Spam-Status: No, hits=0.0 required=8.0 tests=DK_SIGNED,HTML_MESSAGE,SPF_PASS
X-Virus-Checked: Checked by ClamAV on 16.mx.develooper.com
Content-Type: multipart/alternative; boundary=00032555b93af98716047671a8a2
Message-ID: <d0df95f60910210607u31d94a7cideeb08806ba25ac7@mail.gmail.com>
Received: from la.mx.develooper.com (x1.develooper.com [207.171.7.70]) by diesel.bestpractical.com (Postfix) with SMTP id 5BB7419B8281 for <bug-Spreadsheet-XLSX@rt.cpan.org>; Wed, 21 Oct 2009 09:07:30 -0400 (EDT)
Received: (qmail 29294 invoked by uid 103); 21 Oct 2009 13:07:29 -0000
Received: from x16.dev (10.0.100.26) by x1.dev with QMQP; 21 Oct 2009 13:07:29 -0000
Received: from mail-fx0-f212.google.com (HELO mail-fx0-f212.google.com) (209.85.220.212) by 16.mx.develooper.com (qpsmtpd/0.80) with ESMTP; Wed, 21 Oct 2009 06:07:28 -0700
Received: by fxm8 with SMTP id 8so4772653fxm.45 for <bug-Spreadsheet-XLSX@rt.cpan.org>; Wed, 21 Oct 2009 06:07:25 -0700 (PDT)
Received: by 10.204.175.80 with SMTP id w16mr7847028bkz.207.1256130445149; Wed, 21 Oct 2009 06:07:25 -0700 (PDT)
Delivered-To: cpan-bug+Spreadsheet-XLSX@diesel.bestpractical.com
Subject: Worksheet names with html characters not getting decoded
Return-Path: <mrinalroushan@gmail.com>
Domainkey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=mime-version:from:date:message-id:subject:to:content-type; b=WLN8heDmSLCdCqIsb8//jvvNGMmdoBkIaflbIQXQe4luFmbin9hlnzZoP5iYIWXvY2 bgk8Ie9dz/SrTJsRYOkw/TCau3lodq8uFJ/jdw3YRaZ5L57ML/JXUZpMQSBkhe8lVgt/ pToO68B50gHO3ILEglQCM8ZisnWIlPiabnFxs=
X-Original-To: bug-Spreadsheet-XLSX@rt.cpan.org
X-Spam-Check-BY: 16.mx.develooper.com
Dkim-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:mime-version:received:from:date:message-id :subject:to:content-type; bh=n6X4HDzgCcIdtPpDKEWW/+L+4SaLWirPJ1r9xvQ0eUI=; b=V/pWdjpg3pswKsVz8/BKy/B3pFegcxCvP30ITk6vho7elLk0ciW6iosBKhPhp8WTDo oJCGtKEqqmE6HetUfvf+8skFU0g5Ns9RTUiqvFGT8oAB+nER7ZQoBn9SPyGmFhkZyb5M 7q2mswEJIc5G/+lBYdzDGYp/wOB6FYxVV7pxU=
Date: Wed, 21 Oct 2009 18:37:05 +0530
X-Spam-Level: *
To: bug-Spreadsheet-XLSX@rt.cpan.org
From: mrinal roushan <mrinalroushan@gmail.com>
Content-Length: 0
content-type: text/plain; charset="utf-8"
X-RT-Original-Encoding: ISO-8859-1
Content-Length: 785
content-type: text/html; charset="utf-8"
Content-Transfer-Encoding: quoted-printable
X-RT-Original-Encoding: ISO-8859-1
Content-Length: 1245
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 runs on Request Tracker, is sponsored by The Perl Foundation, and maintained by Best Practical Solutions.

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