https://bugs.documentfoundation.org/show_bug.cgi?id=156815
Bug ID: 156815
Summary: Renaming a sheet should update ranges in solver models
Product: LibreOffice
Version: 7.6.0.2 rc
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
In solver models that reference cells from other sheets, renaming the
referenced sheet should update the cell address in the original model.
Steps to reproduce
1) Create a Calc file with 2 sheets "Sheet1" and "Sheet2"
2) In "Sheet1" go to Tools - Solver and set the target cell to some cell in
"Sheet2"
3) Notice that the address will be something like $Sheet2.$E$20 (i.e. starting
with "Sheet2" to indicate that the cell is in another sheet; close the Solver
dialog
4) Now rename "Sheet2" to some other name, f.i. "NewName"
5) Go back to "Sheet1" (where the model was created) open the Solver dialog and
notice that the target cell is still $Sheet2.$E$20
Expected result
The target should have been updated to $NewName.$E$20
This problem happens since LO 7.6+
--
You are receiving this mail because:
You are the assignee for the bug.
