Re: [O] First row results are ignored when updating the results of a range formula in a spreadsheet
Hello, Lem Ming 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
Re: [O] First row results are ignored when updating the results of a range formula in a spreadsheet
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
[O] First row results are ignored when updating the results of a range formula in a spreadsheet
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.
