From mboxrd@z Thu Jan 1 00:00:00 1970 From: OSiUX Subject: Re: value of cell/spreadsheet as property value? Date: Tue, 11 Feb 2014 09:21:36 -0300 Message-ID: <20140211122136.GB1163@localhost> References: <20140210210722.GA1163@localhost> <87ppmuufwu.fsf@bzg.ath.cx> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="TakKZr9L6Hm6aLOc" Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:59801) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WDCL3-000055-4Y for emacs-orgmode@gnu.org; Tue, 11 Feb 2014 07:21:26 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1WDCKy-0000pZ-P7 for emacs-orgmode@gnu.org; Tue, 11 Feb 2014 07:21:21 -0500 Received: from merlot.gcoop.coop ([67.208.113.123]:50057) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1WDCKy-0000ow-HS for emacs-orgmode@gnu.org; Tue, 11 Feb 2014 07:21:16 -0500 Received: from localhost (merlot [127.0.0.1]) (Authenticated sender: xuiso@osiux.com.ar) by merlot.gcoop.coop (Postfix) with ESMTPSA id 94877148948 for ; Tue, 11 Feb 2014 09:21:28 -0300 (ART) Content-Disposition: inline In-Reply-To: <87ppmuufwu.fsf@bzg.ath.cx> 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 --TakKZr9L6Hm6aLOc Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable El mar, 11 feb 2014, Bastien dec=C3=ADa: > Hi, >=20 > OSiUX writes: >=20 > > 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=3Dvsum(@I..@II);%0.2f >=20 > No, this is not possible. would be useful to be able to do this =20 > > ... 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 | >=20 > I'm not sure I understand -- you want numbers to be aligned > on the left instead of the right in the column view? default is left-aligned, I want to right align the numbers. my properties por columns: #+COLUMNS: %46ITEM(Descripci=C3=B3n) %10COST(Estimado){$} %10CASH(Real){$} > > thanks and sorry, English is not my language :-( >=20 > No, problem, examples somehow speak for themselves. :-D =20 thanks Bastien --=20 :: 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 --TakKZr9L6Hm6aLOc Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.12 (GNU/Linux) iQIcBAEBAgAGBQJS+hXQAAoJELMIpnGSN9NsK5sP+gLEINTcGZATblbkWK+ZgnTW MqLlglfZDolfIOncetWUj3KPmC1WgsqJCuFfYkXCXuBNMK5aR+XRUfpC3lYr6blz fy++Vee216Mqp2ycVsBm23MCbx9CJ/jyQyx6z84RY0kCUZNXwUx3g/REjQDWMpY1 PNbG61QzPDS6RDhFIEjB06NkaPpWMPDVNytnoBvbO8VfGYea0c6smkk80knScOux TnD9aFT713vEmfdlhJD6y9kDmKZqC6c+CVmXh+UP6irJ59mFVEQFH9uvh142ydWT OnDQC+vTDB03wiaOooCW7y1MZHfkKIAyQRFsfeJ0ZCq+F9zlucGuxHMaWtT/zKj7 mgCHy3A9lTvPGm2D2RYkOqti2nFPfLVzs8G0kVczVeytQ7r95f6y60UKKAlYB2IN G0KF0q6X1MP0P1un9RqrW9p5xOpV+alh08toR0A/u+G8/Tf7PgZLILy6aLwMkR3j p4pqB/g/cOke/QH8rqaRDLo70WDDx9bqbaWb9uHP+RTKO8i9OTfteyFfny4y6BJN 6hbjkWOYOZDfxjolTCA6GvJoqHpm+BRXvsWFRBhnpZaQZQJdTBHOon9cbCN9pFfA bvUpoY5yMhZE5zTufSVGCQ7FyngJq1H1MM/UDb/5C1gKKzfzmXPHo7WMPe24aAWu GtFw9nS1zGFy8TOtwpoi =tgcn -----END PGP SIGNATURE----- --TakKZr9L6Hm6aLOc--