From mboxrd@z Thu Jan 1 00:00:00 1970 From: Karl Voit Subject: Re: Spreadsheet error: invalid reference when using @> in range Date: Wed, 11 Nov 2015 10:47:52 +0100 Message-ID: <2015-11-11T10-46-18@devnull.Karl-Voit.at> References: <2015-11-09T10-03-56@devnull.Karl-Voit.at> <87wptp8lq6.fsf@nicolasgoaziou.fr> Reply-To: Karl Voit Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:34712) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1ZwS2Z-0006ig-AO for emacs-orgmode@gnu.org; Wed, 11 Nov 2015 04:50:33 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1ZwS1l-0008LK-TQ for emacs-orgmode@gnu.org; Wed, 11 Nov 2015 04:50:07 -0500 Received: from plane.gmane.org ([80.91.229.3]:56419) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1ZwS1l-0008LE-Mt for emacs-orgmode@gnu.org; Wed, 11 Nov 2015 04:49:17 -0500 Received: from list by plane.gmane.org with local (Exim 4.69) (envelope-from ) id 1ZwS18-0005nk-QW for emacs-orgmode@gnu.org; Wed, 11 Nov 2015 10:48:38 +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 ; Wed, 11 Nov 2015 10:48:38 +0100 Received: from news1142 by friends.grml.info with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 11 Nov 2015 10:48:38 +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: emacs-orgmode@gnu.org * Nicolas Goaziou wrote: > Hello, Hello Nicolas (again)! > Karl Voit 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. Funny thing: today, it worked so far :-O >> 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..@>) 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? Thank you for your time! -- 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