From mboxrd@z Thu Jan 1 00:00:00 1970 From: OSiUX Subject: value of cell/spreadsheet as property value? Date: Mon, 10 Feb 2014 18:07:22 -0300 Message-ID: <20140210210722.GA1163@localhost> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="d6Gm4EdcadzBjdND" Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:39283) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WCy4L-00045k-Hc for emacs-orgmode@gnu.org; Mon, 10 Feb 2014 16:07:14 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1WCy4G-0001FW-Uw for emacs-orgmode@gnu.org; Mon, 10 Feb 2014 16:07:09 -0500 Received: from merlot.gcoop.coop ([67.208.113.123]:42567) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WCy4G-0001FJ-Q2 for emacs-orgmode@gnu.org; Mon, 10 Feb 2014 16:07:04 -0500 Received: from localhost (merlot [127.0.0.1]) (Authenticated sender: xuiso@osiux.com.ar) by merlot.gcoop.coop (Postfix) with ESMTPSA id 38419148947 for ; Mon, 10 Feb 2014 18:07:35 -0300 (ART) Content-Disposition: inline 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: emacs-orgmode@gnu.org --d6Gm4EdcadzBjdND Content-Type: text/plain; charset=us-ascii Content-Disposition: inline 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 ... 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 | thanks and sorry, English is not my language :-( -- :: Osiris Alejandro Gomez (OSiUX) osiux@osiux.com.ar DC44 95D2 0D5D D544 FC1A F00F B308 A671 9237 D36C http://www.osiux.com.ar http://www.altermundi.net --d6Gm4EdcadzBjdND Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.12 (GNU/Linux) iQIcBAEBAgAGBQJS+T+KAAoJELMIpnGSN9Nss6oP/i0OC3hmLHmP9lt3v43vZBai U8xGf99CWlVb2ZO+0xj4FLa4hyhKZP2OiPLQTgSnNnH8b8WMVxJPL0aAGbnP8Gf3 GrfzM4GwGPZos5/nwpEK7gOiQKlA7vjO++98EIfjj/pQM4d2yUb4oLup5Pvyo4W4 wXe5qj/C1ME0ZHm1o/L+qmoraOekvmzH2t51snIt1Ef8P3iCaNlSNUTn2QcwNrAX GhjMnR3gV3jEUCMMRo+elUBEFmesoGh6PjYhS0juQsv5jPVwoTElgta+twUdEzxw ba3lsStOo//0tlezPQ2p1x3fJcV6goIL1c3FryVa1KjVDkkmrCXcnP27d4ibsifK x0kOGO1/dACxVDA94y7x83W9bNLmVxreEX3dTviy4vipW8rsmN2A5pTlrZ7qOq3g Y3/HH1ZGE3sm9kPjqT/vQV8XJVt2JmK2YH6xMzmNod1ETXP+sO9XeOfWz8DZTTe4 oaakwuwSZqUYtpvViQRvvtmIWJFsAeNJCJnJxJ+3P57F1VUGnd6bByRFGcnIJkH/ +HDNRsoIDkF0D+wfq9BlmarenZUpQJPSKPjWlKQ4Mkfr33CIIJ1d3uMQ2nEhrIHj Tkk7rhP9WU3vR3Dh/LVnISksqh2CFqcmZwszaTnqsSCwY1T03Xfhxv9K4IsXOLEa GEF5cY0YBW/2b0Gk5D7a =LZtK -----END PGP SIGNATURE----- --d6Gm4EdcadzBjdND--