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: 93962
Status: open
Priority: 0/
Queue: Spreadsheet-XLSX

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

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



Subject: CSV output is not correct for one particular case
Date: Tue, 18 Mar 2014 16:54:46 +0530
To: bug-Spreadsheet-XLSX [...] rt.cpan.org
From: Kanagavalli Ilango <kanaga.123 [...] gmail.com>
Download (untitled) / with headers
text/plain 330b
Hello, In my XLSX file, I am having a column which is the concatenate of 2 different cells. If both the cells are empty, am getting the following output in the CSV: <row r="45" spans="1:17"> I am not sure why I am getting this type of error. When I use the xls file and perform CSV, it works fine. Please advise. Thanks Kanaga
From: chris_jack [...] msn.com
Download (untitled) / with headers
text/plain 112b
It would help if you attached your code and an example spreadsheet that demonstrates the problem. Regards Chris
Subject: Re: [rt.cpan.org #93962] CSV output is not correct for one particular case
Date: Wed, 14 May 2014 12:51:49 +0530
To: bug-Spreadsheet-XLSX [...] rt.cpan.org
From: Kanagavalli Ilango <kanaga.123 [...] gmail.com>
Download (untitled) / with headers
text/plain 663b
Hi Chris, I am attaching the spreadsheet, sample output and also the script that is used for the csv conversion. In my script the separator is not comma but am using "SPLITCHAR" as the separator at the output. for the cell: K35,K35 -- I am seeing that the & is output as &amp; can you let me know why it is output like that? I am currently replacing it manually and going ahead. On Mon, Apr 28, 2014 at 10:46 PM, Chris Jack via RT < bug-Spreadsheet-XLSX@rt.cpan.org> wrote: Show quoted text
> <URL: https://rt.cpan.org/Ticket/Display.html?id=93962 > > > It would help if you attached your code and an example spreadsheet that > demonstrates the problem. > > Regards > Chris >
Download Example.xlsx
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet 23k

Message body not shown because it is not plain text.

Download output.csv
text/csv 7.7k

Message body is not shown because sender requested not to inline it.

Download sample_code.pl
text/x-perl 2.3k

Message body is not shown because sender requested not to inline it.



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.