Return-Path: 
 <ooo-dev-return-6785-apmail-incubator-ooo-dev-archive=incubator.apache.org@incubator.apache.org>
X-Original-To: apmail-incubator-ooo-dev-archive@minotaur.apache.org
Delivered-To: apmail-incubator-ooo-dev-archive@minotaur.apache.org
Received: from mail.apache.org (hermes.apache.org [140.211.11.3])
	by minotaur.apache.org (Postfix) with SMTP id 82AD57E42
	for <apmail-incubator-ooo-dev-archive@minotaur.apache.org>;
 Mon, 10 Oct 2011 21:33:46 +0000 (UTC)
Received: (qmail 51182 invoked by uid 500); 10 Oct 2011 21:33:46 -0000
Delivered-To: apmail-incubator-ooo-dev-archive@incubator.apache.org
Received: (qmail 51136 invoked by uid 500); 10 Oct 2011 21:33:46 -0000
Mailing-List: contact ooo-dev-help@incubator.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:ooo-dev-help@incubator.apache.org>
List-Unsubscribe: <mailto:ooo-dev-unsubscribe@incubator.apache.org>
List-Post: <mailto:ooo-dev@incubator.apache.org>
List-Id: <ooo-dev.incubator.apache.org>
Reply-To: ooo-dev@incubator.apache.org
Delivered-To: mailing list ooo-dev@incubator.apache.org
Received: (qmail 51128 invoked by uid 99); 10 Oct 2011 21:33:46 -0000
Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 10 Oct 2011 21:33:46 +0000
X-ASF-Spam-Status: No, hits=-2.3 required=5.0
	tests=RCVD_IN_DNSWL_MED,SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (nike.apache.org: domain of gcaiod-ooo-dev@m.gmane.org
 designates 80.91.229.12 as permitted sender)
Received: from [80.91.229.12] (HELO lo.gmane.org) (80.91.229.12)
    by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 10 Oct 2011 21:33:37 +0000
Received: from list by lo.gmane.org with local (Exim 4.69)
	(envelope-from <gcaiod-ooo-dev@m.gmane.org>)
	id 1RDNTI-0008Pq-Mt
	for ooo-dev@incubator.apache.org; Mon, 10 Oct 2011 23:33:16 +0200
Received: from p57b5aa47.dip.t-dialin.net ([87.181.170.71])
        by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
        id 1AlnuQ-0007hv-00
        for <ooo-dev@incubator.apache.org>; Mon, 10 Oct 2011 23:33:16 +0200
Received: from villeroy by p57b5aa47.dip.t-dialin.net with local (Gmexim 0.1
 (Debian))
        id 1AlnuQ-0007hv-00
        for <ooo-dev@incubator.apache.org>; Mon, 10 Oct 2011 23:33:16 +0200
X-Injected-Via-Gmane: http://gmane.org/
To: ooo-dev@incubator.apache.org
From: =?UTF-8?B?QW5kcmVhcyBTw6RnZXI=?= <villeroy@t-online.de>
Subject: Re: Slooooow spreadsheet documents
Date: Mon, 10 Oct 2011 23:33:02 +0200
Lines: 25
Message-ID: <j6voae$ihc$1@dough.gmane.org>
References: 
 <CAP-ksoiUF+oS39tU14rPWfGzwATuE_02AGqW2ZfRfdr6uBQU_g@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
X-Complaints-To: usenet@dough.gmane.org
X-Gmane-NNTP-Posting-Host: p57b5aa47.dip.t-dialin.net
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
 rv:1.9.2.23) Gecko/20110921 Thunderbird/3.1.15
In-Reply-To: 
 <CAP-ksoiUF+oS39tU14rPWfGzwATuE_02AGqW2ZfRfdr6uBQU_g@mail.gmail.com>
X-Virus-Checked: Checked by ClamAV on apache.org

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