From mboxrd@z Thu Jan  1 00:00:00 1970
From: Daniel Clemente <n142857@gmail.com>
Subject: different color for calculated cells in tables
Date: Sat, 12 Jan 2013 01:11:03 +0100
Message-ID: <87hamnntuw.wl%n142857@gmail.com>
Mime-Version: 1.0 (generated by SEMI 1.14.6 - "Maruoka")
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([208.118.235.92]:58001)
	by lists.gnu.org with esmtp (Exim 4.71)
	(envelope-from <n142857@gmail.com>) id 1Ttogt-0003vB-Kc
	for emacs-orgmode@gnu.org; Fri, 11 Jan 2013 19:11:16 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <n142857@gmail.com>) id 1Ttogm-0001w1-Ro
	for emacs-orgmode@gnu.org; Fri, 11 Jan 2013 19:11:15 -0500
Received: from mail-we0-f174.google.com ([74.125.82.174]:43492)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <n142857@gmail.com>) id 1Ttogm-0001vn-LO
	for emacs-orgmode@gnu.org; Fri, 11 Jan 2013 19:11:08 -0500
Received: by mail-we0-f174.google.com with SMTP id x10so1121672wey.19
	for <emacs-orgmode@gnu.org>; Fri, 11 Jan 2013 16:11:07 -0800 (PST)
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: org-mode Mailinglist <emacs-orgmode@gnu.org>


Hi,=20

  I would like to easily view which table cells are calculated, that is, wh=
ich 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 t=
he automatic cells, and the normal one for =E2=80=9Emanual entry=E2=80=9C c=
ells.
  This coloring would happen on load and after each table update; no need t=
o 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%=E2=86=92 | 16.8 | 5.7266667 |    1 |        0 |
#+TBLFM: $3=3D($1/100.0)*$2;%.2f::$5=3D$3*$4::@5$2=3Dvmax(@-I$3..@I$3)::@5$=
3=3Dvmean(@-I..@I)::@5$4=3D$3>5.2::@5$5=3D0

  The =E2=80=9Eautomatic=E2=80=9C 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 h=
ighlighting from the formula editor window (C-c '); this would help.


  Any comments on the difficulty of this?


Daniel