FS#55103 - [libreoffice-fresh] Format error on opening ods with 5.4.0, but opens fine with 5.3.5

Attached to Project: Arch Linux
Opened by Artem (i7220) - Friday, 11 August 2017, 01:24 GMT
Last edited by Andreas Radke (AndyRTR) - Thursday, 14 September 2017, 10:11 GMT
Task Type Bug Report
Category Packages: Extra
Status Closed
Assigned To Andreas Radke (AndyRTR)
Architecture x86_64
Severity Medium
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 0
Private No

Details

Description: originally reported upstream (https://bugs.documentfoundation.org/show_bug.cgi?id=111554). Was confirmed as reproducable on arch, was not reproducable on debian ("with master sources updated today" and "with LO Debian 5.4.0.3"). Then i also tried to open it with LO 5.4 on Windows, and it opened fine there.

Original report to the upstream project:

Steps to reproduce: open the ods file

Expected behaviour: file opens without the error prompts

Actual behaviour: when opening with libreoffice-fresh (5.4.0.3) i get an error message "Read Error. Format error discovered in the file in sub-document content.xml at 2,87813(row,col)." When opening with libreoffice-still (5.3.5.2 30m0(Build:2)) on the same PC (removing fresh, installing still) i get no error prompt

Details:

File was created on the same machine with the same Libreoffice 5.4.0.3. Today i run upon this error. I did transfer it earlier to my android device with android-file-transfer but i didn't see any indication of it being corrupted in the process. And it opens fine on android with MobySystems Office suite.

If i'm tracing it right, 2,87813 in content.xml is a letter t in a first word table-cell in a part of the file I provided below (so the 8th symbol in that given part of the file).

<table:table-cell office:value-type="string" calcext:value-type="string"><text:p>说明</text:p></table:table-cell><table:table-cell office:value-type="string" calcext:value-type="string"><text:p>shuōmíng</text:p><text:p>

In the attachments section there's the ods file itself.

It opens fine on Windows 8.1 with LO 5.2.0.4 ID: 066b007f5ebcc236395c7d282ba488bca6720265

5.4.0.3 also opens just fine the xls file i got by saving the original ods file as xls on that windows machine.

Other ods files open fine, no problems encountered.

My system: 4.12.4-1-ARCH #1 SMP PREEMPT Fri Jul 28 18:54:18 UTC 2017 x86_64 GNU/Linux

LibreOffice 5.4.0.3 40m0(Build:3)

Thanks!

Additional info:
* package version(s) libreoffice-fresh 5.4.0.3 40m0(Build:3), libreoffice-still (5.3.5.2 30m0(Build:2)
* config and/or log files etc.
This task depends upon

Closed by  Andreas Radke (AndyRTR)
Thursday, 14 September 2017, 10:11 GMT
Reason for closing:  Fixed
Comment by Artem (i7220) - Friday, 11 August 2017, 01:26 GMT
attaching the ods file
Comment by Artem (i7220) - Friday, 11 August 2017, 01:28 GMT
the file in question can be found on the upstream bug page. when trying to attach here i get an error

Query {INSERT INTO `flyspray_attachments` ( task_id, comment_id, file_name, file_type, file_size, orig_name, added_by, date_added) VALUES (?, ?, ?, ?, ?, ?, ?, ?)} with params {55103,160149,55103_e64b7891b936484c1c8599cf,application/vnd.oasis.opendocument.spreadsheet; charset=binary,48765,osm1.ods,24633,1502414798} Failed! (Data too long for column 'file_type' at row 1)

Comment by Andreas Radke (AndyRTR) - Friday, 11 August 2017, 14:12 GMT
Odd. Internal libraries should be the same that upstream and Debian are using. And system libs should be the same for -still and -fresh branch.

Maybe you can find out how to reproduce creating a broken file. Your files fails to open here as well but I'd like to know how to create a broken one.
Maybe it's related to some special character - could be pointing to icu.
Comment by Artem (i7220) - Saturday, 12 August 2017, 05:09 GMT
Hey! Basically it's a two column file - i fill myself the left column, right column was supposedly a plain text paste from the stardict chinese-to-russian dictionary. But i sure will try to somehow reproduce it
Comment by Artem (i7220) - Friday, 01 September 2017, 10:53 GMT
@Andreas i saw you've packaged 5.4.1-1 version for Testing. Could you see if it opens that file by any chance?
Comment by Andreas Radke (AndyRTR) - Friday, 01 September 2017, 14:46 GMT
Keeps crashing for me with 5.4.1-0.
Comment by Artem (i7220) - Thursday, 14 September 2017, 09:42 GMT
opened fine for me with LibreOffice 5.4.1.2.0 40m0(Build:2)!! Thanks!

Loading...