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 18.04.) I do this for all complex sheets now, just so scrolling and editing goes smoother. On Tue, Jul 28, 2020 at 4:33 AM Luuk <[email protected]> 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 > activity, > >> and the disk goes to spinning,, the background of the spreadsheet goes > into > >> grey mode, and it sometimes takes two or three minutes before the full > >> control reappears and the background returns back from greyed out to > white > >> again. > >> > >> > >> is this this has been going on since last November.. but it has reached > >> epidemic proportions .. and has rendered Libre office useless on my > machine > >> > > > 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: https://wiki.ubuntu.com/Releases) > > > > -- > To unsubscribe e-mail to: [email protected] > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/users/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/users/ Privacy Policy: https://www.documentfoundation.org/privacy
