[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[O] Table rows and ranges as LHS of formulas
From: |
Carsten Dominik |
Subject: |
[O] Table rows and ranges as LHS of formulas |
Date: |
Tue, 1 Mar 2011 15:28:07 +0100 |
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
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
Description: Binary data