Re: Table rows and ranges as LHS of formulas

[Nick Dokos <nicholas.dokos@hp.com>]

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):

,----
| $ 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