138060 – Very slow when setting cell formula between different sheets with column/row freeze enabled (dbgutil build)

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 ...

Status:	RESOLVED WORKSFORME

Alias:	None

Product:	LibreOffice
Classification:	Unclassified
Component:	Calc (show other bugs)
Version: (earliest affected)	7.1.0.0.alpha0+
Hardware:	All Linux (All)

Importance:	medium normal
Assignee:	Not Assigned

URL:
Whiteboard:
Keywords:

Depends on:
Blocks:

Reported:	2020-11-08 03:05 UTC by Kevin Suo
Modified:	2022-08-26 13:36 UTC (History)
CC List:	1 user (show)

See Also:	47349
Crash report or crash signature:

Attachments
autogen.input (1000 bytes, text/plain) 2020-11-08 03:10 UTC, Kevin Suo	Details
View All Add an attachment (proposed patch, testcase, etc.)

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)

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. Type "=" in Sheet2.C4, click Sheet1, click Sheet1.A1, 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 1 Kevin Suo 2020-11-08 03:07:40 UTC Comment hidden (obsolete)

At step 4, you need to click the formula bar first, to bypass the bug 47349.

The freeze in step 4 is also reproducible with the following patch applied:
https://gerrit.libreoffice.org/c/core/+/105429

Comment 2 Kevin Suo 2020-11-08 03:10:50 UTC

Created attachment 167087 [details]
autogen.input

This is the compiling options used.

Comment 3 Kevin Suo 2020-11-08 03:45:10 UTC Comment hidden (obsolete)

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. Type "=" in Sheet2.C4, click Sheet1, click Sheet1.A1, type "+", 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 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)

[Automated Action] NeedInfo-To-Unconfirmed

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