calc turn off Adapt Row height

edit

I agree that after copying only this used range to a new spreadsheet, the program runs at usable speed.

Here is my proposed a reason for it:

My spreadsheet was originally an XLSX, resaved as ODS. On loading in LO Calc (6.4, x64) the program reported possible data loss: "... the maximum number of columns per sheet was exceeded". I ignored this because only columns A to P contained data, not the 1024 that is the limit of Calc. However, Calc is clearly reformatting far more data cells than necessary every time the cursor is moved.

There is a technical discussion of misunderstandings between Excel and Calc over columns here > https://github.com/PHPOffice/PhpSprea...

A quicker fix than creating a new sheet might be to cut and paste only the required range within the original sheet.

UPDATE 2: I have realized that the "adapt cell height" message appears EVERY time I make any selection in any spreadsheet in LO. It becomes a problem when it appears long enough to notice, or more importantly, long enough to notice an impact on performance. I didn't notice it at all until my spreadsheet got larger, then it was impossible not to notice when I multiplied the formats in a cell. So, my original "solution," if that's what it is, stands, as making the described change makes the appearance of the notice very brief. Again, apologies.

UPDATE: The "adapt cell height" issue has reappeared. And I still have the formatting issue as well. Sorry all.

I was having a similar issue. (I hope "was.") In my case, I was seeing the "adapt row height" indication, but not experiencing a noticeable impact on performance. I tried undoing changes I had made and I believe I have traced it to the use of different formats inside of a single cell. I had used "bold" text on only a portion of the text in a cell and left other text in the same cell at defaults. I reformatted the cells in question to a single format for the entire cell and the "adapt row height" that was displayed has not returned. I have used multiple formats per cell in previous versions (way previous versions) of LO without issue. I hope this feature can be repaired. FYI, I am working in an .ods spreadsheet in calc that I originally opened from a .wks (MS Works 2000) spreadsheet. ADDITIONAL: At about the same time I found I could no longer apply formatting to multiple cells after selection. I must select single cells and format them one at a time. I have not solved that yet. I have not tested this in other files yet. Will do so and probably post separately as a question.