Re: [libreoffice-users] Conditional formatting and speed of calc
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 jrodrigue...@cpcecr.com 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 +, 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 1 cells, then Calc needs to work through 1 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
Re: [libreoffice-users] Conditional formatting and speed of calc
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 1 cells, then Calc needs to work through 1 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 -- 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
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 +, 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 1 cells, then Calc needs to work through 1 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
[libreoffice-users] Conditional formatting and speed of calc
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? 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
[libreoffice-users] Conditional formatting and speed of calc
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? 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