https://bugs.documentfoundation.org/show_bug.cgi?id=156814
Bug ID: 156814
Summary: Imported solver models should not display the sheet
name when they're in the same sheet
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]
When you create a solver model in Excel and import it into Calc, the sheet
names are used to display the addresses even when the model belongs to the
shame sheet.
For instance, see the attached image. The solver model belongs to a sheet named
"Transporte" and the imported model in Tools - Solver dialog shows range
addresses as $Transporte.$J$18 i.e. starting with the sheet name.
This is not necessary since the model is in a sheet with the same name.
Moreover, models created within LO Calc won't add this unnecessary sheet name.
So in summary, for a sheet containing a solver model, all addresses referring
to the same sheet should not display the sheet name as prefix.
This happens in LO 7.6+
--
You are receiving this mail because:
You are the assignee for the bug.