[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[O] Re: Table rows and ranges as LHS of formulas
From: |
Carsten Dominik |
Subject: |
[O] Re: Table rows and ranges as LHS of formulas |
Date: |
Tue, 1 Mar 2011 16:10:05 +0100 |
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=
> @address@hidden
> @address@hidden
>
> 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:
>
> @address@hidden
>
> 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