Re: [libreoffice-users] Conditional formatting and speed of calc

Hi all

I`m not sure but increasing memory in LO:

Menu, Tools, Options, Memory

or uncheck in spanish:

Menu, Herramientas, Contenido de Celdas, Cálculo Automatico y luego usar
F9 para recalcular todo.

Regards,

Jorge Rodríguez



El jue, 21-03-2013 a las 19:00 +0000, david_lynch escribió:
> Johnny,
>
> Thanks for your reply. Further details:
>
> 17 sheets
> about 105000 active cells
> largest sheet 256 by 112
> conditional formatting is on 60 cells and each test is a VLOOKUP on 30
> cells.
>
> David Lynch
>
> On 20 March 2013 16:30, Johnny Rosenberg <gurus.knugum@gmail.com> wrote:
>
> > 2013/3/19 david_lynch <david_lynch@blueyonder.co.uk>:
> > > I have a large and complex spreadsheet: 17 sheets and 1.4Mb. Normally, it
> > > runs acceptably fast (although not at lightning speed).
> > >
> > > I added conditional formatting to about 80 cells: it then takes about a
> > > minute to respond to any input, whether in the cells with conditional
> > > formatting or not. Am I doing anything wrong? Is there a way to get
> > > conditional formatting without this speed degradation?
> >
> > Depends on what you are doing now. Exactly what do your conditions look
> > like?
> >
> > For instance, if you test 80 cell values against all the values in a
> > giant cell range, let's say 10000 cells, then Calc needs to work
> > through 10000 cells 80 times.
> >
> > If you, for instance, test a cell value against highest value in a
> > very big cell range, then it's better to calculate the max value in a
> > cell, then comapre each of the 80 cells to that cell. Then the max
> > calculation only needs to be done once.
> >
> > But I don't know what you did, so this is only a wild guess.
> >
> >
> >
> > Johnny Rosenberg
> >
> > > I'm running 3.6.3.2 on Vista SP2.
> > >
> > > David Lynch
> > >
> > > --
> > > For unsubscribe instructions e-mail to:
> > users+help@global.libreoffice.org
> > > Problems?
> > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> > > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> > > List archive: http://listarchives.libreoffice.org/global/users/
> > > All messages sent to this list will be publicly archived and cannot be
> > deleted
> > >

-- 
Atentamente,

Jorge Rodríguez


-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted