* different color for calculated cells in tables
@ 2013-01-12 0:11 Daniel Clemente
2013-01-12 6:34 ` Bastien
0 siblings, 1 reply; 2+ messages in thread
From: Daniel Clemente @ 2013-01-12 0:11 UTC (permalink / raw)
To: org-mode Mailinglist
Hi,
I would like to easily view which table cells are calculated, that is, which values would be overwritten if I updated the table (C-u C-u C-u C-c C-c)
We can use a different cell background color (maybe with overlays?) for the automatic cells, and the normal one for „manual entry“ cells.
This coloring would happen on load and after each table update; no need to do it in real time.
A table example:
| a | b | percent | m | multiple |
|-------+------+-----------+------+----------|
| 15 | 112 | 16.80 | 2 | 33.6 |
| 2 | 15 | 0.30 | 2.1 | 0.63 |
| 1.2 | 7 | 0.08 | 12.5 | 1. |
|-------+------+-----------+------+----------|
| max%→ | 16.8 | 5.7266667 | 1 | 0 |
#+TBLFM: $3=($1/100.0)*$2;%.2f::$5=$3*$4::@5$2=vmax(@-I$3..@I$3)::@5$3=vmean(@-I..@I)::@5$4=$3>5.2::@5$5=0
The „automatic“ cells (and thus highlighted) would be: 16.80, 33.6, 0.30, 0.63, 0.08, 1, 16.8, 5.7266667, 1, 0. But I had to look at the TBLFM to find it, and that's not easy.
This is an idea, but the code's missing. A similar code exists for cell highlighting from the formula editor window (C-c '); this would help.
Any comments on the difficulty of this?
Daniel
^ permalink raw reply [flat|nested] 2+ messages in thread
* Re: different color for calculated cells in tables
2013-01-12 0:11 different color for calculated cells in tables Daniel Clemente
@ 2013-01-12 6:34 ` Bastien
0 siblings, 0 replies; 2+ messages in thread
From: Bastien @ 2013-01-12 6:34 UTC (permalink / raw)
To: Daniel Clemente; +Cc: org-mode Mailinglist
Hi Daniel,
Daniel Clemente <n142857@gmail.com> writes:
> This is an idea, but the code's missing.
I agree this would be a nice feature.
> Any comments on the difficulty of this?
I'd say "quite difficult". :)
--
Bastien
^ permalink raw reply [flat|nested] 2+ messages in thread
end of thread, other threads:[~2013-01-12 6:34 UTC | newest]
Thread overview: 2+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2013-01-12 0:11 different color for calculated cells in tables Daniel Clemente
2013-01-12 6:34 ` Bastien
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).