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 <[email protected]> wrote: > 2013/3/19 david_lynch <[email protected]>: > > 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: > [email protected] > > 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 > > > -- For unsubscribe instructions e-mail to: [email protected] 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
