From mboxrd@z Thu Jan 1 00:00:00 1970 From: Lem Ming Subject: First row results are ignored when updating the results of a range formula in a spreadsheet Date: Sat, 1 Sep 2018 22:40:28 -0400 Message-ID: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="000000000000bb221d0574da59cf" Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:55290) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1fwIKT-0002fX-Gu for emacs-orgmode@gnu.org; Sat, 01 Sep 2018 22:41:34 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1fwIJe-0002B5-3M for emacs-orgmode@gnu.org; Sat, 01 Sep 2018 22:40:42 -0400 Received: from mail-ua1-x936.google.com ([2607:f8b0:4864:20::936]:45520) by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_128_CBC_SHA1:16) (Exim 4.71) (envelope-from ) id 1fwIJd-0002Ag-UG for emacs-orgmode@gnu.org; Sat, 01 Sep 2018 22:40:42 -0400 Received: by mail-ua1-x936.google.com with SMTP id q7-v6so10883835uam.12 for ; Sat, 01 Sep 2018 19:40:41 -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 --000000000000bb221d0574da59cf Content-Type: text/plain; charset="UTF-8" I am trying to update this: | 1 | 2 | | | | 3 | 4 | | | | 5 | 6 | | | #+TBLFM: @1$3..@3$4=$-2 to this: | 1 | 2 | 1 | 2 | | 3 | 4 | 3 | 4 | | 5 | 6 | 5 | 6 | #+TBLFM: @1$3..@3$4=$-2 doing C-c C-c on the TBLFM line. All I get is this: | 1 | 2 | | | | 3 | 4 | 3 | 4 | | 5 | 6 | 5 | 6 | #+TBLFM: @1$3..@3$4=$-2 The first row results are ignored. Here are the conditions in which I tried: - Emacs: 26.1 Config: Spacemacs Org mode: 9.1.13 - Emacs: 26.1 Config: No config Org mode: 9.1.9 In both case, it gives the same results. Is that a normal behavior? Regards. --000000000000bb221d0574da59cf Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
I am trying to update this:
| 1 | 2 | | |
| 3 | 4 | | = |
| 5 | 6 | | |
#+TBLFM: @1$3..@3$4=3D$-2

to this:
| 1 | 2 | 1 | 2 |
| 3 | 4 | 3 | = 4 |
| 5 | 6 | 5 | 6 |
#+TBLFM: @1$3..@3$4=3D$-2

<= /div>
doing C-c C-c on the TBLFM line.

All I g= et is this:
| 1 | 2 | =C2=A0 | =C2=A0 |
| 3 | 4 | 3 | 4 |=
| 5 | 6 | 5 | 6 |
#+TBLFM: @1$3..@3$4=3D$-2

The first row results are ignored.

Here= are the conditions in which I tried:
- Emacs: 26.1
Config: Spacemacs
Org mode: 9.1.13
- Emacs: 26.1
Config: No config
Org mode: 9.1.9

In both case, it gives the same results. Is that a normal behavior?

Regards.
--000000000000bb221d0574da59cf--