https://bugs.documentfoundation.org/show_bug.cgi?id=165370
Bug ID: 165370
Summary: Calc solver doesn't update cell reference after adding
lines
Product: LibreOffice
Version: 24.8.5.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
LibreOffice Calc Solver (Tools->Solver) doesn't update cell references. When
there are cell references inside the sheet, even if they are locked like
`=$B$4`, the reference gets updated after a line is added.
Steps to Reproduce:
1. Create a new sheet
2. Enter a expression in B4 like `=B1+B2`
3. Add a reference to B4 in D1 like `=$B$4`
4. Open Solver (Tools->Solver), set target to B4, add some conditions and solve
5. Add some lines before line 4
6. Notice that the reference in D1 got updated and is now `=$B$7`
7. Open the solver again. Notice that target still references `$B$4` that is
now empty
8. Attempt to solve
Actual Results:
1. The references in solver aren't updated.
2. Attempting to solve with an empty target (without any expression) will
produce a null result.
Expected Results:
1. The references in solver should also be updated
2. Solver should show an error or warning if there is no expression in the
target cell instead of producing a null result
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 24.8.4.2 (X86_64) / LibreOffice Community
Build ID: 480(Build:2)
CPU threads: 8; OS: Linux 6.12; UI render: default; VCL: gtk3
Locale: pl-PL (fr_FR.UTF-8); UI: fr-FR
Debian package version: 4:24.8.4-4
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
