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: 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
Download (untitled) / with headers
text/plain 577b
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.

Download XLSX.pm.diff
text/x-diff 3.2k

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.