Skip Menu | will be shut down on March 1st, 2021.

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

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

Owner: Nobody in particular
Requestors: cjm [...]

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

Subject: [PATCH] Does not handle newlines in <Relationship> tags
Download (untitled) / with headers
text/plain 432b
I have a .xlsx file generated by a reporting package that has newlines inside the <Relationship> tags in xl/_rels/workbook.xml.rels: <Relationship Id="rId1" Type="" Target="worksheets/sheet1.xml"/> Spreadsheet::XLSX doesn't handle that, but the fix is simple: just add the /s modifier to the regex so it matches the newlines. Patch is attached.
Subject: relationship.patch
Download relationship.patch
text/x-diff 378b
--- lib/Spreadsheet/ 2015-10-30 21:33:19.000000000 -0500 +++ lib/Spreadsheet/ 2016-01-11 09:59:34.913422993 -0600 @@ -253,7 +253,7 @@ my %rels = (); - foreach ($member_rels->contents =~ /\<Relationship (.*?)\/?\>/g) { + foreach ($member_rels->contents =~ /\<Relationship (.*?)\/?\>/gs) { my ($id, $target); ($id) = /Id="(.*?)"/;

This service is sponsored and maintained by Best Practical Solutions and runs on infrastructure.

Please report any issues with to