emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed

From: Ruy Exel <ruyexel@gmail.com>
To: Nicolas Goaziou <mail@nicolasgoaziou.fr>
Cc: emacs-orgmode@gnu.org
Subject: Re: Table refuses to forget cell formula which once overrode a column formula
Date: Wed, 15 Nov 2017 17:17:34 -0200	[thread overview]
Message-ID: <CAB8Wf+8QA4qM-cp3MRsFUoXtT=9uXBy4L88EsrOOjkKFiLJy+A@mail.gmail.com> (raw)
In-Reply-To: <CAB8Wf+-VxdCKMfqZjRfYvMdQPwwzgs=FtWESpYuhokK3sZe8sw@mail.gmail.com>

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

Hi Nicolas,

Thanks very much.  Just out of curiosity I'd be interested in understanding
how did you do it.  My (non expert) impression is that using properties to
override column formulas isn't a good idea.  It seems to me it would be
more natural to apply cell formulas AFTER all column formulas were applied,
so that each cell would be simply the output of the formula defining it.

Best,
Ruy

On Nov 15, 2017 14:42, "Nicolas Goaziou" <mail@nicolasgoaziou.fr> wrote:

Hello,

Ruy Exel <ruyexel@gmail.com> writes:

> The following is very simple org-mode spreadsheet in which the cells in
the
> second column show the triple of the corresponding cell in the first
column
> due to the "column formula" in its TBLFM row $2=3*$1;N. However the third
> row (actually row @4) is an exception because of the "cell formula"
> @4$2=string("Exception") which expectedly overrides the above column
> formula.
>
> |--------+-----------|
> | Number |    Triple |
> |--------+-----------|
> |      1 |         3 |
> |      2 |         6 |
> |      3 | Exception |
> |      4 |        12 |
> |--------+-----------|
>
> #+TBLFM: $2=3*$1::@4$2=string("Exception")
>
> So all is well. Below you will find a copy of the above table, except
that,
> after copying, I have deleted the exceptional formula affecting cell @4$2.
>
> |--------+-----------|
> | Number |    Triple |
> |--------+-----------|
> |      1 |         3 |
> |      2 |         6 |
> |      3 | Exception |
> |      4 |        12 |
> |--------+-----------|
>
> #+TBLFM: $2=3*$1
>
> One would expect that, after updating this table with C-u C-c *, or C-c
C-c
> in the TBLFM line, the exceptional value in cell @4$2 would revert to the
> triple of '3', but instead the string "Exception" stays put.

Fixed. Thank you.

Regards,

--
Nicolas Goaziou

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

next prev parent reply	other threads:[~2017-11-15 19:17 UTC|newest]

Thread overview: 6+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2017-11-14 11:27 Table refuses to forget cell formula which once overrode a column formula Ruy Exel
2017-11-15 16:42 ` Nicolas Goaziou
     [not found]   ` <CAB8Wf+-VxdCKMfqZjRfYvMdQPwwzgs=FtWESpYuhokK3sZe8sw@mail.gmail.com>
2017-11-15 19:17     ` Ruy Exel [this message]
2017-11-15 21:07       ` Nick Dokos
2017-11-15 21:54       ` Nicolas Goaziou
2017-11-15 23:30         ` Ruy Exel

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to='CAB8Wf+8QA4qM-cp3MRsFUoXtT=9uXBy4L88EsrOOjkKFiLJy+A@mail.gmail.com' \
    --to=ruyexel@gmail.com \
    --cc=emacs-orgmode@gnu.org \
    --cc=mail@nicolasgoaziou.fr \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link

Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).