I am using LibreOffice 24.2.6.2 under Endeavor Os on an old DELL 9020 I7-4790 with 16GB of ram. The help tag gives the Linux version as 6.6, I assume that is the kernel designation. Opening an empty spreadsheet page, over the course of maybe 30 minutes to an hour, my memory use goes over 90%.
Predictably, the system is very sluggish at that point.
This happens even when Libreoffice is the only application running, and does not happen at all when using my browser or other applications, singly or in combinations. Closing Libreoffice then frees the memory and my system speed returns. This is with a blank spreadsheet page, but spreadsheets I built for tracking investments do the same thing.
I should add that the same thing happens in Writer as well as Calc.