value of cell/spreadsheet as property value?

value of cell/spreadsheet as property value?

[OSiUX]

[-- 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 --]

Re: value of cell/spreadsheet as property value?

[Bastien]

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

Re: value of cell/spreadsheet as property value?

[OSiUX]

[-- 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 --]

Re: value of cell/spreadsheet as property value?

[Michael Brand]

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

Re: value of cell/spreadsheet as property value?

[Bastien]

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

Re: value of cell/spreadsheet as property value?

[Michael Brand]

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

Re: value of cell/spreadsheet as property value?

[Achim Gratz]

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

Re: value of cell/spreadsheet as property value?

[Michael Brand]

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

Re: value of cell/spreadsheet as property value?

[Bastien]

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

Re: value of cell/spreadsheet as property value?

[OSiUX]

[-- 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 --]

Re: value of cell/spreadsheet as property value?

[Michael Brand]

Hi OSiUX

On Thu, Feb 13, 2014 at 3:29 PM, OSiUX <xuiso@osiux.com.ar> wrote:
> {+; %5.2f}

Try %7.2f

Michael

Re: value of cell/spreadsheet as property value?

[OSiUX]

[-- 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 --]