From mboxrd@z Thu Jan  1 00:00:00 1970
From: Karl Voit <devnull@Karl-Voit.at>
Subject: Spreadsheet error: invalid reference when using @> in range
Date: Mon, 9 Nov 2015 10:13:59 +0100
Message-ID: <2015-11-09T10-03-56@devnull.Karl-Voit.at>
Reply-To: Karl Voit <news1142@Karl-Voit.at>
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:4830:134:3::10]:41214)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1ZviWr-0000vl-1Q
	for emacs-orgmode@gnu.org; Mon, 09 Nov 2015 04:14:21 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1ZviWl-000146-TT
	for emacs-orgmode@gnu.org; Mon, 09 Nov 2015 04:14:20 -0500
Received: from plane.gmane.org ([80.91.229.3]:47119)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1ZviWl-00013w-MS
	for emacs-orgmode@gnu.org; Mon, 09 Nov 2015 04:14:15 -0500
Received: from list by plane.gmane.org with local (Exim 4.69)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1ZviWj-0006Kc-N0
	for emacs-orgmode@gnu.org; Mon, 09 Nov 2015 10:14:13 +0100
Received: from friends.grml.info ([136.243.234.19])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Mon, 09 Nov 2015 10:14:13 +0100
Received: from news1142 by friends.grml.info with local (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Mon, 09 Nov 2015 10:14:13 +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: emacs-orgmode@gnu.org

Hi!

|     |             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.

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

Working: 
vsum(@I$2..@11$2)
vsum(@I$2..@IIIII$2)

So the problem seems to be the "@>" part.

Why can't I use the "@>" for "last row" in the formula?

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?

Thanks!

-- 
mail|git|SVN|photos|postings|SMS|phonecalls|RSS|CSV|XML to Org-mode:
       > get Memacs from https://github.com/novoid/Memacs <

https://github.com/novoid/extract_pdf_annotations_to_orgmode + more on github