Bug 148193 - Reading .ods file created by LibreOffice 7.0.4.2 or newer breaks jOpenDocument
Summary: Reading .ods file created by LibreOffice 7.0.4.2 or newer breaks jOpenDocument
Status: CLOSED NOTOURBUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.4.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-03-26 00:53 UTC by leon
Modified: 2022-04-08 14:33 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
example.ods (11.22 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-03-28 19:26 UTC, leon
Details
example-2.ods (11.17 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-03-30 20:06 UTC, leon
Details

Note You need to log in before you can comment on or make changes to this bug.
Description leon 2022-03-26 00:53:36 UTC
Could this bug be caused by LibreOffice: https://bugs.documentfoundation.org/show_bug.cgi?id=139446
Comment 1 Julien Nabet 2022-03-26 16:18:15 UTC
Does it happen with any file or just specific files?
How do you know it's not a pb  with jOpenDocument
Could you provide the file? (after having sanitized it if needed https://wiki.documentfoundation.org/QA/Bugzilla/Sanitizing_Files_Before_Submission)
Comment 2 leon 2022-03-28 19:26:49 UTC
Created attachment 179172 [details]
example.ods

Here is an example file created with the newest stable version of calc that produces this issue.
Comment 3 Julien Nabet 2022-03-28 19:51:51 UTC
Thank you for your feedback.
I gave a try with https://odfvalidator.org/, I've got:
The document is NOT conformant ODF1.3!
Details:
example.ods: Info: ODF version of root document: 1.3
internal:/schema/odf1.3/OpenDocument-v1.3-manifest-schema.rng: Info: parsed.
example.ods/META-INF/manifest.xml: Info: no errors, no warnings
example.ods/mimetype: Info: no errors, no warnings
example.ods: Info: Media Type: application/vnd.oasis.opendocument.spreadsheet
internal:/schema/odf1.3/OpenDocument-v1.3-schema.rng: Info: parsed.
example.ods/meta.xml: Info: Generator: LibreOffice/7.2.6.2$Windows_X86_64 LibreOffice_project/b0ec3a565991f7569a5a7f5d24fed7f52653d754
example.ods/meta.xml: Info: no errors, no warnings
example.ods/settings.xml: Info: no errors, no warnings
example.ods/styles.xml: Info: no errors, no warnings
example.ods/content.xml[2,9804]: Error: unexpected attribute "calcext:value-type"
e="string" calcext:value-type="string"><text:p>NUMMER</text:p></table:table-cel ----^ example.ods/content.xml[2,9996]: Error: unexpected attribute "calcext:value-type"
e="string" calcext:value-type="string"><text:p>foo</text:p></table:table-cell>< ----^ example.ods/content.xml[2,10789]: Error: unexpected attribute "calcext:value-type"
etc.

Weird, "calcext" is an extension but odfvalidator shouldn't complain since we use ODF 1.3 extended by default.

Eike/Michael: any thoughts here?
Comment 4 Michael Stahl (allotropia) 2022-03-29 09:08:15 UTC
as usual, with the default LO setting of ODF Format version: "1.3 Extended (recommended)" use this validator flag:
-e: Check extended conformance (ODF 1.2 and 1.3 documents only)

or change the LO setting to "1.3" to omit extension attributes.
Comment 5 Julien Nabet 2022-03-30 19:55:44 UTC
(In reply to Michael Stahl (allotropia) from comment #4)
> as usual, with the default LO setting of ODF Format version: "1.3 Extended
> (recommended)" use this validator flag:
> -e: Check extended conformance (ODF 1.2 and 1.3 documents only)
> 
> or change the LO setting to "1.3" to omit extension attributes.

Thank you for the hint, I changed the LO setting to 1.3 to omit extension attributes.

I would have thought that "1.3 Extended (recommended)" would indicate something in the ods file so https://odfvalidator.org/ doesn't complain about extension attributes.
Comment 6 leon 2022-03-30 20:05:39 UTC
I changed the version in Calc by going to Tools -> Options -> Load/Save -> General, adjusting the version from "1.3 extended" to "1.3" and saving anew. However, the issue persists. I uploaded a the file. It passes the validator but doesn't work with jOpenDocument.
Comment 7 leon 2022-03-30 20:06:19 UTC
Created attachment 179222 [details]
example-2.ods
Comment 8 Julien Nabet 2022-03-30 20:09:34 UTC
odfvalidator is ok with 1.3, so it rather seems JOpenDocument pb.
Comment 9 leon 2022-03-30 20:12:54 UTC
Yes, seems like it