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

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

People
Owner:
Nobody in particular
Requestors:
cjm [...] cpan.org
Cc:
AdminCc:

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



Subject: Cell value read as GENERAL in LibreOffice-created XLSX
I found that XLSX spreadsheets created in LibreOffice 4.4 aren't parsed correctly by Spreadsheet::XLSX. The formatted value is reported as GENERAL instead of the correct value. Microsoft Excel doesn't seem to have any problem opening the file. Also, if I just open the file in Excel and Save As (without changing anything), the new file is parsed correctly. Here's an example. I created libreoffice.xlsx in LibreOffice 4.4.7.2. The first column uses the default format to store 1. The second column uses an explicit integer format to store 2. The third column uses a two-decimal-place format to store 3.4. Then I dump the file with this code: use Spreadsheet::XLSX (); my $excel = Spreadsheet::XLSX->new(shift); my $sheet = $excel->worksheet(0); for my $col (0 .. 2) { printf "%d: %s\n", $col, $sheet->get_cell(1,$col)->value; } For libreoffice.xlsx, this prints: 0: GENERAL 1: 2 2: 3.40 After loading & saving in Excel, libreoffice-excel.xlsx prints: 0: 1 1: 2 2: 3.40 which is correct.
Subject: libreoffice-excel.xlsx

Message body not shown because it is not plain text.

Subject: libreoffice.xlsx

Message body not shown because it is not plain text.



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.