From mboxrd@z Thu Jan 1 00:00:00 1970 From: Eric S Fraga Subject: Re: First row results are ignored when updating the results of a range formula in a spreadsheet Date: Mon, 03 Sep 2018 14:44:15 +0100 Message-ID: <87in3m7l1s.fsf@gmail.com> References: Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:52206) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1fwp9W-0007dl-Tb for emacs-orgmode@gnu.org; Mon, 03 Sep 2018 09:44:27 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1fwp9T-0000fn-PK for emacs-orgmode@gnu.org; Mon, 03 Sep 2018 09:44:26 -0400 Received: from mail-wr1-x430.google.com ([2a00:1450:4864:20::430]:35357) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1fwp9T-0000fW-I7 for emacs-orgmode@gnu.org; Mon, 03 Sep 2018 09:44:23 -0400 Received: by mail-wr1-x430.google.com with SMTP id j26-v6so750615wre.2 for ; Mon, 03 Sep 2018 06:44:23 -0700 (PDT) In-Reply-To: (Lem Ming's message of "Sat, 1 Sep 2018 22:40:28 -0400") 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" To: Lem Ming Cc: emacs-orgmode@gnu.org On Saturday, 1 Sep 2018 at 22:40, Lem Ming wrote: > I am trying to update this: > | 1 | 2 | | | > | 3 | 4 | | | > | 5 | 6 | | | > #+TBLFM: @1$3..@3$4=$-2 [...] > The first row results are ignored. I get the same (wrong) behaviour with my current org setup. Asking to debug the table update (C-c {) shows that the first entry considered is on the second row. Adding a line (|-) before the first row doesn't help either. I also tried #+TBLFM: @<$3..@>$4=$-2 and this made no difference either. -- Eric S Fraga via Emacs 27.0.50, Org release_9.1.13-783-g97fac4