https://bugs.documentfoundation.org/show_bug.cgi?id=152080
Bug ID: 152080
Summary: Cell dragging is not "smart"
Product: LibreOffice
Version: 7.3.6.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When I select 2 cells below each other containing the formulas
"=SUMPRODUCT(A1=B1:B50)" and "=SUMPRODUCT(A2=B1:B50)" and 'drag' them (I don't
know the technical term), I expect the next created cell to be
"=SUMPRODUCT(A3=B1:B50)". Instead the next cell is "=SUMPRODUCT(A3=B3:B52)". I
am making the assumption this is not expected behaviour.
Steps to Reproduce:
1. In cell C1: "=SUMPRODUCT(A1=B1:B50)"
2. In cell C2: "=SUMPRODUCT(A2=B1:B50)"
3. Select both cells and 'drag' to next unoccupied cell
Actual Results:
Cell C3 contains the formula "=SUMPRODUCT(A3=B3:B52)"
Expected Results:
Cell C3 contains the formula "=SUMPRODUCT(A3=B1:B50)"
Reproducible: Always
User Profile Reset: No
Additional Info:
There is no other information.
--
You are receiving this mail because:
You are the assignee for the bug.
