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.knu...@gmail.com> wrote: > > > 2013/3/19 david_lynch <david_ly...@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+h...@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+h...@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