Date: prev next · Thread: first prev next last
2013 Archives by date, by thread · List index


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.knugum@gmail.com> wrote:

2013/3/19 david_lynch <david_lynch@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+help@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+help@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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.