* value of cell/spreadsheet as property value?
@ 2014-02-10 21:07 OSiUX
2014-02-11 10:01 ` Bastien
0 siblings, 1 reply; 12+ messages in thread
From: OSiUX @ 2014-02-10 21:07 UTC (permalink / raw)
To: emacs-orgmode
[-- Attachment #1: Type: text/plain, Size: 964 bytes --]
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
[-- Attachment #2: Digital signature --]
[-- Type: application/pgp-signature, Size: 836 bytes --]
^ permalink raw reply [flat|nested] 12+ messages in thread
* Re: value of cell/spreadsheet as property value?
2014-02-10 21:07 value of cell/spreadsheet as property value? OSiUX
@ 2014-02-11 10:01 ` Bastien
2014-02-11 12:21 ` OSiUX
0 siblings, 1 reply; 12+ messages in thread
From: Bastien @ 2014-02-11 10:01 UTC (permalink / raw)
To: OSiUX; +Cc: emacs-orgmode
Hi,
OSiUX <xuiso@osiux.com.ar> 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
^ permalink raw reply [flat|nested] 12+ messages in thread
* Re: value of cell/spreadsheet as property value?
2014-02-11 10:01 ` Bastien
@ 2014-02-11 12:21 ` OSiUX
2014-02-11 13:00 ` Michael Brand
0 siblings, 1 reply; 12+ messages in thread
From: OSiUX @ 2014-02-11 12:21 UTC (permalink / raw)
To: emacs-orgmode
[-- Attachment #1: Type: text/plain, Size: 1656 bytes --]
El mar, 11 feb 2014, Bastien decía:
> Hi,
>
> OSiUX <xuiso@osiux.com.ar> 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.
would be useful to be able to do this
> > ... 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?
default is left-aligned, I want to right align the numbers.
my properties por columns:
#+COLUMNS: %46ITEM(Descripción) %10COST(Estimado){$}
%10CASH(Real){$}
> > thanks and sorry, English is not my language :-(
>
> No, problem, examples somehow speak for themselves.
:-D
thanks Bastien
--
::
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
[-- Attachment #2: Digital signature --]
[-- Type: application/pgp-signature, Size: 836 bytes --]
^ permalink raw reply [flat|nested] 12+ messages in thread
* Re: value of cell/spreadsheet as property value?
2014-02-11 12:21 ` OSiUX
@ 2014-02-11 13:00 ` Michael Brand
2014-02-11 14:41 ` Bastien
0 siblings, 1 reply; 12+ messages in thread
From: Michael Brand @ 2014-02-11 13:00 UTC (permalink / raw)
To: OSiUX; +Cc: Org Mode
On Tue, Feb 11, 2014 at 1:21 PM, OSiUX <xuiso@osiux.com.ar> wrote:
> El mar, 11 feb 2014, Bastien decía:
>> 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.
Me too, still:
http://lists.gnu.org/archive/cgi-bin/namazu.cgi?idxname=emacs-orgmode&query=%2Bsubject:%22column%20view%20summary%20format%22
Michael
^ permalink raw reply [flat|nested] 12+ messages in thread
* Re: value of cell/spreadsheet as property value?
2014-02-11 13:00 ` Michael Brand
@ 2014-02-11 14:41 ` Bastien
2014-02-11 18:34 ` Michael Brand
0 siblings, 1 reply; 12+ messages in thread
From: Bastien @ 2014-02-11 14:41 UTC (permalink / raw)
To: Michael Brand; +Cc: OSiUX, Org Mode
Hi Michael,
Michael Brand <michael.ch.brand@gmail.com> writes:
> On Tue, Feb 11, 2014 at 1:21 PM, OSiUX <xuiso@osiux.com.ar> wrote:
>> El mar, 11 feb 2014, Bastien decía:
>>> 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.
>
> Me too, still:
> http://lists.gnu.org/archive/cgi-bin/namazu.cgi?idxname=emacs-orgmode&query=%2Bsubject:%22column%20view%20summary%20format%22
This should now be fixed in maint.
Thanks for reporting this, and sorry for the 2.5 years delay :)
--
Bastien
^ permalink raw reply [flat|nested] 12+ messages in thread
* Re: value of cell/spreadsheet as property value?
2014-02-11 14:41 ` Bastien
@ 2014-02-11 18:34 ` Michael Brand
2014-02-11 19:13 ` Achim Gratz
2014-02-11 20:52 ` Bastien
0 siblings, 2 replies; 12+ messages in thread
From: Michael Brand @ 2014-02-11 18:34 UTC (permalink / raw)
To: Bastien; +Cc: Org Mode
Hi Bastien
On Tue, Feb 11, 2014 at 3:41 PM, Bastien <bzg@gnu.org> wrote:
> This should now be fixed in maint.
>
> Thanks for reporting this, and sorry for the 2.5 years delay :)
Cool, thank you. I added a sentence in org.texi to point out the
dependency on the format specifier.
Michael
^ permalink raw reply [flat|nested] 12+ messages in thread
* Re: value of cell/spreadsheet as property value?
2014-02-11 18:34 ` Michael Brand
@ 2014-02-11 19:13 ` Achim Gratz
2014-02-11 20:06 ` Michael Brand
2014-02-11 20:52 ` Bastien
1 sibling, 1 reply; 12+ messages in thread
From: Achim Gratz @ 2014-02-11 19:13 UTC (permalink / raw)
To: emacs-orgmode
Michael Brand writes:
> Cool, thank you. I added a sentence in org.texi to point out the
> dependency on the format specifier.
+Numbers are right-aligned when a format specifier with an explicit width like
+@{%5d} or @code{%5.1f} is used.
+
Isn't there a "code" missing for the first example?
Regards,
Achim.
--
+<[Q+ Matrix-12 WAVE#46+305 Neuron microQkb Andromeda XTk Blofeld]>+
SD adaptation for Waldorf Blofeld V1.15B11:
http://Synth.Stromeko.net/Downloads.html#WaldorfSDada
^ permalink raw reply [flat|nested] 12+ messages in thread
* Re: value of cell/spreadsheet as property value?
2014-02-11 19:13 ` Achim Gratz
@ 2014-02-11 20:06 ` Michael Brand
0 siblings, 0 replies; 12+ messages in thread
From: Michael Brand @ 2014-02-11 20:06 UTC (permalink / raw)
To: Achim Gratz; +Cc: Org Mode
Hi Achim
On Tue, Feb 11, 2014 at 8:13 PM, Achim Gratz <Stromeko@nexgo.de> wrote:
> Isn't there a "code" missing for the first example?
Yes, now fixed. Thank you for pointing out.
Michael
^ permalink raw reply [flat|nested] 12+ messages in thread
* Re: value of cell/spreadsheet as property value?
2014-02-11 18:34 ` Michael Brand
2014-02-11 19:13 ` Achim Gratz
@ 2014-02-11 20:52 ` Bastien
2014-02-13 14:29 ` OSiUX
1 sibling, 1 reply; 12+ messages in thread
From: Bastien @ 2014-02-11 20:52 UTC (permalink / raw)
To: Michael Brand; +Cc: Org Mode
Hi Michael,
Michael Brand <michael.ch.brand@gmail.com> writes:
> Cool, thank you. I added a sentence in org.texi to point out the
> dependency on the format specifier.
Thanks for this,
--
Bastien
^ permalink raw reply [flat|nested] 12+ messages in thread
* Re: value of cell/spreadsheet as property value?
2014-02-11 20:52 ` Bastien
@ 2014-02-13 14:29 ` OSiUX
2014-02-13 14:39 ` Michael Brand
0 siblings, 1 reply; 12+ messages in thread
From: OSiUX @ 2014-02-13 14:29 UTC (permalink / raw)
To: emacs-orgmode
[-- Attachment #1: Type: text/plain, Size: 1735 bytes --]
El mar, 11 feb 2014, Bastien decía:
> Hi Michael,
>
> Michael Brand <michael.ch.brand@gmail.com> writes:
>
> > Cool, thank you. I added a sentence in org.texi to point out the
> > dependency on the format specifier.
>
> Thanks for this,
thanks for the patch, but I do not work for me :-(
- Org-mode version 8.2.5h (release_8.2.5h-631-g076b8e @ /home/osiris/data/dev/emacs-lisp/org-mode/lisp/)
- GNU Emacs 23.4.1 (i486-pc-linux-gnu, GTK+ Version 2.24.10) of 2012-09-09 on murphy, modified by Debian
Integers, ok:
#+COLUMNS: %STATUS(Estado) %46ITEM(Descripción) %10COST(Estimado) %10CASH(Real){+; %5d}
E | Descripción | Estimado | Real |
| ** 2014-02 | | 447 |
| *** income | | 1000 | ...
| *** expenses | | -553 |
| **** dinner | | -110 | ...
| **** party :-) | | -400 | ...
| **** lunch | | -43 | ...
Decimals, bad align:
#+COLUMNS: %STATUS(Estado) %46ITEM(Descripción) %10COST(Estimado) %10CASH(Real){+; %5.2f}
E | Descripción | Estimado | Real |
| ** 2014-02 | | 447.00 |
| *** income | | 1000.00 | ...
| *** expenses | | -553.00 |
| **** dinner | | -110.00 | ...
| **** party :-) | | -400.00 | ...
| **** lunch | | -43.00 | ...
is there any way to debug this?
thanks again!
--
::
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
[-- Attachment #2: Digital signature --]
[-- Type: application/pgp-signature, Size: 836 bytes --]
^ permalink raw reply [flat|nested] 12+ messages in thread
* Re: value of cell/spreadsheet as property value?
2014-02-13 14:29 ` OSiUX
@ 2014-02-13 14:39 ` Michael Brand
2014-02-13 16:40 ` OSiUX
0 siblings, 1 reply; 12+ messages in thread
From: Michael Brand @ 2014-02-13 14:39 UTC (permalink / raw)
To: OSiUX; +Cc: Org Mode
Hi OSiUX
On Thu, Feb 13, 2014 at 3:29 PM, OSiUX <xuiso@osiux.com.ar> wrote:
> {+; %5.2f}
Try %7.2f
Michael
^ permalink raw reply [flat|nested] 12+ messages in thread
* Re: value of cell/spreadsheet as property value?
2014-02-13 14:39 ` Michael Brand
@ 2014-02-13 16:40 ` OSiUX
0 siblings, 0 replies; 12+ messages in thread
From: OSiUX @ 2014-02-13 16:40 UTC (permalink / raw)
To: emacs-orgmode
[-- Attachment #1: Type: text/plain, Size: 377 bytes --]
El jue, 13 feb 2014, Michael Brand decía:
> Hi OSiUX
>
> On Thu, Feb 13, 2014 at 3:29 PM, OSiUX <xuiso@osiux.com.ar> wrote:
> > {+; %5.2f}
>
> Try %7.2f
yes, now it works fine, thank you!
--
::
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
[-- Attachment #2: Digital signature --]
[-- Type: application/pgp-signature, Size: 836 bytes --]
^ permalink raw reply [flat|nested] 12+ messages in thread
end of thread, other threads:[~2014-02-13 16:40 UTC | newest]
Thread overview: 12+ messages (download: mbox.gz / follow: Atom feed)
-- links below jump to the message on this page --
2014-02-10 21:07 value of cell/spreadsheet as property value? OSiUX
2014-02-11 10:01 ` Bastien
2014-02-11 12:21 ` OSiUX
2014-02-11 13:00 ` Michael Brand
2014-02-11 14:41 ` Bastien
2014-02-11 18:34 ` Michael Brand
2014-02-11 19:13 ` Achim Gratz
2014-02-11 20:06 ` Michael Brand
2014-02-11 20:52 ` Bastien
2014-02-13 14:29 ` OSiUX
2014-02-13 14:39 ` Michael Brand
2014-02-13 16:40 ` OSiUX
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).