Ask Your Question

Set memory settings in Version:

asked 2018-06-12 19:09:09 +0200

Barney_G gravatar image

I'm using Version: 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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2018-06-12 19:21:28 +0200

kompilainenn gravatar image

read comment from Mike in bug

edit flag offensive delete link more



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.

Mike Kaganski gravatar imageMike Kaganski ( 2018-06-13 04:18:16 +0200 )edit

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.

GeorgeCurtis gravatar imageGeorgeCurtis ( 2018-07-13 23:14:52 +0200 )edit

Hi Mike: Can you let me to know what value is better in TotalCacheSize, ObjectCacheSize, ObjectReleaseTime, GraphicMemoryLimit? thanks

joey.liao gravatar imagejoey.liao ( 2018-10-02 10:35:47 +0200 )edit

@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.

Mike Kaganski gravatar imageMike Kaganski ( 2018-10-02 10:51:02 +0200 )edit
Login/Signup to Answer

Question Tools



Asked: 2018-06-12 19:09:09 +0200

Seen: 1,142 times

Last updated: Jun 12