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


Reply via email to