all messages for Emacs-related lists mirrored at yhetil.org
 help / color / mirror / code / Atom feed
* 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.