https://bugs.freedesktop.org/show_bug.cgi?id=66353
Priority: medium
Bug ID: 66353
Assignee: [email protected]
Summary: **Expression is faulty** in cells with mix of
references to this table and another table cells after
pasting cells
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 3.6.3.2 release
Component: Writer
Product: LibreOffice
Steps to reproduce:
1. Create a new empty document.
2. Insert a table, say, 1x1 (dimensions don't matter) - Table 1.
3. Put a value in the first cell of Table 1 (A1), say, 1.
4. After the first table, add another table 1x3 (again, dimensions don't
matter, but to show the problem, 3 or more cells required) - Table 2.
5. In the top cell of Table 2 (A1), write a value, say, 1.
6. In the second cell of Table 2 (A2), press F2, then click to the first cell
of Table 2 (A1), type "+", then click to the first cell of Table 1 (A1). The
resulting formula reads "=<A1>+<Table1.A1>". The result of the formula is 2.
7. Select first cell of Table 2. To do it, start selecting in A1, move mouse
over A2, then return back to A1. This way, the cell A1 is selected, not the
text inside it. This is important. Copy it to clipboard.
8. Put the caret to last cell of Table 2 (A3), and paste the copied cell.
Expected result:
The contents of first two cells of Table 2 must remain unchanged; the last cell
should now contain number 1.
Actual result:
The second cell (A2) now shows **Expression is faulty**. Its formula now reads
"=<A1>+<?>".
Impact:
This bug makes it almost impossible to productively work with several
interconnected tables in a document; trying to paste several cells (say, a
column) results in ruined formulas in all cells containing formulas with
references both to cells of this table and cells of another table. If a formula
contains only references to other table' cells, or only references to this
table cells, this formula will stay intact. If in step 7 you copy only text,
not the cell itself, everything will work without problems, but this is not
feasible when there are many cells that must be copied this way. And if you
intend to copy a formula that will update itself in the new place relative to
neighbor cells, selecting the text of cell won't help, either. So, this bug
prevents users from making professional quality work -> normal/medium.
Already present in 3.6.3.2; still present in 4.1.0.1.
--
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
