incubator-ooo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andreas S├Ąger <ville...@t-online.de>
Subject Re: Slooooow spreadsheet documents
Date Mon, 10 Oct 2011 21:33:02 GMT
Am 10.10.2011 22:24, Rob Weir wrote:
> Does anyone have a good example of a really slow spreadsheet document?
> Preferably ones that was slow due to computation/calculation, and one
> that is not merely slow due to size alone.
>

Database surrogate (complete madness in millions of xls files):
X1 =IF(ISNA(VLOOKUP(value;range;2;0)));"";VLOOKUP(value;range;2;0))
Y1 =IF(ISNA(VLOOKUP(value;range;3;0)));"";VLOOKUP(value;range;3;0))
Z1 =IF(ISNA(VLOOKUP(value;range;4;0)));"";VLOOKUP(value;range;4;0))
Performs 3 lookups at least. If the test for error is negative then it 
performs 6 lookups to find the exact same row.

Objects overkill:
> http://user.services.openoffice.org/en/forum/viewtopic.php?f=9&t=44259


This one does not even have any data nor formulas:
File>New>Spreadsheet
Ctrl+Space (select entire column)
Shift+<right arrow> x4 (expand 4 columns to the right)
Format>AutoFormat...
Choose "Yellow", [OK]
Get a cup of tea.
killall soffice.bin


Mime
View raw message