Bug #133485 for Spreadsheet-ReadSXC: No line breaks in cells when Source is LibreOffice Calc

Wed Oct 07 10:53:49 2020 michaelof [...] rocketmail.com - Ticket created

Subject:	No line breaks in cells when Source is LibreOffice Calc
Date:	Wed, 7 Oct 2020 16:53:31 +0200
To:	bug-Spreadsheet-ReadSXC [...] rt.cpan.org
From:	"michaelof [...] rocketmail.com" <michaelof [...] rocketmail.com>

Hi, when reading a LibreOffice Calc .ods file via Spreadsheat::Read, all existing line breaks in cells are wiped out. "Save as..." same file via LibreOffice Calc as .xlsx, and reading via Spreadsheat::Read works perfectly fine, all line breaks are fetched correctly as "\n". meta::cpan says that Spreadsheat::Read uses Spreadsheet::ReadSXC for LO Calc and Spreadsheet::ParseXLSX for MS Excel, but I've no idea if the wiping out of the line breaks happens in Spreadsheat::Read or in Spreadsheet::ReadSXC. So 'll report for both modules :-) Please ignore/close of not an issue for your module. Thanks, Michael

Thu Oct 08 02:06:04 2020 corion [...] cpan.org - Correspondence added

Solved in https://rt.cpan.org/Public/Bug/Display.html?id=133484 - Spreadsheet::Read needs to be told to use the ParseODS parser instead of the ReadSXC parser. This will soonish also become the default.

Thu Oct 08 02:06:05 2020 The RT System itself - Status changed from 'new' to 'open'

Thu Oct 08 02:06:05 2020 corion [...] cpan.org - Status changed from 'open' to 'resolved'

Thu Oct 08 02:06:06 2020 corion [...] cpan.org - Fixed in 0.32 added