Bug 138060 - Very slow when setting cell formula between different sheets with column/row freeze enabled (dbgutil build)
Summary: Very slow when setting cell formula between different sheets with column/row ...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: All Linux (All)
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2020-11-08 03:05 UTC by Kevin Suo
Modified: 2022-08-26 13:36 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

autogen.input (1000 bytes, text/plain)
2020-11-08 03:10 UTC, Kevin Suo

Note You need to log in before you can comment on or make changes to this bug.
Description Kevin Suo 2020-11-08 03:05:39 UTC Comment hidden (obsolete)
Comment 1 Kevin Suo 2020-11-08 03:07:40 UTC Comment hidden (obsolete)
Comment 2 Kevin Suo 2020-11-08 03:10:50 UTC
Created attachment 167087 [details]

This is the compiling options used.
Comment 3 Kevin Suo 2020-11-08 03:45:10 UTC Comment hidden (obsolete)
Comment 4 Kevin Suo 2020-11-08 03:55:31 UTC
Steps to Reproduce:

1. Build libreoffice with dbgutil enabled.

2. New Calc, two sheet1: Sheet1 and Sheet2.

3. Freeze column and row at cell Sheet2.C4.

4. Try to set formula reference "=sum(Sheet1.A:A, Sheet2.A:A)", with your mouse click:
Type "=sum(" in Sheet2.C4, click Sheet1, click formula input bar, click any column label in sheet1, type "," (i.e., the formula seperater, may be ";" in some locales), then click Sheet2.

--> Calc freezes for around 40s before being responsive.

Expect to be responsive immediately. Only reproducible with a dbgutil build, not with a normal build.

source-commit: 7dc234fa57ca409d0db131c93abea738014b5e1f
Fedora 32.
Comment 5 Kevin Suo 2020-11-08 12:07:48 UTC
Set to NEEDINFO from me myself, as I need to check whether it is related to ccache.
Comment 6 QA Administrators 2020-11-09 04:18:54 UTC Comment hidden (obsolete)
Comment 7 Kevin Suo 2020-11-15 15:19:38 UTC
Set back to UNCONFIRMED as I still reproduce this with a clean build.
Comment 8 Buovjaga 2021-07-27 14:34:53 UTC
Debug and dbgutil builds do not have normal performance, so I'm not sure if we should care about this