Re: Table rows and ranges as LHS of formulas

[Carsten Dominik <carsten.dominik@gmail.com>]

On 3.3.2011, at 23:11, Nick Dokos wrote:

> Suvayu Ali <fatkasuvayu+linux@gmail.com> wrote:
> 
>> Hi,
>> 
>> On Thu, 3 Mar 2011 22:19:32 +0100
>> Carsten Dominik <carsten.dominik@gmail.com> wrote:
>> 
>>> 
>>> On 3.3.2011, at 05:18, Nick Dokos wrote:
>>> 
>>>> Carsten Dominik <carsten.dominik@gmail.com> wrote:
>>>> 
>>>>> Maybe we should use something else to achieve symmetry, like @>
>>>>> and $>.
>>>>> 
>>>>> Comments?
>>>>> 
>>>> 
>>>> Perfect. Mirrors the keybinding for end-of-buffer, so there is
>>>> mnemonic value there, and it naturally flows from the @N$N notation.
>>> 
>>> OK, this is how it works now. @L no longer works.
>>> 
>> 
>> I updated org just now. But when I try this,
>> 
>> | Expense  | Amount (CAD) |
>> |----------+--------------|
>> | Tickets  |      1191.82 |
>> | hostel   |       838.49 |
>> | per diem |      1050.00 |
>> |----------+--------------|
>> | Total    |              |
>> #+TBLFM: @>$>=vsum(@I..@II);%.2f
>> 
>> It doesn't work. Whereas this does:
>> 
>> | Expense  | Amount (CAD) |
>> |----------+--------------|
>> | Tickets  |      1191.82 |
>> | hostel   |       838.49 |
>> | per diem |      1050.00 |
>> |----------+--------------|
>> | Total    |      3080.31 |
>> #+TBLFM: @5$2=vsum(@I..@II);%.2f
>> 
>> Am I doing something wrong?
>> 
> 
> I don't think so: I don't see Carsten's change even though I just pulled, so
> I guess he has not pushed it yet (or forgot to):

Hmm, indeed, seems like I forgot to push.  Did that just now,
and tested Suvayu's example.

- Carsten

> 
> ,----
> | $ git log -3 lisp/org-table.el
> | commit dc60852d24b16555466214712181351e11b68e7c
> | Author: Bastien Guerry <bzg@altern.org>
> | Date:   Thu Mar 3 09:34:34 2011 +0100
> | 
> |     Fix small typo in docstring.
> | 
> | commit 8892fe3f0404dd608452dd8203f2783a212e8120
> | Author: Bastien Guerry <bzg@altern.org>
> | Date:   Thu Mar 3 09:30:16 2011 +0100
> | 
> |     Fix small typo in docstring.
> | 
> | commit 8237c9ae6d587a22646333e0315683675e2db538
> | Author: Carsten Dominik <carsten.dominik@gmail.com>
> | Date:   Tue Mar 1 09:05:56 2011 +0100
> | 
> |     Implement table formulas that apply to field ranges, fix minor issues
> |     
> |     * lisp/org-table.el (org-table-fedit-finish): Read more general LHS of formulas.
> |     (org-table-formula-handle-@L): New function to hanle @L references.
> |     (org-table-current-ncol): New variable.
> |     (org-table-line-to-dline): New function.
> |     (org-table-get-stored-formulas): Accept range formulas as matches.
> |     (org-table-get-specials): Compute and store the number of columns.
> |     (org-table-get-range): New optional argument CORNERS-ONLY, to retrieve
> |     only the region marked by the range, not the content.
> |     (org-table-recalculate): Call `org-table-expand-lhs-ranges' to expand
> |     range targets.  Also check for duplicate access to fields.
> |     (org-table-expand-lhs-ranges): New funktion.
> |     (org-table-get-remote-range): Bind `org-table-current-ncol' to protect
> |     the caller's value.
> |     (org-table-edit-formulas): Support highlighting of range targets.
> |     (org-table-field-info): Handle renge formulas.
> |     
> |     * doc/org.texi (Field and range formulas): Renamed from "Field formulas".
> |     Document the use of range operators as targets.
> |     (References): Document the new @L reference.
> `----
> 
> Nick