From mboxrd@z Thu Jan  1 00:00:00 1970
From: Nicolas Goaziou <mail@nicolasgoaziou.fr>
Subject: Re: Spreadsheet error: invalid reference when using @> in range
Date: Wed, 11 Nov 2015 00:42:57 +0100
Message-ID: <87wptp8lq6.fsf@nicolasgoaziou.fr>
References: <2015-11-09T10-03-56@devnull.Karl-Voit.at>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:52557)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <mail@nicolasgoaziou.fr>) id 1ZwIXL-0000tk-72
	for emacs-orgmode@gnu.org; Tue, 10 Nov 2015 18:41:16 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <mail@nicolasgoaziou.fr>) id 1ZwIXK-0000Vr-8S
	for emacs-orgmode@gnu.org; Tue, 10 Nov 2015 18:41:15 -0500
Received: from relay4-d.mail.gandi.net ([2001:4b98:c:538::196]:47290)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <mail@nicolasgoaziou.fr>) id 1ZwIXK-0000Vg-1w
	for emacs-orgmode@gnu.org; Tue, 10 Nov 2015 18:41:14 -0500
In-Reply-To: <2015-11-09T10-03-56@devnull.Karl-Voit.at> (Karl Voit's message
	of "Mon, 9 Nov 2015 10:13:59 +0100")
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: <http://lists.gnu.org/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: Karl Voit <devnull@Karl-Voit.at>
Cc: Karl Voit <news1142@Karl-Voit.at>, emacs-orgmode@gnu.org

Hello,

Karl Voit <devnull@Karl-Voit.at> writes:

> |     |             20 | 21 | 22 | 23 | 24 |
> |     | :=vsum(@3..@>) |    |    |    |    |
> |-----+----------------+----+----+----+----|
> |     |                |    |    |    |    |
> |-----+----------------+----+----+----+----|
> |     |              1 |  1 |    |    |  1 |
> | Foo |              2 |    |    |    |    |
> | Bar |                |    |  2 |  3 |    |
> |-----+----------------+----+----+----+----|
> |     |                |    |    |    |    |
> |-----+----------------+----+----+----+----|
> | Bar |                |  4 |  1 |    |    |
> | Foo |                |    |  2 |    |  2 |
> | Bar |                |    |  3 |  5 |    |
> | Foo |                |  1 |    |    |  5 |
> |-----+----------------+----+----+----+----|
>
> I got: Spreadsheet error: invalid reference "vsum(@3..@>)" when I
> try to apply the formula.

I cannot reproduce the problem.
>
> Also tried and also failed with same message:
> vsum(@3$2..@>$2)
> vsum(@I$2..@>$2)
> vsum(@I+1$2..@>$2)

Same here.

> Bonus question: when I want to apply the formula to @2$2 and *all*
> table elements rights of it until the last column, is there a way to
> define this without having five separate formula?

  @2$2..@2$>=vsum(@3..@>)


Regards,

-- 
Nicolas Goaziou