From mboxrd@z Thu Jan 1 00:00:00 1970 From: Nicolas Goaziou Subject: Re: spreadsheet formulae and removal of hline Date: Thu, 28 Sep 2017 22:15:52 +0200 Message-ID: <87shf6mvev.fsf@nicolasgoaziou.fr> References: <22974.38952.795938.560963@gargle.gargle.HOWL> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:48451) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1dxfDv-0005Kl-QG for emacs-orgmode@gnu.org; Thu, 28 Sep 2017 16:15:56 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1dxfDu-000615-WD for emacs-orgmode@gnu.org; Thu, 28 Sep 2017 16:15:55 -0400 Received: from relay4-d.mail.gandi.net ([2001:4b98:c:538::196]:34461) by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1dxfDu-0005zQ-PT for emacs-orgmode@gnu.org; Thu, 28 Sep 2017 16:15:54 -0400 In-Reply-To: <22974.38952.795938.560963@gargle.gargle.HOWL> (alan wehmann's message of "Sun, 17 Sep 2017 10:43:36 -0500") 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: alan.wehmann@gmail.com Cc: emacs-orgmode@gnu.org Hello, alan.wehmann@gmail.com writes: > I have noticed that if I remove a hline in a org table used as a > spreadsheet, the formulae for rows below where the hline was, change > in a manner that makes them refer to the wrong row. > > Since hlines are not counted as rows in the spreadsheet, removal of a > hline should not change the formulae in the '#+TBLFM' line. > > I am using 'org-table-kill-row to remove the hline. Its doc string > says that it can be used to remove a hline. Fixed. Thank you. Regards, -- Nicolas Goaziou