https://bugs.freedesktop.org/show_bug.cgi?id=72100
Priority: medium
Bug ID: 72100
Assignee: [email protected]
Summary: EDITING: Deleting contents of cells with formulas in
TABLE gives 0 in some cells, and doesn't change other
cells in multiple selection
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: Inherited From OOo
Component: Writer
Product: LibreOffice
When a table cell contain a formula, deleting the whole cell content gives zero
in the cell.
Steps to reproduce:
1. Create a text document
2. Add a table 2x1
3. Put some formulas in the cells, say, "=1" in A1 and "=2" in B1.
4. Select both cells at once, and press "Del".
Expected: both cells should be empty.
Actual result: the cells contain character "0". Actually, the cell that holds
the focus may be initially empty, but if you click outside of it, the zero
appears.
And if the formulas reference other cells, things become worse.
Steps:
1. Create a table 1x3.
2. Put "=1" into the first cell (A1), "=<A1>+1" into the second (B1), "=<B1>+1"
into the third (C1).
3. Select all three cells, press "Del".
Expected: all cells empty.
Actual result: A1 now contain character "0" (no formula), cells B1 and C1 both
still contain the unchanged formulas (but the result is changed, of course).
Deleting the three cells again removes zero from the A1, and the formula from
B1, but now B1 holds zero, and C1 still contain the formula.
This makes deleting multiple formulas very difficult task.
Tested with 4.1.3.2, 3.3.0.2 and AOO4.0 under Win7x64, and 4.1.3.2 under Ubuntu
13.10 x64.
--
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
