I’m using LO 220.127.116.11 on MacOS Mojave 10.14.6, trying to interact with a spreadsheet I’ve used for my banking for over almost 20 years. It’s got about 9700 rows, and really only one simple formula which calculates a “Balance” column from “Credits” and “Debits” columns. It’s always been spry and worked fine in Excel.
In Calc, though, it’s fine when I open the spreadsheet (which, btw, is now an .ods file), but once I do anything like hit Save, clear an AutoFilter, etc, any mouse click interaction is agonizingly laggy. Click into a cell, cell is selected at least 2 seconds later. Click into a cell and move the mouse pointer, the cell where the mouse pointer moved to is now selected (2-3 seconds later), not the original cell.
I’ve tried several troubleshooting tips already: disabled OpenGL, imported the sheet into a fresh new spreadsheet, deleted all comments (there were many), open LO in Low Resolution…none of this fixes the problem. Lag city. This occurs as an .ods file and in the original .xlsx format.
Trying to love LO, but I’ve got a foot out the door. This is driving me mental. Any suggestions?