emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: Andreas Burtzlaff <andy13@gmx.net>
To: andrea crotti <andrea.crotti.0@gmail.com>
Cc: emacs-orgmode@gnu.org
Subject: Re: Re: Some table questions
Date: Fri, 4 Sep 2009 14:01:01 +0200	[thread overview]
Message-ID: <20090904140101.0c6ab104.andy13@gmx.net> (raw)
In-Reply-To: <m2hbvj56ol.fsf@gmail.com>

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

      parent reply	other threads:[~2009-09-04 12:01 UTC|newest]

Thread overview: 8+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2009-09-02 16:12 Some table questions andrea crotti
2009-09-02 16:38 ` Nick Dokos
2009-09-03  9:22   ` andrea crotti
2009-09-03 12:48     ` Nick Dokos
2009-09-03  6:51 ` Carsten Dominik
2009-09-04 10:46   ` andrea crotti
2009-09-04 11:16     ` Carsten Dominik
2009-09-04 12:01     ` Andreas Burtzlaff [this message]

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=20090904140101.0c6ab104.andy13@gmx.net \
    --to=andy13@gmx.net \
    --cc=andrea.crotti.0@gmail.com \
    --cc=emacs-orgmode@gnu.org \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body.
Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).