First row results are ignored when updating the results of a range formula in a spreadsheet

First row results are ignored when updating the results of a range formula in a spreadsheet

[Lem Ming]

[-- Attachment #1: Type: text/plain, Size: 569 bytes --]

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.

[-- Attachment #2: Type: text/html, Size: 1014 bytes --]

Re: First row results are ignored when updating the results of a range formula in a spreadsheet

[Eric S Fraga]

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

Re: First row results are ignored when updating the results of a range formula in a spreadsheet

[Nicolas Goaziou]

Hello,

Lem Ming <ramboman777@gmail.com> writes:

> 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.

Fixed. Thank you.

Regards,

-- 
Nicolas Goaziou