From mboxrd@z Thu Jan 1 00:00:00 1970 From: Andras Major Subject: Re: making coloured tables Date: Mon, 1 Aug 2011 09:30:30 +0200 Message-ID: References: <80zkjzlb50.fsf@somewhere.org> <80vcuhljv1.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]:49668) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1QnmxN-0005vj-In for emacs-orgmode@gnu.org; Mon, 01 Aug 2011 03:30:34 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1QnmxM-0008Aw-69 for emacs-orgmode@gnu.org; Mon, 01 Aug 2011 03:30:33 -0400 Received: from mail-qw0-f41.google.com ([209.85.216.41]:61075) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1QnmxM-0008An-1E for emacs-orgmode@gnu.org; Mon, 01 Aug 2011 03:30:32 -0400 Received: by qwa26 with SMTP id 26so3571257qwa.0 for ; Mon, 01 Aug 2011 00:30:31 -0700 (PDT) In-Reply-To: <80vcuhljv1.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 , Sebastien Vauban I have an idea how my feature could be implemented, and it consists of two parts. - introduce a special row, or extend the "/" type used for colgroup and narrowing, to specify hidden (non-export) columns and special tag columns; - in that special row, there are two new special entries, say "T<" and "T>" which specify that the contents of each cell in that column should be exported into the tag of the cell to the left or to the right. This way, the tag can be set from within the table for each relevant cell. The only drawback is that all this is backend-specific, it only works for HTML, not for PDF in the way I've just described. Andr=E1s On 8/1/11, Sebastien Vauban wrote: > Hi Andras, > > Andras Major wrote: >>> 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 themselve= s >>>> or >>>> other cells in the table. (Example: mark all negative numerical valu= es >>>> 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): the= y >>> 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 oth= er >>> cells. >>> >>> Would these be in different colors, I think it would make the reading o= f >>> tables much more efficient. And, as far as I know, this does not exist >>> yet >>> in tools like Excel -- though people can manually apply such color >>> conventions. >> >> 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 t= he >> table, or by Lisp code, then I think that would solve my problems. > > My above feature of the wishlist isn't for export -- I misread your origi= nal > post. Just speaking of editing feature in the Org buffer, for giving more > insight on formulas in tables. > > These "color features" weren't intended IMHO for export. So the 2 "proble= ms" > are in fact apart from each other. > >> It's important, however, that setting the export tag must be local to th= e >> Org file so I can set it there instead of the global .emacs. > > Best regards, > Seb > > -- > Sebastien Vauban > > >