[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[O] [Bug] Formula editor (C-c ') does not parse first/last row/column sp
From: |
Achim Gratz |
Subject: |
[O] [Bug] Formula editor (C-c ') does not parse first/last row/column specifications correctly |
Date: |
Sun, 26 Feb 2012 22:23:56 +0100 |
User-agent: |
Gnus/5.13 (Gnus v5.13) Emacs/24.0.93 (gnu/linux) |
Consider the following org table
| Component | Price | Var-1 | Var-2 | Var-3 | Var-4 |
|----------------------------+--------+--------+--------+--------+--------|
| CPU A | 119.90 | 1 | 1 | | |
| CPU B | 189.90 | | | 1 | 1 |
|----------------------------+--------+--------+--------+--------+--------|
| boxed | | 1 | | 1 | |
| Fan A | 22.99 | | 1 | | 1 |
|----------------------------+--------+--------+--------+--------+--------|
| Mainboard A | 47.90 | 1 | | 1 | |
| Mainboard B | 97.99 | | 1 | | 1 |
|----------------------------+--------+--------+--------+--------+--------|
| integrated | | 1 | | 1 | |
| Graphics A | 59.90 | | 1 | | 1 |
|----------------------------+--------+--------+--------+--------+--------|
| Case A | 29.99 | 1 | | 1 | |
| Case B | 39.99 | | 1 | | 1 |
|----------------------------+--------+--------+--------+--------+--------|
| PSU A | 29.99 | 1 | 1 | | |
| PSU B | 38.99 | | | 1 | 1 |
|----------------------------+--------+--------+--------+--------+--------|
| CPU/Fan/Mainboard/Graphics | | 167.80 | 300.78 | 237.80 | 370.78 |
| Case/PSU | | 59.98 | 69.98 | 68.98 | 78.98 |
|----------------------------+--------+--------+--------+--------+--------|
| Sum | | 227.78 | 370.76 | 306.78 | 449.76 |
#+TBLFM: @>>>$<<<..@>>>$>=vsum(@I..-III *
@I$<<address@hidden<<);%.2fEN::@>>$<<<..@>>$>=vsum(@-III..-I *
@-III$<<address@hidden<<);%.2fEN::@>$<<<..@>$>=vsum(@address@hidden);%.2f
Replace with these formulas for the second test:
#+TBLFM: @address@hidden(@I..-III *
@address@hidden);%.2fEN::@address@hidden(@-III..-I *
@address@hidden);%.2fEN::@address@hidden(@address@hidden);%.2f
Enter the formula editor:
- row and column specifications relative to the beginning or end of the
table (e.g. @>>$<<<) are not taken into account when showing the table
highlight, in fact they seem to break parsing as the highlight in the
table editor stops prematurely.
- range specifications relative to the target cell (e.g. @I$<<..-III$<<)
produce highlights that are spanning the wrong fields. It seems that
they are always counting from the last line up. Also check with the
second TBLFM line.
Regards,
Achim.
--
+<[Q+ Matrix-12 WAVE#46+305 Neuron microQkb Andromeda XTk Blofeld]>+
SD adaptation for Waldorf Blofeld V1.15B11:
http://Synth.Stromeko.net/Downloads.html#WaldorfSDada
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [O] [Bug] Formula editor (C-c ') does not parse first/last row/column specifications correctly,
Achim Gratz <=