emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
* 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).