Re: [libreoffice-users] Re: question

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 <luuk34@gmail.com> 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: users+unsubscribe@global.libreoffice.org
> 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: users+unsubscribe@global.libreoffice.org
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