[Bug] Formula editor (C-c ') does not parse first/last row/column specifications correctly

[Bug] Formula editor (C-c ') does not parse first/last row/column specifications correctly

[Achim Gratz]

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$<<..@-III$<<);%.2fEN::@>>$<<<..@>>$>=vsum(@-III..-I * @-III$<<..@-I$<<);%.2fEN::@>$<<<..@>$>=vsum(@-II..@-I);%.2f

Replace with these formulas for the second test:
#+TBLFM: @14$3..@14$6=vsum(@I..-III * @I$2..@-III$2);%.2fEN::@15$3..@15$6=vsum(@-III..-I * @-III$2..@-I$2);%.2fEN::@16$3..@16$6=vsum(@-II..@-I);%.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

Re: [Bug] Formula editor (C-c ') does not parse first/last row/column specifications correctly

[Achim Gratz]

Achim Gratz <Stromeko@nexgo.de> writes:
> Consider the following org table
[...]

I've had a look in org-table.el, I pity the person who'll have to
correct this... there are several stored and literal regex occurences
that are interacting in various ways to produce this.  I have found a
few literal regex occurences that are related to the formula editor
highlighting (but changing them broke other stuff), but I have
absolutely no idea how to correct the highlight into the table.


Regards,
Achim.
-- 
+<[Q+ Matrix-12 WAVE#46+305 Neuron microQkb Andromeda XTk Blofeld]>+

SD adaptation for Waldorf microQ V2.22R2:
http://Synth.Stromeko.net/Downloads.html#WaldorfSDada