From mboxrd@z Thu Jan 1 00:00:00 1970 From: alan.wehmann@gmail.com Subject: spreadsheet formulae and removal of hline Date: Sun, 17 Sep 2017 10:43:36 -0500 Message-ID: <22974.38952.795938.560963@gargle.gargle.HOWL> Reply-To: Alan.Wehmann@gmail.com Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:37090) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1dtbjZ-0001DD-CJ for emacs-orgmode@gnu.org; Sun, 17 Sep 2017 11:43:50 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1dtbjW-0004u8-Ap for emacs-orgmode@gnu.org; Sun, 17 Sep 2017 11:43:49 -0400 Received: from mail-it0-x233.google.com ([2607:f8b0:4001:c0b::233]:52573) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1dtbjW-0004td-5b for emacs-orgmode@gnu.org; Sun, 17 Sep 2017 11:43:46 -0400 Received: by mail-it0-x233.google.com with SMTP id c195so7150245itb.1 for ; Sun, 17 Sep 2017 08:43:44 -0700 (PDT) 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: emacs-orgmode@gnu.org 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. My version is: Org mode version 9.1 (9.1-20-ga4f139-elpaplus @ /Users/alanwehmann/.emacs.d/elpa/org-plus-contrib-20170911/) -- Alan Wehmann Alan.Wehmann@gmail.com