[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[O] [BUG] hline references on left side of table formula
From: |
Rick Frankel |
Subject: |
[O] [BUG] hline references on left side of table formula |
Date: |
Wed, 01 May 2013 13:27:03 -0400 |
User-agent: |
Roundcube Webmail/0.7.1 |
Hi-
I don't know if this is a bug or feature :), but if an hline reference
(@I, etc) is used on the left side of a calculation, it applies to ALL
columns in the row even if the column is specfied.
Here are some examples to show the results. I would expect all three
versions to generate the same results as the first example.
#+BEGIN_ORG
* Absolute reference (expected results)
| a | b |
|---+---|
| x | 1 |
| y | 2 |
|---+---|
| | 3 |
#+TBLFM: @4$2=vsum(@address@hidden)
* hline reference
| a | b |
|-------+---|
| x | 1 |
| y | 2 |
|-------+---|
| x + y | 3 |
#+TBLFM: @II$2=vsum(@address@hidden)
* hline reference with full cell specification in sum
| a | b |
|---+---|
| x | 1 |
| y | 2 |
|---+---|
| 3 | 3 |
#+TBLFM: @II$2=vsum(@address@hidden)
#+END_ORG
FWIW, I believe the problem is that `org-table-recalculate' is
matching lhs cell references explicitly against pure numeric
references ("@[0-9]+$[0-9]+") and therefore expands the lhs via
`org-expand-lhs-ranges' instead of expanding it with
`org-table-get-descriptor-line'
rick
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [O] [BUG] hline references on left side of table formula,
Rick Frankel <=