From mboxrd@z Thu Jan  1 00:00:00 1970
From: Juan Pechiar <juan@pechiar.com>
Subject: Re: Crashing bug in spreadsheet
Date: Fri, 22 Jul 2011 18:35:13 -0300
Message-ID: <20110722213513.GD2823@soloJazz.com>
References: <CA4F3033.39721%ken.williams@thomsonreuters.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([140.186.70.92]:54389)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <juan@pechiar.com>) id 1QkNNR-0001cC-7f
	for emacs-orgmode@gnu.org; Fri, 22 Jul 2011 17:35:22 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <juan@pechiar.com>) id 1QkNNP-0000CK-BB
	for emacs-orgmode@gnu.org; Fri, 22 Jul 2011 17:35:21 -0400
Received: from oproxy1-pub.bluehost.com ([66.147.249.253]:53640)
	by eggs.gnu.org with smtp (Exim 4.71)
	(envelope-from <juan@pechiar.com>) id 1QkNNP-0000Bu-30
	for emacs-orgmode@gnu.org; Fri, 22 Jul 2011 17:35:19 -0400
Content-Disposition: inline
In-Reply-To: <CA4F3033.39721%ken.williams@thomsonreuters.com>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: </archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: Ken.Williams@thomsonreuters.com
Cc: emacs-orgmode@gnu.org

Hi,

'@II..@III' means all rows between the second and third h-lines. In
your case, this is the same vsum(), so you get a circular reference.

Try @I..@II instead

Regards,
.j.

On Fri, Jul 22, 2011 at 06:48:36PM +0000, Ken.Williams@thomsonreuters.com wrote:
> Hi,  I had the following text in a table, and hit <tab> in the
> bottom-right cell:
>
> | Who |     Amt     |
> |-----+---------|
> | A   |   36.70 |
> | A   |  679.96 |
> | B   |  192.31 |
> | B   | 2500.03 |
> | B   |   74.47 |
> | C   |   26.64 |
> | D   |   82.00 |
> |-----+---------|
> |     | :=vsum(@II..@III)       |
>
> This caused CPU usage to peg to 100%, and Emacs to hang until killed.
> Probably because of the invalid reference, I guess.