From mboxrd@z Thu Jan 1 00:00:00 1970 From: Bastien Subject: Re: value of cell/spreadsheet as property value? Date: Tue, 11 Feb 2014 11:01:21 +0100 Message-ID: <87ppmuufwu.fsf@bzg.ath.cx> References: <20140210210722.GA1163@localhost> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:51649) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WDA9j-0002FO-Oo for emacs-orgmode@gnu.org; Tue, 11 Feb 2014 05:01:36 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1WDA9e-0007b2-IS for emacs-orgmode@gnu.org; Tue, 11 Feb 2014 05:01:31 -0500 Received: from rs249.mailgun.us ([209.61.151.249]:46034) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WDA9e-0007am-Dt for emacs-orgmode@gnu.org; Tue, 11 Feb 2014 05:01:26 -0500 In-Reply-To: <20140210210722.GA1163@localhost> (OSiUX's message of "Mon, 10 Feb 2014 18:07:22 -0300") 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: OSiUX Cc: emacs-orgmode@gnu.org Hi, OSiUX writes: > is possible to use a cell reference to a table > or spreadsheet as a property value? > > Example: > > ***** lunch > :PROPERTIES: > :CASH: #lunchtable:@>$2 > :END: > > #+NAME: lunchtable > | date | cash | > |------------------+---------+ > | [2014-02-10 lun] | 16.00 | > | [2014-02-07 vie] | 27.00 | > |------------------+---------+ > | | 43.00 | > #+TBLFM: @>$2=vsum(@I..@II);%0.2f No, this is not possible. > ... and align numbers in the columns view? > > *** 2014-01... > | *** 2014-02 | 447.00 | > | **** income | 1000.00 | ... > | **** expenses | -553.00 | > | ***** dinner | -110.00 | ... > | ***** party :-) | -400.00 | ... > | ***** lunch | -43.00 | I'm not sure I understand -- you want numbers to be aligned on the left instead of the right in the column view? > thanks and sorry, English is not my language :-( No, problem, examples somehow speak for themselves. -- Bastien