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
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
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ó:
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
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.