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

[MarcelvanderWeijden]

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 [Solved] How to stop "Adapt Row Height"? (View topic) • Apache OpenOffice Community 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.

[erAck]

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.

[MarcelvanderWeijden]

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

[Problematic]

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:

calc turn off Adapt Row height

Using the latest version of libre office on a .xls sheet in Windows 10 I did something, and now every time I move up or down a row there is a delay for ‘Adapt Row Height’ It slows the whole thing down enough to make the thing unuseable. I have seen one or two suggested solutions but nothing which has worked for me. I have been using spreadsheets since Borland Quattro - but this has me beat.