Table calculations with hline references

Table calculations with hline references

[Daniel Hornung]

[-- Attachment #1: Type: text/plain, Size: 1068 bytes --]

Hi,
I am trying to calculate a field using references to horizontal lines 
according to http://orgmode.org/manual/References.html

For example:

| col1 | col2 |
|------+------|
| foo  |    1 |
| bar  |    2 |
| baz  |    4 |
|------+------|
| sum  |      |
|      |      |
#+TBLFM: @II+1$2=vsum(@I$2..@II$2)

The field to the right of "sum" (@5$2 as a fixed reference) should be "7".

The output is as follows though (the cursor was in the "baz" field
when I pressed "C-u C-c *" to recalculate all formulas):

| col1 | col2 |
|------+------|
| foo  |    1 |
| bar  |    2 |
| 7    |    7 |
|------+------|
| 10   |   10 |
|      |      |
#+TBLFM: @II+1$2=vsum(@I$2..@II$2)

Could anyone enlighten me where I made a mistake here?

Thanks a lot,
Daniel


-- 
Mein öffentlicher Schlüssel / My public key: 4096R/600ACB3B 2012-04-01
Fingerabdruck / Fingerprint:
9902 575B B9A0 C339 CFDF  250B 9267 CA6B 600A CB3B
Runterladen z.B. bei/ Get it e.g. from:
pgp.mit.edu, subkeys.pgp.net, pgp.uni-mainz.de, pool.sks-keyservers.net, ...

[-- Attachment #2: This is a digitally signed message part. --]
[-- Type: application/pgp-signature, Size: 836 bytes --]

Re: Table calculations with hline references

[Aaron Ecay]

Hi Daniel,

What version of org are you using?  Using a hline-relative reference on
the lhs of a formula is not allowed in the current development version
of org (i.e. the master branch).  Presumably because it doesn’t work
correctly, as you have discovered.

The patch to prevent this was made over a year ago (2013-11-05).  However,
as far as I can tell it has not been in any released version of org.  I
tried to ascertain this using the command:

git tag --contains a2c71a6

Which returns only:

beta_8.3
release_8.3beta

Sorry that there’s not a more satisfying answer,

-- 
Aaron Ecay

Re: Table calculations with hline references

[Daniel Hornung]

[-- Attachment #1: Type: text/plain, Size: 1308 bytes --]

On Monday, 19. January 2015 00:07:39 Aaron Ecay wrote:
> Hi Daniel,
> 
> What version of org are you using?  Using a hline-relative reference on
> the lhs of a formula is not allowed in the current development version
> of org (i.e. the master branch).  Presumably because it doesn’t work
> correctly, as you have discovered.
> 
> The patch to prevent this was made over a year ago (2013-11-05).  However,
> as far as I can tell it has not been in any released version of org.  I
> tried to ascertain this using the command:
> 
> git tag --contains a2c71a6
> 
> Which returns only:
> 
> beta_8.3
> release_8.3beta

Hi Aaron,

I tested it with the latest version from ELPA:

Org-mode version 8.2.10 (8.2.10-29-g89a0ac-elpa @ 
/home/daniel/.emacs.d/elpa/org-20150112/)

But thanks for the hint that this is a known problem, I will just stick with 
fixed references which are fine, as long as I remember not to delete or insert 
lines with generic delete or copy&paste commands.

Cheers,
Daniel

-- 
Mein öffentlicher Schlüssel / My public key: 4096R/600ACB3B 2012-04-01
Fingerabdruck / Fingerprint:
9902 575B B9A0 C339 CFDF  250B 9267 CA6B 600A CB3B
Runterladen z.B. bei/ Get it e.g. from:
pgp.mit.edu, subkeys.pgp.net, pgp.uni-mainz.de, pool.sks-keyservers.net, ...

[-- Attachment #2: This is a digitally signed message part. --]
[-- Type: application/pgp-signature, Size: 836 bytes --]