Bug 139468 - temps d'ouverture de fichier ods très long
Summary: temps d'ouverture de fichier ods très long
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.4.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-01-07 13:32 UTC by chrcqt@gmail.com
Modified: 2021-08-18 13:00 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
.ods test file (7.79 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-01-07 17:08 UTC, chrcqt@gmail.com
Details

Note You need to log in before you can comment on or make changes to this bug.
Description chrcqt@gmail.com 2021-01-07 13:32:58 UTC
Description:
sur un PC sous Windows 10, j'utilise LibreOffice 7.0.4
quand j'ouvre un petit fichier de 48 Ko avec extension ods, Libreoffice met 50 secondes pour m'afficher le fichier.
lorsque le même fichier est en format xlsx, Libreoffice met moins de 10 secondes pour l'ouvrir.

Actual Results:
ouverture fichier ods trop longue : 50 sec

Expected Results:
ouverture fichier ods en moins 10 sec


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.0.4.2 (x64)
Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: fr-FR (fr_FR); Langue IHM : fr-FR
Calc: threaded
Comment 1 m_a_riosv 2021-01-07 15:28:41 UTC
Please report in English.

Can you attach a sample file to test.
Comment 2 chrcqt@gmail.com 2021-01-07 17:08:35 UTC
Created attachment 168755 [details]
.ods test file

il me faut plus de 50 sec pour ouvrir ce fichier .ods

alors que s'il est sauvegardé en .xlsx il faut à peine 5 sec

ceci avec tous les fichiers ods sur mon PC
Comment 3 QA Administrators 2021-01-08 04:21:28 UTC Comment hidden (obsolete)
Comment 4 wingednova 2021-02-04 15:14:17 UTC
Report in English (translated to the best of my ability, please feel free to correct it as required):

Description:
I am using LibreOffice 7.0.4 on a Windows 10 PC. When I open a small 48 KB file with .ods extension, LibreOffice takes 50 seconds to display the file to me.
When the same file is in .xlsx format, LibreOffice takes less than 10 seconds to open it.

[Not in original report] Steps to reproduce:
1. Open attachment in .ods and .xlsx and compare display times.

Actual Results:
Opening .ods file too long: 50 sec

Expected Results:
Opening ods file in less than 10 sec

User Profile Reset: No

Additional Info:
Version: 7.0.4.2 (x64)
Build ID: dcf040e67528d9187c66b2379df5ea4407429775
CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win
Locale: fr-FR (fr_FR); Langue IHM : fr-FR
Calc: threaded

-- further comment --
[Attachment] test file

I need more than 50 sec to open this .ods file, whereas if it is saved in .xlsx it hardly takes 5 sec. This happens with all .ods files on my pc
Comment 5 wingednova 2021-02-04 15:19:32 UTC
Could not reproduce - both files open in roughly 3-4s for me. 

Version: 7.0.3.1 (x64)
Build ID: d7547858d014d4cf69878db179d326fc3483e082
CPU threads: 8; OS: Windows 10.0 Build 19041; UI render: Skia/Vulkan; VCL: win
Locale: en-IN (en_IN); UI: en-US
Calc: threaded
Comment 6 Stéphane Guillou (stragu) 2021-08-16 07:47:49 UTC
--- French

Bonjour chrcqt!
Je viens d'essayer le fichier sur Windows 10 aussi, et je n'ai pas non plus eu de problème avec la versino 7.0.6.

Comme nous ne pouvons pas reproduire le problème (moi et wingednova), je vais fermer ce ticket avec le statut "WORKSFORME" ("ça marche pour moi"), mais n'hésite pas à le remettre à "UNCONFIRMED" si tu peux toujours voir le problème avec la version 7.0.6, ou une version plus récente (comme 7.1 ou 7.2).

Merci!

--- English

Hi chrcqt!
I just tried the same file on Windows 10, and couldn't reproduce with LO 7.0.6.

Given that we can't reproduce (wingednova and me), I am setting this report to WORKSFORME, but please do not hesitate to set it to UNCONFIRMED again once you have witnessed the issue in an updated version of LibreOffice, 7.0.6 or later.

Cheers!

--- Version details:

Version: 7.0.6.2
Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b
CPU threads: 8; OS: Linux 4.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

and 

Version: 7.0.6.2 (x64)
Build ID: 144abb84a525d8e30c9dbbefa69cbbf2d8d4ae3b
CPU threads: 8; OS: Windows 10.0 Build 19042; UI render: default; VCL: win
Locale: en-AU (en_AU); UI: en-US
Calc: threaded
Comment 7 Stéphane Guillou (stragu) 2021-08-16 07:50:20 UTC
Oh, et si tu testes avec une version plus récente, pense aussi à réinitialiser le profil d'utilisateur: https://wiki.documentfoundation.org/UserProfile/fr#L.27assistant_.28LibreOffice_5.3_et_versions_plus_r.C3.A9centes.29

---

If you re-test in a more recent version, please also reset your user profile.
Comment 8 Timur 2021-08-18 13:00:07 UTC
WFM is when bug was reproduced and fixed. 
Here it's InsufficientData.
https://bugs.documentfoundation.org/page.cgi?id=fields.html#bug_status

In this case it's advisable to do User Profile reset/rename/delete.