From mboxrd@z Thu Jan  1 00:00:00 1970
From: Andreas Burtzlaff <andy13@gmx.net>
Subject: Re: Re: Some table questions
Date: Fri, 4 Sep 2009 14:01:01 +0200
Message-ID: <20090904140101.0c6ab104.andy13@gmx.net>
References: <m2ab1diavt.fsf@gmail.com>
	<B8F5FA16-B055-46E1-839B-6AC037DAA7A7@gmail.com>
	<m2hbvj56ol.fsf@gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43)
	id 1MjXTb-0000bM-HB
	for emacs-orgmode@gnu.org; Fri, 04 Sep 2009 08:01:12 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1MjXTV-0000Yt-Ek
	for emacs-orgmode@gnu.org; Fri, 04 Sep 2009 08:01:09 -0400
Received: from [199.232.76.173] (port=60971 helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1MjXTU-0000Y9-He
	for emacs-orgmode@gnu.org; Fri, 04 Sep 2009 08:01:04 -0400
Received: from mail.gmx.net ([213.165.64.20]:54479)
	by monty-python.gnu.org with smtp (Exim 4.60)
	(envelope-from <andy13@gmx.net>) id 1MjXTT-0000PV-RS
	for emacs-orgmode@gnu.org; Fri, 04 Sep 2009 08:01:04 -0400
In-Reply-To: <m2hbvj56ol.fsf@gmail.com>
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/pipermail/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: andrea crotti <andrea.crotti.0@gmail.com>
Cc: emacs-orgmode@gnu.org

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