Bug 131059 - Can't open ods file with newer version LibreOffice
Summary: Can't open ods file with newer version LibreOffice
Status: RESOLVED DUPLICATE of bug 116079
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
6.0 all versions
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
Depends on:
Blocks:
 
Reported: 2020-03-02 07:25 UTC by SHJ
Modified: 2020-07-23 14:16 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
can't opened by v6.x.x (4.64 KB, application/octet-stream)
2020-03-03 01:36 UTC, SHJ 		Details
file fixed (14.62 KB, application/vnd.oasis.opendocument.spreadsheet)
2020-07-23 14:11 UTC, Julien Nabet 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description SHJ 2020-03-02 07:25:18 UTC 
Description:
I have produced an ods file with jasperreport v5.0.1 (with crosstab feature),
it can be opened by LibreOffice v5.3.6 or earlier (OpenOffice, either), but not newer version (above v.6.x ).
returned message is "Invalid format" "Invalid File Format".
The ods file size is strange (quite small), but old version can open it.
Is it a problem of LibreOffice or jasperreport ?

If needed, I can upload ods file with problem.
Thanks !!

Actual Results:
Invalid format

Expected Results:
ods opened


Reproducible: Always


User Profile Reset: No



Additional Info:
版本：6.3.4.2 (x64)
組建 ID：60da17e045e08f1793c57c00ba83cdfce946d0aa
CPU 執行緒：8; OS：Windows 10.0; UI 算繪：預設; VCL: win; 
語言地區：zh-TW (zh_TW); UI語言：zh-TW
Calc: threaded
Comment 1 Xisco Faulí 2020-03-02 11:27:20 UTC 
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Comment 2 SHJ 2020-03-03 01:36:52 UTC 
Created attachment 158321 [details]
can't opened by v6.x.x
Comment 3 Xisco Faulí 2020-03-03 08:36:29 UTC 
Regression introduced by https://cgit.freedesktop.org/libreoffice/core/commit/?id=8154953add163554c00935486a1cf5677cef2609, which is already reported in bug 116079

*** This bug has been marked as a duplicate of bug 116079 ***
Comment 4 SHJ 2020-03-04 01:35:52 UTC 
mark as duplicate of bug 116079
but I can't find any solution in bug 116079 comments ?

and it happens now, so it's not fixed yet ?
How can I avoid it ?
Comment 5 Xisco Faulí 2020-07-23 13:58:35 UTC 
Hello Julien,
Would you mind fixing the document the same way you fixed the document in bug 116079
Comment 6 Julien Nabet 2020-07-23 14:11:44 UTC 
Created attachment 163452 [details]
file fixed

On pc Debian x86-64 with master sources updated today, I could reproduce the pb.
I got:
warn:sc.filter:108746:108746:sc/source/filter/xml/xmlwrap.cxx:212: SAX parse exception caught while importing: com.sun.star.xml.sax.SAXParseException message: [file:///tmp/bad.ods line 2]: Extra content at the end of the document
 /home/julien/lo/libreoffice/sax/source/fastparser/fastparser.cxx:578
    wrapped: void message: /home/julien/lo/libreoffice/tools/source/debug/debug.cxx:104 PublicId:  SystemId: file:///tmp/bad.ods LineNumber: 2 ColumnNumber: 1
warn:xmlsecurity.comp:108746:108746:xmlsecurity/source/component/documentdigitalsignatures.cxx:494: Error, no XStorage provided

So I applied the same as:
https://bugs.documentfoundation.org/show_bug.cgi?id=116079#c19
Comment 7 Julien Nabet 2020-07-23 14:16:59 UTC 
SHJ: thought it could be interesting you upgrade Jasper reports version.