Re: Table rows and ranges as LHS of formulas

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

On Mar 1, 2011, at 3:28 PM, Carsten Dominik wrote:

> Hi everyone,
> 
> A frequently requested feature for tables has been to
> be able to define row formulas in a way similar to column
> formulas.  The patch below allows things like 
> 
>   @3=
>   @2$2..@5$7=
>   @I$2..@II$4=
> 
> as the left hand side for table formulas in order to
> write a formula that is valid for an entire column or

s/column/row/

> for a rectangular section in a table.
> 
> Note that in contrast to column formulas, @3= will not
> automatically skip a "header column" or field formulas in the
> same row.  In fact, making both a range formula and a field
> point to the same field is forbidden and throws an error.
> So to have a formula apply to all but the first column, use
> something like this:
> 
>    @3$2..@3$8=....
> 
> Testing is welcome, but I am confident that this works
> pretty well.
> 
> Bastien, please let me know if you want to have this integrated
> before the release, then I will do so.
> 
> <0001-Implement-table-formulas-that-apply-to-field-ranges.patch>

- Carsten