From mboxrd@z Thu Jan 1 00:00:00 1970 From: Nicolas Goaziou Subject: Re: Spreadsheet error: invalid reference when using @> in range Date: Wed, 11 Nov 2015 20:47:29 +0100 Message-ID: <87fv0c8gj2.fsf@nicolasgoaziou.fr> References: <2015-11-09T10-03-56@devnull.Karl-Voit.at> <87wptp8lq6.fsf@nicolasgoaziou.fr> <2015-11-11T10-46-18@devnull.Karl-Voit.at> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:43316) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1ZwbL8-0007pG-Hb for emacs-orgmode@gnu.org; Wed, 11 Nov 2015 14:45:57 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1ZwbL2-00075T-5f for emacs-orgmode@gnu.org; Wed, 11 Nov 2015 14:45:54 -0500 Received: from relay4-d.mail.gandi.net ([2001:4b98:c:538::196]:52024) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1ZwbL1-00073f-VH for emacs-orgmode@gnu.org; Wed, 11 Nov 2015 14:45:48 -0500 In-Reply-To: <2015-11-11T10-46-18@devnull.Karl-Voit.at> (Karl Voit's message of "Wed, 11 Nov 2015 10:47:52 +0100") List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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 Cc: Karl Voit , emacs-orgmode@gnu.org Karl Voit writes: > However, this does not work at my side: > > | | 20 | 21 | 22 | 23 | 24 | > | Foo + 2 Bar + Foo + Bar + Foo | 3 | | | | | > |-------------------------------+----+----+----+----+----| > | | | | | | | > |-------------------------------+----+----+----+----+----| > | | 1 | 1 | | | 1 | > | Foo | 2 | | | | | > | Bar | | | 2 | 3 | | > |-------------------------------+----+----+----+----+----| > | | | | | | | > |-------------------------------+----+----+----+----+----| > | Bar | | 4 | 1 | | | > | Foo | | | 2 | | 2 | > | Bar | | | 3 | 5 | | > | Foo | | 1 | | | 5 | > |-------------------------------+----+----+----+----+----| > #+TBLFM: @2$2..@2$>=vsum(@3..@>) > > At least, the error is gone. What might be the cause of the wrong > result? You need to update Org. Regards,