Hi Rick,
hline-relative references on the left side of a table are currently not
supported. The fact that this is expanded is a bug. A patch catching this
case would be very welcome.
Regards
- Carsten
On May 1, 2013, at 7:27 PM, Rick Frankel <r...@rickster.com> wrote:
> 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(@I..@II)
>
> * hline reference
> | a | b |
> |-------+---|
> | x | 1 |
> | y | 2 |
> |-------+---|
> | x + y | 3 |
> #+TBLFM: @II$2=vsum(@I..@II)
>
> * hline reference with full cell specification in sum
> | a | b |
> |---+---|
> | x | 1 |
> | y | 2 |
> |---+---|
> | 3 | 3 |
> #+TBLFM: @II$2=vsum(@I$2..@II$2)
> #+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
>
>
