Description: Very long time opens XLSX file with 1500 comments in cells. About 50 sec in Version: 6.2.0.0.alpha0+ (x64) Build ID: d0425778eef7ea20ccc19834c07d0b265f58baf0 CPU threads: 4; OS: Windows 10.0; UI render: GL; TinderBox: Win-x86_64@42, Branch:master, Time: 2018-08-08_03:06:53 Locale: ru-RU (ru_RU); Calc: CL If I create ODS file with same content, then it opens about 6 sec Steps to Reproduce: 1. Try open xlsx file from attach 2. 3. Actual Results: Very long time opens XLSX file with 1500 comments in cells Expected Results: XLSX file with 1500 comments in cells opens more fast (for example, as ODS with same content) Reproducible: Always User Profile Reset: No Additional Info:
Created attachment 144596 [details] Example XLSX file with 1500 comments
Created attachment 144597 [details] Example ODS file with 1500 comments
I can confirm with Version: 6.2.0.0.alpha0+ Build ID: 4b5fcd417587cfb9e6d8b61ecb037ab165eeb5b9 CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk3; and 4.1 3 sec ODS, 20 sec XLSX
Created attachment 145131 [details] Callgrind output from master (fileopen xlsx) Arch Linux 64-bit Version: 6.2.0.0.alpha0+ Build ID: 8b1501d80dc9d3f42c351c6e026fa737e116cae5 CPU threads: 8; OS: Linux 4.18; UI render: default; VCL: gtk3_kde5; Locale: fi-FI (fi_FI.UTF-8); Calc: threaded Built on 23 September 2018
Noel, may be you will be interesting this bug
it takes real 0m12,171s user 0m11,854s sys 0m0,282s in Version: 6.3.0.0.alpha0+ Build ID: 0a04150b6eefb5feb7ecefaa5cd63dbac8c1574f CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US Calc: threaded @Kompi, could you please recheck ?
(In reply to Xisco Faulí from comment #6) > it takes > > real 0m12,171s > user 0m11,854s > sys 0m0,282s > > in > > Version: 6.3.0.0.alpha0+ > Build ID: 0a04150b6eefb5feb7ecefaa5cd63dbac8c1574f > CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; > Locale: ca-ES (ca_ES.UTF-8); UI-Language: en-US > Calc: threaded > > @Kompi, could you please recheck ? I got 22 sec in build from 24 April 2019 Version: 6.3.0.0.alpha0+ Build ID: 951282a27a9dd4c64fc206fcbdd805b4cb602816 CPU threads: 4; OS: Windows 6.1; UI render: default; VCL: win; Locale: ru-RU (ru_RU); UI-Language: en-US Calc: threaded There is a progress here. But I see that file opens faster in Linux than in Windows. Another problem?
(In reply to Roman Kuznetsov from comment #7) > > I got 22 sec in build from 24 April 2019 it doesn't sound like 'very long time' to me. Updating summary
(In reply to Xisco Faulí from comment #8) > (In reply to Roman Kuznetsov from comment #7) > > > > I got 22 sec in build from 24 April 2019 > > it doesn't sound like 'very long time' to me. Updating summary but it's still in about 4 time more than ODS I don't think it is "small delay"
comments are slow in calc anyway, since 'inherited from OO', and reported since #76324 and plenty subsequent, i - assume - your problem is not a single special bug, but just a facet of the / one major problem in design ... at least it's helpless to work on it while the main issue remains, as the results would be covered by the overall delays.
Created attachment 154887 [details] This document is also open slowly
takes 20 sec in Version: 6.5.0.0.alpha0+ (x64) Build ID: b6295e4a1b7735c148174f44f6d28221f4f52302 CPU threads: 4; OS: Windows 10.0 Build 18362; UI render: default; VCL: win; Locale: ru-RU (ru_RU); UI-Language: en-US Calc: threaded
it takes about 10 sec in Version: 7.0.0.0.alpha0+ (x64) Build ID: d8a52f21ce23a37f7d1137501... CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Vulkan; VCL: win; Locale: ru-RU (ru_RU); UI: en-US Calc: threaded and without skia it takes about 10 sec too
5 sec in Version: 7.3.0.0.alpha1+ (x64) / LibreOffice Community Build ID: 515682539623c9d61921c4f89302ffa0a4cb8d24 CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: ru-RU Calc: threaded
I think we can close it as WFM now