I’m using Version: 6.0.4.2 and I’m dealing with a large spreadsheet 90,000 + rows
Calc hangs. I read that in previous versions, one could increase the memory for such situations but that option seems to be missing in the most recent version.
Am I missing something?
Here is a straightforward answer that bypasses the outdated answers below. LibreOffice Freeze and Slowdown - "Memory" and "Undo" Settings
https://wiki.documentfoundation.org/ReleaseNotes/6.0#Configuration_Memory
read comment from Mike in bug
Specifically, in Options → LibreOffice → Advanced, click Open Expert Configuration; in the dialog, navigate to org.openoffice.Office.Common/Cache. The subelements and values there correspond to the old “Memory” settings page. And unless your spreadsheet uses large number of images/OLE objects, these settings are useless for your case - as for most other cases where people believe that the settings would improve things; which is the reason to remove them to reduce misconception.
This worked well and solved the problems I was having with calc and write constantly not responding, also crashing and having to recover the files, all very time consuming.
Hi Mike:
Can you let me to know what value is better in TotalCacheSize, ObjectCacheSize, ObjectReleaseTime, GraphicMemoryLimit? thanks
@joey.liao: if there were some “better values” (globally), we would definitely set them as the default; and current default values are what we suppose generally suitable in vast majority of cases.
You should experiment with the settings to decide if changing them improves things for your use case.
Can anyone tell me what values are acceptable and in what subelement to change the values so that I can improve the RAM for my use of Writer? Writer has been crashing on me and unexpectedly freezing up. I suspect this might have something to do with it. I’m using Windows 7, 64 bit. 6.1.3
These options were “hidden”, and are expert configuration for a reason. There’s no “acceptable” values, only trial and error may help you.
Or may not: the settings control very specific area in memory management. In most aspects, LibreOffice doesn’t need any adjustments to just consume all available memory.
This worked great, but each click to get to the cache option took forever until I discovered you click, then focus the cursor in the Search box at the top of the dialog. Suddenly whatever you clicked is highlighted, is opened, etc. You have to click in the search box each time. My settings for Writer and Drawing Engine were set to 20, and I made them both 200. I saved it all, backed out, then saved the document, closed LibreOffice Calc,then reopened it. It is lightning fast! I think the developers should have the memory option in an installation wizard. These days, 20 is totally insufficient, especially for version 6. And people have lots of memory now-a-days too.
Took a long time to find the Crash Solution in 7.3.
This Post may be old but it solved problem. Thank you.
I found that bumping up the older “Memory” settings, resolved a very consistent crash which occurs when I edit some drawings–which are not very large.
Once I make these changes, I no longer see the crash issue and LibreOffice seems to run faster. It remains perfectly stable for me now.
The settings I use currently under Options - LibreOffice - Memory are:
Use for LibreOffice: 200 MB
Memory per object: 10.0 MB
These Memory settings, above correlate exactly to the following Advanced attributes in byte count values below:
Options - LibreOffice - Advanced - Expert Configuration - org.openoffice.Office.Common - Cache - Graphic Manager
TotalCacheSize 209715200 (bytes) (same as 200MB above)
ObjectCacheSize 10485760 (bytes) (same as 10.0MB above)
I do not believe these particular values are specifically optimal, only that they are significantly higher than the default values provided before making the changes. Adjust them as needed for your own needs, I wanted to show the relationship between the old “Memory” and now “Advanced” settings.
Version: 5.1.6.2
Build ID: 1:5.1.6~rc2-0ubuntu1~xenial4
CPU Threads: 8; OS Version: Linux 4.13; UI Render: default;
Locale: en-US (en_US.UTF-8); Calc: group
Use for LibreOffice: 200 MB Memory per object: 10.0 MB
they are significantly higher than the default values provided before making the changes
The default values in current versions are 190 MB and 12 MB per object, resp. If you saw different values, than it’s a sign of previous “tweaks”, that is something not recommended, and that was the real cause of your crashes. Removal of the page was partially driven by these “tweaks” that mostly break things, for no good reason (but being a cargo cult).
Thanks Mike, That looks promising. I have been using Linux Mint Cinnamon Desktop for years. The LO Memory defaults provided on that distribution are only 20MB and 5.2MB respectively. Someone up the chain needs to make an adjustment. I have not checked the very latest Linux Mint 19.1 for specifics, but earlier 17 18 and 19.0 series releases all had the very low default values.
Ehh, given that the dialog was removed from 6.0 (where the defaults are as I said), I overlooked
Version: 5.1.6.2
Of course, the 5.1 that originated in 2015 had those small defaults.
Just confirmed with my son; The very latest Linux Mint Cinnamon 19.1, recently released, is now using LO version 6.x with much higher defaults.
TotalCacheSize: 400000000
ObjectCacheSize: 12600000
ObjectReleaseTime: 600 (10 min)
This means that Linux Mint v19.1 latest version will not be experiencing frustration with LO crashing because of this problem. Probably the same for the latest Ubuntu desktop since Linux Mint is based on that. Good news for sure.