emacs-orgmode
[Top][All Lists]
Advanced

[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




reply via email to

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