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
