From mboxrd@z Thu Jan 1 00:00:00 1970 From: Rainer M Krug Subject: Re: making coloured tables Date: Mon, 1 Aug 2011 09:38:50 +0200 Message-ID: References: <80zkjzlb50.fsf@somewhere.org> <80vcuhljv1.fsf@somewhere.org> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=00235452ffecebb6f004a96cb8f8 Return-path: Received: from eggs.gnu.org ([140.186.70.92]:40083) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Qnn5R-00080R-NO for emacs-orgmode@gnu.org; Mon, 01 Aug 2011 03:38:59 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1Qnn5Q-0001rc-At for emacs-orgmode@gnu.org; Mon, 01 Aug 2011 03:38:53 -0400 Received: from mail-qy0-f169.google.com ([209.85.216.169]:63498) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Qnn5Q-0001rT-4t for emacs-orgmode@gnu.org; Mon, 01 Aug 2011 03:38:52 -0400 Received: by qyk32 with SMTP id 32so991380qyk.0 for ; Mon, 01 Aug 2011 00:38:51 -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: Sebastien Vauban Cc: emacs-orgmode@gnu.org --00235452ffecebb6f004a96cb8f8 Content-Type: text/plain; charset=ISO-8859-1 On Mon, Aug 1, 2011 at 8:35 AM, 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 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 > 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 > the > > 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 > original > post. Just speaking of editing feature in the Org buffer, for giving more > insight on formulas in tables. > I think that would be very useful feature to be included - I trashed a few times already (fairly simple) tables because of modifying formula cells.... Cheers, Rainer > These "color features" weren't intended IMHO for export. So the 2 > "problems" > are in fact apart from each other. > > > 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. > > Best regards, > Seb > > -- > Sebastien Vauban > > > -- Rainer M. Krug, PhD (Conservation Ecology, SUN), MSc (Conservation Biology, UCT), Dipl. Phys. (Germany) Centre of Excellence for Invasion Biology Stellenbosch University South Africa Tel : +33 - (0)9 53 10 27 44 Cell: +33 - (0)6 85 62 59 98 Fax (F): +33 - (0)9 58 10 27 44 Fax (D): +49 - (0)3 21 21 25 22 44 email: Rainer@krugs.de Skype: RMkrug --00235452ffecebb6f004a96cb8f8 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable

On Mon, Aug 1, 2011 at 8:35 AM, Sebastie= n Vauban <wxhgmqzgwmuf@spammotel.com> wrote:
Hi Andras,

Andras Major wrote:
>> Andras Major wrote:
>>> I'm really intrigued by org-mode's table and spreadshe= et functionality and
>>> would like to use it for those cases where I found excel and g= numeric
>>> impractically cumbersome.
>>>
>>> What I want are two slightly diffent things:
>>>
>>> - Make tables that have cells with individual background colou= rs when
>>> =A0 exported as HTML or PDF.
>>>
>>> - Make tables that have cells with background colours and type= face details
>>> =A0 (bold, italic, etc.) based on contents of either the cells= themselves or
>>> =A0 other cells in the table. (Example: mark all negative nume= rical values
>>> =A0 of a table with a red background.)
>>>
>>> Furthermore, the colouring should be portable, i.e. independen= t of the
>>> settings in .emacs.
>>
>> I add wishes on the above list. Maybe someone will be able to impl= ement
>> them, if they seem to make sense... So, here's my idea: having= some
>> automagic style (background) applied on the cells to distinguish:<= br> >>
>> - the input cells (the ones you cannot delete... without troubles)= : they
>> =A0 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 t= o other
>> =A0 cells.
>>
>> Would these be in different colors, I think it would make the read= ing of
>> tables much more efficient. And, as far as I know, this does not e= xist yet
>> in tools like Excel -- though people can manually apply such color=
>> conventions.
>
> I was thinking along slightly different lines. We have a customizable = <td>
> tag in HTML export already, but that customization isn't very flex= ible. If
> we could have something like a <td> tag that can be set from val= ues in the
> table, or by Lisp code, then I think that would solve my problems.

My above feature of the wishlist isn't for export -- I misr= ead your original
post. Just speaking of editing feature in the Org buffer, for giving more insight on formulas in tables.

I think = that would be very useful feature to be included - I trashed a few times al= ready (fairly simple) tables because of modifying formula cells....

Cheers,

Rainer

<= /div>



These "color features" weren't intended IMHO for export. So t= he 2 "problems"
are in fact apart from each other.

> 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.

Best regards,
=A0Seb

--
Sebastien Vauban





--
Rainer M. K= rug, PhD (Conservation Ecology, SUN), MSc (Conservation Biology, UCT), Dipl= . Phys. (Germany)

Centre of Excellence for Invasion Biology
Stell= enbosch University
South Africa

Tel : =A0 =A0 =A0 +33 - (0)9 53 10 27 44
Cell: =A0 = =A0 =A0 +33 - (0)6 85 62 59 98
Fax (F): =A0 =A0 =A0 +33 - (0)9 58 10 27 = 44

Fax (D): =A0 =A0+49 - (0)3 21 21 25 22 44

email: =A0 =A0 = =A0Rainer@krugs.de=

Skype: =A0 =A0 =A0RMkrug

--00235452ffecebb6f004a96cb8f8--