Re: Re: Some table questions

[Andreas Burtzlaff <andy13@gmx.net>]

On Fri, 04 Sep 2009 12:46:02 +0200
andrea crotti <andrea.crotti.0@gmail.com> wrote:

> Carsten Dominik <carsten.dominik@gmail.com> writes:
> 
> > No, this is not possible currently.
> >
> 
> Well but I can set up formulas for an entire column like for example:
> 
> | 1 | 1 |
> | 2 | 4 |
> #+TBLFM: $2=$1^2
> 
> If I could hide one column with another setting than I would be able to
> apply the formula on a hidden field..
> 
> I'm not sure it's so easy to do though, but it could open other
> possibilities, no?

It is possible to apply a formula only to one column, e.g.:
| 1 | a | q |
| 2 | b | r |
#+TBLFM: $1=@0+10

will add 10 to all entries in the first column.

As for your encryption/decryption example, you can invoke a lisp
function on every item in a column, as described in the manual:
http://orgmode.org/manual/Formula-syntax-for-Lisp.html
e.g:

| readable | secret |
| text     | text   |
#+TBLFM: $2='(rot13-string @0)

For real encryption/decryption toggling one could prepend a special
character to each entry to indicate whether it is currently
encrypted or not.

Andy