Skip Menu |

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

Report information
The Basics
Id: 124409
Status: new
Priority: 0/
Queue: Spreadsheet-XLSX

People
Owner: Nobody in particular
Requestors: wolfgang [...] alle-noten.de
Cc:
AdminCc:

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



Subject: suggested patch
Date: Tue, 13 Feb 2018 11:24:59 +0100
To: bug-Spreadsheet-XLSX [...] rt.cpan.org
From: wolfgang [...] alle-noten.de
Hi there, I have come across an xlsx file which does open in Excel but not in my copy of ooffice (LibreOffice 4.1.6.2) I have no idea how the file was generated (I assume some database export tool) It uses XML namespaces, so things like <sheet become <x:sheet The main structural difference: it supplies named columns rather than traditional A, B, AA, AB in this format <row r="1"><c ... r="COLNAME1"> Besides, every xml based format will have < > & escaped and should unescape them on reading Find attached a source diff and an example file Best regards Wolfgang Hamann
Download sample.xlsx
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet 4.2k

Message body not shown because it is not plain text.

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