https://bugs.freedesktop.org/show_bug.cgi?id=67989
Priority: medium
Bug ID: 67989
Assignee: [email protected]
Summary: EDITING: Cell reference not working any more when
columns added
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.0.4 release
Component: Spreadsheet
Product: LibreOffice
With LO 4.10 create a new sheet and enter a value wathsoever in a cell, let’s
say in D5 enter “ok”
enter in anoter cell e.g. G5 the formula “=D5”
Now in cell G5 same value of D5 is displayed, i.e. “ok”.
Now add a column between columns A and D, for example add a column between
existing columns B and C. Former cell D5 is now E5 (still with value “NO”) and
former cell G5 is now H5, still with formula “=E5” and display “NO”
Change the value of cell E5, enetring for example “Yes”, formula in H5 is still
“=E5”, but display has not been recalculated, and is still “NO”.
Current behavior:
Value displayed in cell H5 remains "NO" (the previous value of cell E5
Expected behavior:
The new value "YES" should be displayed.
It happens in windows XP, Seven, Linux Debian (Sid) and PCLinux OS. LO release
4.0.4.2 was not affected (at least in Debian Sid)
Operating System: All
Version: 4.1.0.4 release
--
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