https://bugs.freedesktop.org/show_bug.cgi?id=75324
Priority: medium
Bug ID: 75324
Assignee: [email protected]
Summary: EDITING: Cell range in formula is incorrectly updated
if cells are move out of that range
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.4.2 release
Component: Spreadsheet
Product: LibreOffice
Problem description:
If the cells that are referred in a formula are moved to another position, the
formula is usually updated to refer to the new cell locations; however, if the
reference is made as a range, this update does not consider that the range
would have to be split into multiple parts if a cell inside this range is moved
to a new location outside of the range.
A use case for this could be that one wants to rearrange columns with data, so
without notice, the formulas in other columns would be messed up.
Steps to reproduce:
1. Create new spreadsheet and enter following content:
A1: 4
B1: 12
C1: 7
F1: =MAX(A1:C1)
G1: =MAX(A1;B1;C1)
2. Mark column A, move it between columns B & C (drag+ALT)
3. Mark cokumn A, move it between columns D & E (drag+ALT)
Current behavior:
Table contents after step 1: 4, 12, 7, , , =MAX(A1:C1), =MAX(A1;B1;C1)
Table contents after step 2: 12, 4, 7, , , =MAX(A1:C1), =MAX(B1;A1;C1)
Table contents after step 3: 4, 7, , 12, , =MAX(A1:B1), =MAX(A1;D1;B1)
Expected behavior:
Table contents after step 3: 4, 7, , 12, , =MAX(A1:B1;D1),
=MAX(A1;D1;B1)
Operating System: Ubuntu
Version: 4.1.4.2 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
