https://bugs.documentfoundation.org/show_bug.cgi?id=99178
Bug ID: 99178
Summary: EDITING: Spreading a formula create right formulas but
shows wrong results
Product: LibreOffice
Version: 5.1.1.1 rc
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 124198
--> https://bugs.documentfoundation.org/attachment.cgi?id=124198&action=edit
very simple spreadsheet document that shows wrong behaviour
Open the attached very simple spreadsheet document.
Go to B1
Formula is =10+A1
Clic and drag down to spread the formula down to cell B7
The right formulas are created, but the result values are not shown
Go back to B1
Spread the formula towards the right cells
The right formulas are created, but the shown values are wrong
As suggested in bug 98159, pressing [F9] does compute the right results.
Users never wanted to disable AutoUpdate on this document.
They do not know how to restore AutoUpdate.
There is no menu Tools / Cell Contents / AutoUpdate.
There should be a visual indication that AutoUpdate is disabled, at least.
Wrong results should not be shown.
And the documentation should be updated to explain how to restore normal update
of cell contents.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
