Skip Menu |

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)
Attachments
Example.xlsx
output.csv
sample_code.pl

History Show all quoted text
  Tue Mar 18 07:24:56 2014 kanaga.123 [...] gmail.com - Ticket created
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>
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
  Mon Apr 28 13:16:23 2014 chris_jack [...] msn.com - Correspondence added
From: chris_jack [...] msn.com
It would help if you attached your code and an example spreadsheet that demonstrates the problem. Regards Chris
  Mon Apr 28 13:16:23 2014 The RT System itself - Status changed from 'new' to 'open'
  Wed May 14 03:22:07 2014 kanaga.123 [...] gmail.com - Correspondence added
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>
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.

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

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