https://bugs.freedesktop.org/show_bug.cgi?id=63091
Priority: medium
Bug ID: 63091
Assignee: [email protected]
Summary: applying formula to a cell range
Severity: enhancement
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: unspecified
Component: Spreadsheet
Product: LibreOffice
sometimes you have a formula that is going to be copied to a cell range, you
can do it copying or dragging the initial cell to the cell range.
this is how MS office works and Libre Office mimmic. It's fine.
Enhancement example:
write a formula in cell A1, select a cell range A2:Z800. and put a "pointer" to
the initial formula A1 on each cell of the range A2:Z800.
If you change the formula in A1 all the cell range A2:Z800 as pointing the same
formula, will be updated automatically, so no need to drag over the cell range
anymore. This allows to develope formula in A1 and see the results on the cell
range.
If you change the formula in E50, you drop the pointer to A1 and use that
particular formula for E50.
advantages:
- faster formula develope write once, no drag or copy over the cell range each
time the formula change.
- no errors or different version of the formula on individual cells of the
range.
- the final file on disk would ocuppy less space, as you don't need to write
the formula for each cell in the range, just the pointer to the original cell
containing the formula.
I's similar to the conditional formatting in MS excell 2010, but for cell
formulas.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
