Bug 82092 - FORMATTING: if the whole worksheet is formatted Calc becomes slow
Summary: FORMATTING: if the whole worksheet is formatted Calc becomes slow
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.0.4 release
Hardware: x86-64 (AMD64) Linux (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-08-03 12:53 UTC by istvanabadszarka
Modified: 2015-06-23 13:33 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Test spreadsheet slow scroll or Help Menu (325.81 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-06-09 11:04 UTC, Carlos Rodriguez
Details

Note You need to log in before you can comment on or make changes to this bug.
Description istvanabadszarka 2014-08-03 12:53:12 UTC
Hi,

If I select the whole worksheet by clicking the top-left of the 'Column & Row Headers' and change the font (to get a uniform look for the worksheet), then Calc becomes slow to display when scrolling.

It can be fixed by saving and reopening the workbook, but still...

Xubuntu 14.04.1 LTS
LibreOffice 4.3.0.4
Build ID: 62ad5818884a2fc2e5780dd45466868d41009ec0
Comment 1 Joel Madero 2014-09-04 09:42:55 UTC
This happens with an empty sheet or with a sheet that has data? Marking as NEEDINFO - if it's with a worksheet with data - please attach a worksheet that we can see the issue and then mark as UNCONFIRMED.

Also - do you know if this is new to 4.3? Version is the oldest version that you see the problem, not the latest version.

Thanks for your help.
Comment 2 istvanabadszarka 2014-09-07 15:16:17 UTC
I am experiencing the error with Calc 4.3.1.2 too.

It happens both with an empty sheet and one that has some content, the more the content the worse it gets.

Saving and reopening the file fixes the problem, so I feel that it is better if I write down what to do the get what I was writting about:

1. New worksheet
2. Select a range of a bit bigger size: e.g. A1:N33
3. Write 'apple' in the Input line
4. Alt+Enter
5. Click to unselect the range and try scrolling
6. Click on the top left of the Column and Row headers selection the whole sheet
7. Change the font
8. Click to unselect and try scrolling again

Selecting, scrolling and many things should get slower.
Comment 3 Buovjaga 2014-11-27 08:47:26 UTC
No slowness for me. Setting to UNCONFIRMED & lowering severity per https://wiki.documentfoundation.org/images/0/06/Prioritizing_Bugs_Flowchart.jpg

Win 7 64-bit Version: 4.5.0.0.alpha0+
Build ID: b144f0ac8695dd62a2053b4e88212d0b109c9a41
TinderBox: Win-x86@51-TDF, Branch:MASTER, Time: 2014-11-25_00:14:54

Ubuntu 14.10 64-bit Version: 4.5.0.0.alpha0+
Build ID: 6b219f012edbe069c461f4e0746898e33fa1dd49
TinderBox: Linux-rpm_deb-x86_64@46-TDF-dbg, Branch:master, Time: 2014-11-25_21:56:46
Comment 4 raal 2014-11-29 18:29:23 UTC
Hello,
I can confirm with LO 4.3.3.2, 4.3.6.0.0+, but cannot confirm with Version: 4.4.0.0.beta1+, linux. Please could you try with dev version?
Comment 5 Buovjaga 2014-12-03 20:08:05 UTC
Setting to NEEDINFO per comment 4. Set to UNCONFIRMED, if the problem persists for you in 4.4 beta. Set to RESOLVED WORKSFORME, if the problem went away.

If you would like to see a backport to 4.3 happen for the fix, you would have to do a bibisect to find out the exact commit that fixed it. Even then, it is up to developers' interest/time to make the backport.

https://wiki.documentfoundation.org/QA/HowToBibisect
Comment 6 istvanabadszarka 2015-03-12 15:31:10 UTC
I am still experiencing this with Libreoffice 4.4.0.3
(Build ID: de093506bcdc5fafd9023ee680b8c60e3e0645d7)

In addition, I can say that after performing the steps written on 2014-09-07, the whole program becomes slower, feels overburdened. 
For example:
 - the menus open down slower
 - the "Save document?" dialog when closing appears much slower
Comment 7 raal 2015-03-12 15:57:47 UTC
(In reply to istvanabadszarka from comment #6)
> I am still experiencing this with Libreoffice 4.4.0.3
> (Build ID: de093506bcdc5fafd9023ee680b8c60e3e0645d7)
> 
> In addition, I can say that after performing the steps written on
> 2014-09-07, the whole program becomes slower, feels overburdened. 
> For example:
>  - the menus open down slower
>  - the "Save document?" dialog when closing appears much slower

Last version is 4.4.1.2, but setting UNCO
Comment 8 istvanabadszarka 2015-03-16 14:42:34 UTC
I tried it with version 4.4.1.2, and I still have the problem.
Comment 9 Carlos Rodriguez 2015-06-09 11:04:44 UTC
Created attachment 116412 [details]
Test spreadsheet slow scroll or Help Menu

Trying to give some help, we have a spreadsheet with little data but with hundreds of conditionals formats and I can see the behavior. Just open the file attached and open Help Menu or scroll down... it goes really slow.

Affected versions:

Versión: 4.3.7.2
Id. de compilación: 8a35821d8636a03b8bf4e15b48f59794652c68ba

Version: 5.0.0.0.beta2+
Build ID: 233a52af646f73a9ef0d53dd27f2823e8c362728
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-5-0, Time: 2015-06-09_08:19:23
Locale: es-ES (es_ES.UTF-8)

After some seconds (60s or so) the Help Menu opens fine.

NOT affected versions:

Versión: 4.4.3.2
Id. de compilación: 88805f81e9fe61362df02b9941de8e38a9b5fd16
Configuración regional: es_ES

Version: 4.4.5.0.0+
Build ID: 7f605eb84c2b647a87b9bd96ca91c3170b3c84e6
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-4, Time: 2015-06-08_11:05:57
Locale: es_ES.UTF-8
Comment 10 Carlos Rodriguez 2015-06-21 11:12:18 UTC
Seems to be fixed on:

Version: 5.0.0.1
Build ID: 9a0b23dd0ab9652e0965484934309f2d49a7758e
Locale: es-ES (es_ES.UTF-8)

Well done guys!! You rock!!
Comment 11 Joel Madero 2015-06-22 13:31:25 UTC
Per last comment setting as WFM. If others want to test on master feel free to do so: http://dev-builds.libreoffice.org/daily/master/ or get the pre-release dev-builds.libreoffice.org/pre-releases/
Comment 12 Carlos Rodriguez 2015-06-23 13:33:19 UTC
Also fixed on:

Version: 5.1.0.0.alpha1+
Build ID: a64999511ae654131d997eec9a3d78478cfc1c75
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-06-22_05:01:17
Locale: es-ES (es_ES.UTF-8)