* First row results are ignored when updating the results of a range formula in a spreadsheet @ 2018-09-02 2:40 Lem Ming 2018-09-03 13:44 ` Eric S Fraga 2018-09-05 16:52 ` Nicolas Goaziou 0 siblings, 2 replies; 3+ messages in thread From: Lem Ming @ 2018-09-02 2:40 UTC (permalink / raw) To: emacs-orgmode [-- 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 --] ^ permalink raw reply [flat|nested] 3+ messages in thread
* Re: First row results are ignored when updating the results of a range formula in a spreadsheet 2018-09-02 2:40 First row results are ignored when updating the results of a range formula in a spreadsheet Lem Ming @ 2018-09-03 13:44 ` Eric S Fraga 2018-09-05 16:52 ` Nicolas Goaziou 1 sibling, 0 replies; 3+ messages in thread From: Eric S Fraga @ 2018-09-03 13:44 UTC (permalink / raw) To: Lem Ming; +Cc: emacs-orgmode 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 ^ permalink raw reply [flat|nested] 3+ messages in thread
* Re: First row results are ignored when updating the results of a range formula in a spreadsheet 2018-09-02 2:40 First row results are ignored when updating the results of a range formula in a spreadsheet Lem Ming 2018-09-03 13:44 ` Eric S Fraga @ 2018-09-05 16:52 ` Nicolas Goaziou 1 sibling, 0 replies; 3+ messages in thread From: Nicolas Goaziou @ 2018-09-05 16:52 UTC (permalink / raw) To: Lem Ming; +Cc: emacs-orgmode 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 ^ permalink raw reply [flat|nested] 3+ messages in thread
end of thread, other threads:[~2018-09-05 16:52 UTC | newest] Thread overview: 3+ messages (download: mbox.gz follow: Atom feed -- links below jump to the message on this page -- 2018-09-02 2:40 First row results are ignored when updating the results of a range formula in a spreadsheet Lem Ming 2018-09-03 13:44 ` Eric S Fraga 2018-09-05 16:52 ` Nicolas Goaziou
Code repositories for project(s) associated with this external index https://git.savannah.gnu.org/cgit/emacs.git https://git.savannah.gnu.org/cgit/emacs/org-mode.git This is an external index of several public inboxes, see mirroring instructions on how to clone and mirror all data and code used by this external index.