emacs-orgmode
[Top][All Lists]
Advanced

[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




reply via email to

[Prev in Thread] Current Thread [Next in Thread]