Many thanks, Jorge and Johnny, increasing memory improved the speed greatly (and displayed some unusual fonts properly).
David Lynch On 22 March 2013 03:16, jorge <[email protected]> wrote: > 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 <[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 > > > > > > > > > > > -- > Atentamente, > > Jorge Rodríguez > > -- 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
