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

Wed Oct 07 10:51:45 2020 michaelof [...] rocketmail.com - Ticket created

Subject:	No line breaks in cells when Source is LibreOffice Calc
Date:	Wed, 7 Oct 2020 16:51:34 +0200
To:	bug-Spreadsheet-Read [...] 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

Wed Oct 07 10:59:53 2020 HMBRAND [...] cpan.org - Correspondence added

On Wed Oct 07 10:51:45 2020, michaelof@rocketmail.com wrote: Show quoted text

> 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.

Spreadsheet::ReadSXC is currently swapped out in favor of Spreadsheet::ParseODS Feel free to file this issue in both https://github.com/Tux/Spreadsheet-Read/issues and https://github.com/Corion/Spreadsheet-ReadSXC/issues The latter is the parent of Spreadsheet::ParseODS I am curious if your issues persist if you install the most recent version as of today for both Spreadsheet::Read (0.82) and Spreadsheet::ParseODS (0.32) If so, please include a minimal .ods file that shows this behavior

Wed Oct 07 10:59:53 2020 The RT System itself - Status changed from 'new' to 'open'

Wed Oct 07 11:38:38 2020 michaelof [...] rocketmail.com - Correspondence added

Subject:	Re: [rt.cpan.org #133484] No line breaks in cells when Source is LibreOffice Calc
Date:	Wed, 7 Oct 2020 17:38:17 +0200
To:	bug-Spreadsheet-Read [...] rt.cpan.org
From:	"michaelof [...] rocketmail.com" <michaelof [...] rocketmail.com>

Am 07.10.20 um 16:59 schrieb H.Merijn Brand via RT: Show quoted text

> <URL: https://rt.cpan.org/Ticket/Display.html?id=133484 > > > On Wed Oct 07 10:51:45 2020, michaelof@rocketmail.com wrote:

>> 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.

> > Spreadsheet::ReadSXC is currently swapped out in favor of Spreadsheet::ParseODS > > Feel free to file this issue in both https://github.com/Tux/Spreadsheet-Read/issues and https://github.com/Corion/Spreadsheet-ReadSXC/issues > > The latter is the parent of Spreadsheet::ParseODS > > I am curious if your issues persist if you install the most recent version as of today for both (0.82) and Spreadsheet::ParseODS (0.32) > > If so, please include a minimal .ods file that shows this behavior >

I'm using Spreadsheet::Read 0.82, installed yesterday for my script. Question: As I only "use Spreadsheet::Read;" in my script, and as Spreadsheet::Read calls whatever it need/wants subsequently: Is there any (easy) way to "tweak" Spreadsheet::Read to use Spreadsheet::ParseODS instead of Spreadsheet::ReadSXC?

Wed Oct 07 11:51:42 2020 HMBRAND [...] cpan.org - Correspondence added

Show quoted text

> I'm using Spreadsheet::Read 0.82, installed yesterday for my script.

👍 Show quoted text

> Question: As I only "use Spreadsheet::Read;" in my script, and as > Spreadsheet::Read calls whatever it need/wants subsequently: Is there > any (easy) way to "tweak" Spreadsheet::Read to use > Spreadsheet::ParseODS instead of Spreadsheet::ReadSXC?

Yes, as documented https://metacpan.org/pod/Spreadsheet::Read#parser : $ env SPREADSHEET_READ_ODS=Spreadsheet::ParseODS perl yourscript

Wed Oct 07 12:50:23 2020 michaelof [...] rocketmail.com - Correspondence added

Subject:	Re: [rt.cpan.org #133484] No line breaks in cells when Source is LibreOffice Calc
Date:	Wed, 7 Oct 2020 18:50:01 +0200
To:	bug-Spreadsheet-Read [...] rt.cpan.org
From:	"michaelof [...] rocketmail.com" <michaelof [...] rocketmail.com>

Works perfectly with Spreadsheet::ParseODS!!! THANKS for your very valuable and lightspeed fast help! Regards, Michael Am 07.10.20 um 17:51 schrieb H.Merijn Brand via RT: Show quoted text

> <URL: https://rt.cpan.org/Ticket/Display.html?id=133484 > >

>> I'm using Spreadsheet::Read 0.82, installed yesterday for my script.

> > 👍 >

>> Question: As I only "use Spreadsheet::Read;" in my script, and as >> Spreadsheet::Read calls whatever it need/wants subsequently: Is there >> any (easy) way to "tweak" Spreadsheet::Read to use >> Spreadsheet::ParseODS instead of Spreadsheet::ReadSXC?

> > Yes, as documented https://metacpan.org/pod/Spreadsheet::Read#parser : > > $ env SPREADSHEET_READ_ODS=Spreadsheet::ParseODS perl yourscript >

Wed Oct 07 13:17:17 2020 HMBRAND [...] cpan.org - Severity Normal added

Wed Oct 07 13:17:17 2020 HMBRAND [...] cpan.org - Status changed from 'open' to 'resolved'