Bug 162751 - FiLEOPEN a xlsx file do not load - load blocked - only solution is to close / kill the application
Summary: FiLEOPEN a xlsx file do not load - load blocked - only solution is to close /...
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-09-02 16:59 UTC by garlic_throwing326
Modified: 2024-12-03 17:08 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
Spreadsheet with two tabs (1.01 MB, application/vnd.oasis.opendocument.spreadsheet)
2024-09-30 11:37 UTC, Peter
Details

Note You need to log in before you can comment on or make changes to this bug.
Description garlic_throwing326 2024-09-02 16:59:59 UTC
Hi,
I made several tests, including from a computer installed from scratch, with ubuntu 24.2, to avoid issue with my computer (under linux) or another computer (under windows 10)n the results are identicals:
- using Libreoffice 24.8 or 24.2.5, the file starts loading but stops in the middle of the progression bar,  popup displayed with 'force quit' or 'wait' 
I wait at least ten times .. with no success
- using Libreoffice 7.6.7.2, the file loads

I cannot share the xslx file as there are personnals data.
Comment 1 m_a_riosv 2024-09-02 20:27:59 UTC
Please attach a sample file, reduce the size as much as possible without private information, and paste the information in Menu/Help/About LibreOffice, there is a copy icon.
Comment 2 garlic_throwing326 2024-09-05 16:23:31 UTC
Ok
Thank you
First the copy/paste as asked: 

Version: 24.2.5.2 (X86_64) / LibreOffice Community
Build ID: d6e8b0f3fc6e8af2b00cf4969fd0d2fa45b9a62e
CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded

I am currently working on the xlsx file to anonymize it. Give me some time.

FYI, I asked the person to save the file xlsx as an ODS file. I then tried to load it with libreoffice 24.2.5.2, it works.
Comment 3 QA Administrators 2024-09-06 03:18:03 UTC Comment hidden (obsolete)
Comment 4 Peter 2024-09-30 11:37:04 UTC
Created attachment 196794 [details]
Spreadsheet with two tabs

I believe I have the same problem and this file I don't need to add anonymous data.
If you choose to save this file (it's currently an ods) as XSLX then it crashes Calc. 
It 100% repeatable. Please take a look.
Comment 5 Peter 2024-09-30 11:37:44 UTC
(In reply to Peter from comment #4)
> Created attachment 196794 [details]
> Spreadsheet with two tabs
> 
> I believe I have the same problem and this file I don't need to add
> anonymous data.
> If you choose to save this file (it's currently an ods) as XSLX then it
> crashes Calc. 
> It 100% repeatable. Please take a look.

This with the latest version 24.8.2.1
Comment 6 m_a_riosv 2024-09-30 16:57:38 UTC
Takes a lot of time to save, several minutes, but no crash. Opening takes less than a minute, but no crash.
Version: 24.8.2.1 (X86_64) / LibreOffice Community
Build ID: 0f794b6e29741098670a3b95d60478a65d05ef13
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded
Comment 7 Peter 2024-09-30 16:59:35 UTC
Does seem very inefficient, to save it in ODS format is instantaneous.
Can the inefficiency be detected?
Comment 8 m_a_riosv 2024-09-30 21:35:12 UTC
I cannot confirm it as NEW because the title does not match the behavior I find.

A performance analysis would be necessary to detect where the slowness is being caused.
Comment 9 Peter 2024-09-30 21:44:06 UTC
To help, I found it a little random. However it would always be when trying to save. Although I can imagine it is also loading too.

I originally started with a XSLX file and that failed just trying to save some extra rows (before I added the image on sheet 2). 

I then moved to an ODS and that failed "saving as", when I mean fail it didn't save within a reasonable amount of time. 

Eventually it did work, but again it seemed random.
I get the feeling it's a timing issue where it is waiting for something be searched on the disk and it missed the thread notification.

Only some thoughts and I might be barking up a different tree.
Comment 10 Buovjaga 2024-12-03 17:07:20 UTC
(In reply to garlic_throwing326 from comment #2)
> I am currently working on the xlsx file to anonymize it. Give me some time.

Any update?


(In reply to Peter from comment #4)
> Created attachment 196794 [details]
> Spreadsheet with two tabs
> 
> I believe I have the same problem and this file I don't need to add
> anonymous data.
> If you choose to save this file (it's currently an ods) as XSLX then it
> crashes Calc. 
> It 100% repeatable. Please take a look.

Please open a new report for it.
Comment 11 Buovjaga 2024-12-03 17:08:07 UTC
(In reply to Buovjaga from comment #10)
> (In reply to Peter from comment #4)
> > Created attachment 196794 [details]
> > Spreadsheet with two tabs
> > 
> > I believe I have the same problem and this file I don't need to add
> > anonymous data.
> > If you choose to save this file (it's currently an ods) as XSLX then it
> > crashes Calc. 
> > It 100% repeatable. Please take a look.
> 
> Please open a new report for it.

I forgot to mention that you don't have to upload the file again, you can just say attachment 196794 [details] to refer to it.