Date: prev next · Thread: first prev next last
2020 Archives by date, by thread · List index

I dealt with this on a calc workbook that has many (2-10 million) functions
that span from one tab to another.

On the Data Menu -> Calculate -> Autocalculate and ensure the checkmark
next to autocalculate is off.

After that performance should return to normal, but remember you have to
press the system defined key to recalc. (F9 or Ctrl+Shift+F9 in ubuntu

I do this for all complex sheets now, just so scrolling and editing goes

On Tue, Jul 28, 2020 at 4:33 AM Luuk <> wrote:

On 27-7-2020 20:27, fudmier wrote:

On 2020-07-27 11:39 a.m., fudmier wrote:

On my linux 16.04 box .. each time i perform any function that involves
switching between tabs, or between certain activities within the same A
tab my computer goes into Oh shit mode.. it disables my keyboard
and the disk goes to spinning,, the background of the spreadsheet goes
grey mode, and it sometimes takes two or three minutes before the full
control reappears and the background returns back from greyed out to

is this this has been going on since last November.. but it has reached
epidemic proportions .. and has rendered Libre office useless on my

hard to tell without knowing some things like:

1) what is the size of this worksheet?

2) how much internal memory do you have on your machine?

3) what version of LibreOffice?

With 'linux 16.04' you probably mean Ubuntu 16.04 ? This means you should
upgrade before April 2021 (see:

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.