Ask Your Question

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

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

Marcel van der Weijden gravatar image

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

2 Answers

Sort by » oldest newest most voted

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

Problematic gravatar image

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:

edit flag offensive delete link more

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

erAck gravatar image

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 more


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

Marcel van der Weijden gravatar imageMarcel van der Weijden ( 2019-10-07 19:27:17 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


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

Seen: 341 times

Last updated: Mar 26 '20