I have ubuntu 18.04, Intel CPU with 8 cores, and 64 GB ram.
I also have a ~12mb .xls file with 65000 rows, and ~10 columns, mostly integers, 2 columns with text.
I need to filter values in 1 column with integers. So I set a Filter for the upper row, and then try to input a certain integer value (product ID) to hide all products with different IDs.
After pressing the first keyboard button the Calc freezes for like 5 minutes. One CPU core is constantly loaded to 100%.
Same file, same procedure on a crappy laptop with Windows and Excel takes fraction of a second to filter the rows.
Tried to convert the file into the “open format xls” and “ods spreadsheet” - zero difference.