https://bugs.documentfoundation.org/show_bug.cgi?id=162974
Bug ID: 162974
Summary: Calc - Cell reference increments unexpectantly in
formula
Product: LibreOffice
Version: 24.8.1.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
LIbreOffice version 24.8.1.2
Calculating D(i)=D(i-1) + Constant.
Constant stored in cell B(2), B(") also increments
Steps to Reproduce:
1.store Base value in B(1)
2.store increment value in B2
3.set D1 = base = B1 (e.g. B1=10)
4.set D2 = D1 (e.g B2= 0.1)
5. D3 = D2 + B1
6. D4 = D3 + B1
7. Highlight D2 to D4 and extend to D15.
8. "B1" also increments to "B4", "B7" etc.
Actual Results:
With B1 = baseline = 10, B2 = increment = 0.1 and D1 = B1
D1 = 10
D2 = 10.1
D3 = 10.2
D4 = 10.3
D5 = 10.3
D6 = 10.3
D7 = 10.3
etc.
Expected Results:
Expected
D1 = 10
D2 = 10.1
D3 = 10.2
D4 = 10.3
D5 = 10.4
D6 = 10.5
D7 = 10.6
etc.
Reproducible: Always
User Profile Reset: No
Additional Info:
LIbreOffice version 24.8.1.2
Build
https://git.libreoffice.org/core/+log/87fa9aec1a63e70835390b81c40bb8993f1d4ff6
Jpeg and spreadsheet attached.
--
You are receiving this mail because:
You are the assignee for the bug.
