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
