Calc needs very long to load, hangs at Adapt Row Height

calc

asked 2019-10-06 16:01:32 +0100

updated 2019-10-06 16:03:40 +0100

Loading a Calc sheet (< 1 MB) takes almost 8 minutes to load. It appears to come from 'Adapt row height' that takes so long to do. A solution in https://forum.openoffice.org/en/forum... does not work (this is adding code to standard module1 macro: TL;DR Run "LoadCalcDocumentWithoutAdjustHeight" ). The problem seems to be caused by one worksheet with some 8000 rows. Nothing fancy in these cells, just data and a linked graph.

edit retag flag offensive close merge delete

add a comment

0

answered 2020-03-26 22:48:18 +0100

Problematic
1 ●1

I had a problem involving "adapt row height." These words appeared in a flickering green bar at the botttom of the window each time I selected an element of my spreadsheet. I seem to have eliminated this. I have no idea if this bares on your issue, but the details are at: https://ask.libreoffice.org/en/questi...

edit flag offensive delete link

add a comment

0

answered 2019-10-06 22:22:22 +0100

erAck

8584 ●42 ●78 https://erack.de/

Probably formula recalculations are involved that are executed to determine the row heights of results. Whatever is meant by "a linked graph", if external links are involved a long load time may be due to timeouts when trying to access external data.

edit flag offensive delete link

Comments

It is a graph linked to data on the same worksheet/file.

Marcel van der Weijden ( 2019-10-07 19:27:17 +0100 )edit

add a comment

Calc needs very long to load, hangs at Adapt Row Height

2 Answers

Comments

Question Tools

Stats

Related questions

Calc needs very long to load, hangs at Adapt Row Height edit

2 Answers

Comments

Question Tools

Stats

Related questions

Calc needs very long to load, hangs at Adapt Row Height