I’m fairly new to LO.
I have a spreadsheet that has 30,000 lines of data.
It’s got very slow when flitering and sorting.
Are there any hygiene principles I can know to reduce the hang? Or is it simply the size?
And generally should I avoid formulas that use a whole column, like SUM(A:A), or does Calc exclude empty cells when processing such a formula?
Thank you.
LO version
Version: 7.6.0.3 (X86_64) / LibreOffice Community
Build ID: 69edd8b8ebc41d00b4de3915dc82f8f0fc3b6265
CPU threads: 4; OS: Mac OS X 12.7.6; UI render: Skia/Raster; VCL: osx
Locale: en-GB (en_GB.UTF-8); UI: en-US
Calc: threaded
Hardware
| Model Name: | MacBook Air |
|---|---|
| Model Identifier: | MacBookAir7,2 |
| Processor Name: | Dual-Core Intel Core i5 |
| Processor Speed: | 1.6 GHz |
| Number of Processors: | 1 |
| Total Number of Cores: | 2 |
| L2 Cache (per Core): | 256 KB |
| L3 Cache: | 3 MB |
| Hyper-Threading Technology: | Enabled |
| Memory: | 8 GB |
