incubator-ooo-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rob Weir <>
Subject Re: Slooooow spreadsheet documents
Date Mon, 10 Oct 2011 23:23:05 GMT
On Mon, Oct 10, 2011 at 5:33 PM, Andreas S├Ąger <> wrote:
> 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.

So we don't cache the partial evaluations internally?

> Objects overkill:
> 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

Extremely large sheets are a problem.  Remember this file?

The issue is users are so comfortable with spreadsheets that they use
them for problems that are better handled in a database.  We're cursed
by the success of the spreadsheet interface.

I did some optimizations of that particular case a while back,
focusing on optimizing the markup we write out.  I'll see if I can
find it.

But thanks for the examples.  Very useful.


View raw message