https://bugs.freedesktop.org/show_bug.cgi?id=74014
Priority: medium
Bug ID: 74014
Assignee: [email protected]
Summary: Editing : Cell formula not updating.
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.2.0.3 rc
Component: Spreadsheet
Product: LibreOffice
Cell formula not updating.
Step to Produce :
Method 1.
1. Column having values 20, 10, 25, 30, 10. & Sum in the 6th row.
2. Just cut the 1-5 row cell values, sum cell is become zero.
3. Just undo the operation, Values comes back in cell, but still sum cell is
zero.
4. Press f9 in sum cell. No change in the sum value.
5. You need type a value in 1-5 cell to update the sum formula or close & open
file again to update.
Method 2.
1. Column having values 20, 10, 25, 30, 10. & Sum in the 12th row cell.
2. Copy first 4 values.
3. Paste using un-formated[ Paste special option] in 5-8 cell.
4. No change in the sum value.
5. Press f9 in sum cell. No change in the sum value.
6. You need type a value in 1-8 cell to update the sum formula or close & open
file again to update.
--
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
