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.

Reply via email to