From mboxrd@z Thu Jan 1 00:00:00 1970 From: Guido Van Hoecke Subject: Using constants in columns Date: Fri, 16 Oct 2015 14:39:51 +0200 Message-ID: Mime-Version: 1.0 Content-Type: multipart/alternative; boundary=047d7b15adff490e8d0522381935 Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:51910) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Zn4J5-0004wC-24 for emacs-orgmode@gnu.org; Fri, 16 Oct 2015 08:40:23 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1Zn4J4-00060j-7E for emacs-orgmode@gnu.org; Fri, 16 Oct 2015 08:40:22 -0400 Received: from mail-wi0-x235.google.com ([2a00:1450:400c:c05::235]:36195) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Zn4J4-00060Z-11 for emacs-orgmode@gnu.org; Fri, 16 Oct 2015 08:40:22 -0400 Received: by wicgb1 with SMTP id gb1so7773644wic.1 for ; Fri, 16 Oct 2015 05:40:21 -0700 (PDT) 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: orgmode --047d7b15adff490e8d0522381935 Content-Type: text/plain; charset=UTF-8 Hi, Is there a way to use a constant directly in a table column? I need to have a table where one of the columns can have one out of three possible values and wanted to use constants for this. >From the following minimal example it appears that constants are only possible in formulas, or am I missing something? #+CONSTANTS: vat=1.21 | 12.34 | $vat | #ERROR | 14.9314 | #+TBLFM: $3=$1*$2::$4=$1*$vat Using the $vat constant directly from the content of column 3 produces an error, using it from a formula works fine. If this is the way it is, I'll have to write a formula for each row of the column, that'd be a real pitty... Please advise TIA, Guido --047d7b15adff490e8d0522381935 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,

Is there a way to use a constant d= irectly in a table column?
I need to have a table where one of = the columns can have one out of three possible values and wanted to use con= stants for this.
From the following minimal example it appears = that constants are only possible in formulas, or am I missing something?
#+CONSTANTS: vat=3D1.21
| 12.34 | $vat | #ERROR | 14.9314 |
#+TB= LFM: $3=3D$1*$2::$4=3D$1*$vat
=C2=A0
Using the $v= at constant directly from the content of column 3 produces an error, using = it from a formula works fine.

If this is the way it is, I&#= 39;ll have to write a formula for each row of the column, that'd be a r= eal pitty...

Please advise

TIA, Guido
--047d7b15adff490e8d0522381935--