Bug 168715 - FILEOPEN OTS Slow opening of template with many external references
Summary: FILEOPEN OTS Slow opening of template with many external references
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.0.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: haveBacktrace
Depends on:
Blocks: Templates Performance
  Show dependency treegraph
 
Reported: 2025-10-06 11:07 UTC by Roman
Modified: 2026-01-28 19:50 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
test.tar (220.00 KB, application/x-tar)
2025-10-06 11:08 UTC, Roman
Details
test.tar (220.00 KB, patch)
2025-10-08 06:11 UTC, Roman
Details
video.mp4 (3.00 MB, video/mp4)
2025-10-08 08:13 UTC, Roman
Details
Zip file with the generated files (379.32 KB, application/zip)
2026-01-27 14:13 UTC, Buovjaga
Details
Perf flamegraph of file opening (699.26 KB, image/svg+xml)
2026-01-27 14:20 UTC, Buovjaga
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Roman 2025-10-06 11:07:12 UTC
Description:
EN: After changing the form of the document, the document began to take more than 5 minutes to open. The problem manifests itself in the same way, both when working on network drives and local ones.
RU: После изменения формы документа – документу на открытие стало требоваться времени более 5 минут. Проблема проявляется одинаково, что при работе на сетевых дисках, так и локальных.


Steps to Reproduce:
EN:1. Unpack the archive
2. Navigate to the location in the terminal
3. In the folder .00 Start sh
4. In the folder .00 Open sv.ots
5. Allow updating of links
6. We measure the time.


Actual Results:
EN: It takes a long time to update the links.
RU: Долго открывается обновление связей.


Expected Results:
EN: It opens within 5 minutes, no formulas are required, only final values.
RU: Открывается в течении 5 минут, не требуется использование формул, только конечных значений.



Reproducible: Always


User Profile Reset: Yes

Additional Info:
EN: A small table with 2 sheets and 10K rows per sheet.
RU: Маленькая таблица 2 листа и 10 к строк в листе.
Comment 1 Roman 2025-10-06 11:08:06 UTC
Created attachment 203160 [details]
test.tar

archiv
Comment 2 m_a_riosv 2025-10-06 22:08:07 UTC
The shablonsv1.ots opens without any delay.

Version: 25.8.2.1 (X86_64)
Build ID: 345526217a4027cb1b9ab39bd7153c8c141a1d64
CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded
Comment 3 Roman 2025-10-07 06:04:28 UTC
(In reply to m_a_riosv from comment #2)
> The shablonsv1.ots opens without any delay.
> 
> Version: 25.8.2.1 (X86_64)
> Build ID: 345526217a4027cb1b9ab39bd7153c8c141a1d64
> CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render:
> Skia/Raster; VCL: win
> Locale: es-ES (es_ES); UI: en-US
> Calc: CL threaded

4. In the folder .00 Open sv.ots
5. Allow updating of links
Comment 4 m_a_riosv 2025-10-07 16:27:01 UTC
(In reply to Roman from comment #3)
> ...

The same, with no delays in opening the file or allowing the links to be updated.

Version: 25.8.2.1 (X86_64)
Build ID: 345526217a4027cb1b9ab39bd7153c8c141a1d64
CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL threaded
Comment 5 Roman 2025-10-08 06:11:14 UTC
Created attachment 203194 [details]
test.tar
Comment 6 Roman 2025-10-08 06:13:08 UTC
Posted a patch. Sorry, I didn't finalize it with the cd command
Выложил патч. Извините не доработал с командой cd
Comment 7 Roman 2025-10-08 08:13:31 UTC
Created attachment 203198 [details]
video.mp4
Comment 8 Buovjaga 2026-01-27 14:13:15 UTC
Created attachment 205202 [details]
Zip file with the generated files

First open Calc, go to Tools - Options - Calc - General: Update links when opening - Always (from trusted locations). Then in LibreOffice - Security - Macro Security add the directory you will keep the files as a trusted location.

Unpack the .zip and open
test/.00/sv.ots

It already takes over 5 mins in 7.0 (I cancelled).

Arch Linux 64-bit
Version: 26.8.0.0.alpha0+ (X86_64)
Build ID: e7edd94565e8dd323395ec316c482ec32f14638c
CPU threads: 8; OS: Linux 6.18; UI render: default; VCL: gtk3
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Calc: CL threaded
Built on 23 January 2026
Comment 9 Buovjaga 2026-01-27 14:20:42 UTC
Created attachment 205203 [details]
Perf flamegraph of file opening