Ask Your Question
1

Set memory settings in Version: 6.0.4.2

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

Barney_G gravatar image

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?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
1

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

kompilainenn gravatar image

https://wiki.documentfoundation.org/R...

read comment from Mike in bug

edit flag offensive delete link more

Comments

2

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
Login/Signup to Answer

Question Tools

2 followers

Stats

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

Seen: 265 times

Last updated: Jun 12