https://bugs.freedesktop.org/show_bug.cgi?id=86516
Bug ID: 86516
Summary: Formulas copied with cell dragging, that contain
expressions on cell ranges, are not evaluated
correctly
Product: LibreOffice
Version: 4.3.2.2 release
Hardware: Other
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
To reproduce:
* Create new spreadsheet with auto calculate setting on.
* Ensure that range A1:A10 contains values 1 to 10.
* In B1, enter formula =SUM($A$1 : $A1)
* In C1, enter formula =MAX($A$1 : $A1)
* In D1, enter formula =MAX($A$1 ; $A1)
* Drag copy (not sure how is that called) B1 to range B1:B10. The formulas were
copied correctly to the other cells, but all cells have the value of 1. F9 or
crtl-Shift-F9 does not help.
* Do the same for C1. It shows the same problem.
* Do the same for D1. It does not have this problem. Maybe because the formula
does not contain a range?
--
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
