Bug 130810 - soffice --headless --convert-to xlsx with a large MS Excel XML file gives Error: source file could not be loaded
Summary: soffice --headless --convert-to xlsx with a large MS Excel XML file gives Err...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.3.6.1 release
Hardware: IA64 (Itanium) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-02-20 13:20 UTC by Nitin
Modified: 2020-02-20 14:31 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
This is an MS Excel XML with anonymised data for testing. (11.55 MB, text/xml)
2020-02-20 13:49 UTC, Nitin 		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 Nitin 2020-02-20 13:20:01 UTC 
Description:
I am converting MS Excel 2007 XML spreadsheet (not the XLSX) to xlsx file
using the following command:
/usr/lib64/libreoffice/program/soffice.bin --headless --invisible --nodefault --nofirststartwizard --nolockcheck --nologo --norestore  --convert-to xlsx --outdir /var/tmp test.xml.
This fails with the message: Error: source file could not be loaded

File size of this xml file is 11Mb.
Other smaller file (upto 5Mb) are converted without any proble.


Steps to Reproduce:
1. Pick any XML file larger than approx. 5Mb
2. use command: /usr/lib64/libreoffice/program/soffice.bin --headless --invisible --nodefault --nofirststartwizard --nolockcheck --nologo --norestore  --convert-to xlsx --outdir /var/tmp test.xml

3.

Actual Results:
No xlsx file created.
Get the message "Error: source file could not be loaded"
The status returned by soffice is: 0

Expected Results:
xlsx file shoud be created in /var/tmp directory


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
When opening the same file in the interactive session of Libreoffice,
It gives General Input/Output error.
When press retry button on this message box, it opens the file with no further error.

The file in this case have 15922 rows.
Comment 1 Nitin 2020-02-20 13:49:28 UTC 
Created attachment 158045 [details]
This is an MS Excel XML with anonymised data for testing.

Please see attached MS Excel XML with anonymised data for reproducing the issue in the support.
Comment 2 Julien Nabet 2020-02-20 14:06:30 UTC 
On Win10 with LO 6.3.4, no problem to open the file.

5.3.6 is an old version, could you give a try to last stable LO version 6.3.4?

(also, please compress your file instead of sending a file of 11,5MB, the same file zipped is less than 400kb)
Comment 3 Nitin 2020-02-20 14:14:51 UTC 
Thanks.
I will take care and upload zip files.
As per our linux system administrator's the libreoffice-5.3.6.1-21.el7.x86_64  
is the latest available for the Linux!!
I am not allowd to download/install any software.
Comment 4 Julien Nabet 2020-02-20 14:22:35 UTC 
What's your Linux distrib?
If it's already fixed on a newer version, we won't be able to do anything.
Comment 5 Nitin 2020-02-20 14:24:37 UTC 
Thanks.
I will ask the Linux admin to get the new version.
Comment 6 Julien Nabet 2020-02-20 14:31:12 UTC 
Since there's no specific fix, let's put this one to WFM then.