On Fri, 04 Sep 2009 12:46:02 +0200 andrea crotti <andrea.crott...@gmail.com> wrote:
> Carsten Dominik <carsten.domi...@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: $...@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 _______________________________________________ Emacs-orgmode mailing list Remember: use `Reply All' to send replies to the list. Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode
