https://bugs.documentfoundation.org/show_bug.cgi?id=163538
Bug ID: 163538
Summary: CALC References not renumbered on row deletion
24.2.5.2
Product: LibreOffice
Version: 24.2.5.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have A2=A2+1, etc. So A238=A237+1. I delete row 237. Now new A237 (former
A238) is #REF instead of A236+1.
The installed version is LibreOffice 24.2.5.2.
Steps to Reproduce:
1.Have a reference to previous row (eg A238 ref's A237)
2.Delete previous row (eg A237)
3.Reference is not updated to row before previous row (eg new A237 (former
A238) should ref A236 but now says #REF)
Actual Results:
eg A237 now holds #REF instead of the formula A236+1
Expected Results:
eg A237 should hold A236+1
Reproducible: Always
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
--
You are receiving this mail because:
You are the assignee for the bug.
