Skip Menu |

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

Report information
The Basics
Id: 3717
Status: new
Priority: 0/
Queue: Spreadsheet-WriteExcel-FromXML
People
Owner: Nobody in particular
Requestors: sjtaillon [...] yahoo.com
Cc:
AdminCc:
Bug Information
Severity: Important
Broken in: (no value)
Fixed in: (no value)

History Show all quoted text
  Wed Sep 03 21:27:32 2003 Guest - Ticket created
Subject: num_format appears to not work
In looking at the DTD, it looks as though I should be able to use this xml to format a cell as a number: <row> <cell><format num_format="true"/>0</cell> </row> However, when I run Spreadsheet::WriteExcel::FromXML->XMLToXLS against xml containing such a format, I get this error: Argument "format" isn't numeric in numeric eq (==) at /usr/local/lib/perl5/site_perl/5.6.1/Spreadsheet/WriteExcel/FromXML/Worksheet.pm line 65. The resulting xls file displays an arrayref rather than the value in cells containing such a format specification (ARRAY(0x872c8b4). When I do not set the cell as a number format, excel gives me an error about a non-number formatted cell displaying a number and zeroes do not display at all (other numbers do, fortunately, display) My environment: Spreadsheet-WriteExcel-FromXML-1.00 (had to patch it to get it to install) Perl v5.6.1 built for i386-freebsd FreeBSD 4.8-STABLE It would be great to get a fix for this so I can display zeroes in my spreadsheet...
  Wed Sep 03 21:38:06 2003 sjtaillon [...] yahoo.com - Correspondence added
Date: Wed, 3 Sep 2003 18:37:31 -0700 (PDT)
From: Sara Taillon <sjtaillon [...] yahoo.com>
Subject: Re: [cpan #3717] num_format appears to not work
To: bug-Spreadsheet-WriteExcel-FromXML [...] rt.cpan.org
RT-Send-Cc:
This appears to be an issue with all formats, not just num_format.... Show quoted text
__________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com
  Thu Sep 11 16:39:19 2003 Guest - Correspondence added
From: justin
Check the example .xml file in the test directory: <format name="zipFormat" num_format="00000" /> <cell type="number" format="zipFormat">01852</cell> I'll try to reproduce the error and add a test. [guest - Wed Sep 3 21:27:32 2003]: Show quoted text
> In looking at the DTD, it looks as though I should be able to use this > xml to format a cell as a number: > > <row> > <cell><format num_format="true"/>0</cell> > </row> > > However, when I run Spreadsheet::WriteExcel::FromXML->XMLToXLS against > xml containing such a format, I get this error: > > Argument "format" isn't numeric in numeric eq (==) at >
/usr/local/lib/perl5/site_perl/5.6.1/Spreadsheet/WriteExcel/FromXML/Worksheet.pm Show quoted text
> line 65. > > The resulting xls file displays an arrayref rather than the value in > cells containing such a format specification (ARRAY(0x872c8b4). > > When I do not set the cell as a number format, excel gives me an error > about a non-number formatted cell displaying a number and zeroes do > not display at all (other numbers do, fortunately, display) > > My environment: > > Spreadsheet-WriteExcel-FromXML-1.00 (had to patch it to get it to > install) > Perl v5.6.1 built for i386-freebsd > FreeBSD 4.8-STABLE > > It would be great to get a fix for this so I can display zeroes in my > spreadsheet...
  Mon Sep 15 14:54:28 2003 Guest - Correspondence added
From: justin
After further testing, we actually found a bug in how we process the XML::Parser tree. This will give FromXML a chance to catch the missing name attribute in the format tag. We'll release an update soon.
  Mon Sep 15 17:59:26 2003 Guest - Correspondence added
From: justin
Syntax validation will not be part of FromXML mostly for speed reasons. You can use a 3rd party tool for validation like rxp. I've updated the DTD and the example XML file in the test directory. rxp appears to be happy with the updates. A release will be happening soon.