Bug 125377 - XLSX document saved by Calc as ODS crashes Calc.
Summary: XLSX document saved by Calc as ODS crashes Calc.
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.5.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 125376 (view as bug list)
Depends on:
Blocks:
 
Reported: 2019-05-19 23:56 UTC by Grimeton
Modified: 2019-05-20 21:56 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Grimeton 2019-05-19 23:56:30 UTC
Description:
Hi,

this is going to be a bit more complicated. 

I'm running the following Libreoffice version:

Version: 6.1.5.2 (x64)
Build-ID: 90f8dcf33c87b3705e78202e3df5142b201bd805
CPU-Threads: 8; BS: Windows 10.0; UI-Render: Standard; 
Gebietsschema: de-DE (de_DE); Calc: CL

There's this game called "The Division 2" and a lot of people made so called "Gear Set Builder". They can be found online and are available for the public. One of those documents is available via Google here:

https://docs.google.com/spreadsheets/d/e/2PACX-1vTMyKlW90Q2H3RDKXF7cISzVgs7aM9tjqFtf2ZH6i1e_U_8K_LUD2-2ccTrXrgsLBUW15U-9z7u5tgz/pubhtml#

When you check the "Landing Page", you see that it can be downloaded as PDF here:

https://www.google.com/url?q=https://docs.google.com/spreadsheets/d/e/2PACX-1vTMyKlW90Q2H3RDKXF7cISzVgs7aM9tjqFtf2ZH6i1e_U_8K_LUD2-2ccTrXrgsLBUW15U-9z7u5tgz/pub?output%3Dpdf&sa=D&ust=1558306155334000&usg=AFQjCNGV5jIztGuK-LdXCuPwyQ8ib3Y7jA

There's no option to download it as XSLX or as ODS but by modifying the URL you can get an XLSX or ODS download.

XLSX: https://www.google.com/url?q=https://docs.google.com/spreadsheets/d/e/2PACX-1vTMyKlW90Q2H3RDKXF7cISzVgs7aM9tjqFtf2ZH6i1e_U_8K_LUD2-2ccTrXrgsLBUW15U-9z7u5tgz/pub?output%3Dxlsx&sa=D&ust=1558306155334000&usg=AFQjCNGV5jIztGuK-LdXCuPwyQ8ib3Y7jA

ODS: https://www.google.com/url?q=https://docs.google.com/spreadsheets/d/e/2PACX-1vTMyKlW90Q2H3RDKXF7cISzVgs7aM9tjqFtf2ZH6i1e_U_8K_LUD2-2ccTrXrgsLBUW15U-9z7u5tgz/pub?output%3Dods&sa=D&ust=1558306155334000&usg=AFQjCNGV5jIztGuK-LdXCuPwyQ8ib3Y7jA

Note the "output" parameter in the URL.

The first thing that you see is that opening the ODS file with Libreoffice crashes it immediatly. It then restarts, tries to recover and crashes again. This can turn into an endless loop with multiple soffice.bin processes becoming stuck in the background.

This in itself would be a bug, but yeah, if Google doesn't provide the right document format...

Nevertheless, now it's getting interesting:

I am able to open the XLSX version of the document. Work with it, modify it, everything. When saving it as an ODS later on, it seems to work as well, at least most of the time...

Saving the document as ODS already crashes Libreoffice half of the time. The other half produces a file, which when opened, then crashes Libreoffice. Also storing the file as XLSX again crashes Libreoffice.

I have no idea what is going on with this file, but it's really strange.

Feel free to download the files above, they're shared on Reddit and on the Ubisoft forums and are available to the public. Also if you have further questions please let me know and I'll try to answer.

As mentioned below and tested later: DISABLING OPENGL FIXES IT.

Thanks!

KR,

Oliver



Steps to Reproduce:
1. Read the Description
2.
3.

Actual Results:
Crashes Calc as written in the description.

Expected Results:
Shouldn't crash Calc as written in the description.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
OS is Windows 10 1803 Enterprise. 
System is an Intel Xeon, 64GB Memory.
If you need further information contact me.

Version: 6.1.5.2 (x64)
Build-ID: 90f8dcf33c87b3705e78202e3df5142b201bd805
CPU-Threads: 8; BS: Windows 10.0; UI-Render: Standard; 
Gebietsschema: de-DE (de_DE); Calc: CL

I tried to use safe mode, but it crashed as well. The crash report that was uploaded and was mentioned in the message is as follows:


https://crashreport.libreoffice.org/stats/crash_details/a4e61782-0640-4827-b019-affa9f9069b4

OpenGL is enabled. 

Renderer: GeForce GTX 1060 6GB/PCIe/SSE2
Vendor: NVIDIA Corporation
Memory: 4095 MB
Version: 4.6.0 NVIDIA 430.64
Shading language version: 4.60 NVIDIA


I got a full 100% on everything that is in the tree on the left side. 4.6 and ARB 2015 have a 100% support.

I tested what was mentioned in the link below and DISABLING OPENGL FIXES THE PROBLEM.
Comment 1 Xisco Faulí 2019-05-20 08:59:40 UTC
*** Bug 125376 has been marked as a duplicate of this bug. ***
Comment 2 Xisco Faulí 2019-05-20 09:00:35 UTC
I can't reproduce it in

Versión: 6.2.3.2
Id. de compilación: aecc05fe267cc68dde00352a451aa867b3b546ac
Subprocs. CPU: 1; SO: Windows 6.1; Repres. IU: predet.; VCL: win; 
Configuración regional: es-ES (es_ES); Idioma de IU: es-ES
Calc: threaded

Could you please try to reproduce it with the version 6.2.3.2 of LibreOffice
from https://www.libreoffice.org/download/libreoffice-fresh/ ?
I have set the bug's status to 'NEEDINFO'. Please change it back to
'UNCONFIRMED' if the bug is still present in the latest version.
Comment 3 Grimeton 2019-05-20 20:38:46 UTC
Hello,

first of all sorry that the Bug has been posted twice. The first time the bugtracker told me that I don't have a token to post a bug. I wasn't aware of the fact that it was already posted.

When running this on 6.2.3.2 with OpenGL enabled/disabled it both works. So I guess whatever it is, it has been fixed in the later version.

Thanks for your help!

KR,

Oliver.
Comment 4 Xisco Faulí 2019-05-20 21:56:05 UTC
Thanks for retesting with the latest version.
Setting to RESOLVED WORKSFORME as the commit fixing this issue hasn't been identified.