From mboxrd@z Thu Jan 1 00:00:00 1970 From: Andras Major Subject: Re: making coloured tables Date: Mon, 1 Aug 2011 06:53:43 +0200 Message-ID: References: <80zkjzlb50.fsf@somewhere.org> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Return-path: Received: from eggs.gnu.org ([140.186.70.92]:37733) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1QnkVe-0004YY-6m for emacs-orgmode@gnu.org; Mon, 01 Aug 2011 00:53:47 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1QnkVd-0006LG-0u for emacs-orgmode@gnu.org; Mon, 01 Aug 2011 00:53:46 -0400 Received: from mail-qw0-f41.google.com ([209.85.216.41]:45758) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1QnkVc-0006LC-Sd for emacs-orgmode@gnu.org; Mon, 01 Aug 2011 00:53:44 -0400 Received: by qwa26 with SMTP id 26so3519536qwa.0 for ; Sun, 31 Jul 2011 21:53:43 -0700 (PDT) In-Reply-To: <80zkjzlb50.fsf@somewhere.org> List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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: emacs-orgmode@gnu.org, Sebastien Vauban Hi Sebastian, > Andras Major wrote: >> I'm really intrigued by org-mode's table and spreadsheet functionality >> and would like to use it for those cases where I found excel and >> gnumeric impractically cumbersome. >> >> What I want are two slightly diffent things: >> >> - Make tables that have cells with individual background colours when >> exported as HTML or PDF. >> >> - Make tables that have cells with background colours and typeface >> details (bold, italic, etc.) based on contents of either the cells >> themselves or other cells in the table. (Example: mark all negative >> numerical values of a table with a red background.) >> >> Furthermore, the colouring should be portable, i.e. independent of the >> settings in .emacs. > > I add wishes on the above list. Maybe someone will be able to implement > them, > if they seem to make sense... So, here's my idea: having some automagic > style > (background) applied on the cells to distinguish: > > - the input cells (the ones you cannot delete... without troubles): they > don't > have any formula associated with them > > - the final result cells: the ones with computed results > > - the other ones, whose content is computed, but serves as input to other > cells. > > Would these be in different colors, I think it would make the reading of > tables much more efficient. And, as far as I know, this does not exist ye= t > in > tools like Excel -- though people can manually apply such color conventio= ns. I was thinking along slightly different lines. We have a customizable tag in HTML export already, but that customization isn't very flexible. If we could have something like a tag that can be set from values in the table, or by Lisp code, then I think that would solve my problems. It's important, however, that setting the export tag must be local to the Org file so I can set it there instead of the global .emacs. Andr=E1s