[Libreoffice-bugs] [Bug 113680] New: Named Ranges in Excel form controls are dropped on open (FILEOPEN)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=113680

            Bug ID: 113680
           Summary: Named Ranges in Excel form controls are dropped on
                    open (FILEOPEN)
           Product: LibreOffice
           Version: 3.3.0 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: parody at esglabs.com

Description:
When you open an Excel document containing a Combo Box form control with an
Input Range or Cell Link set to a named range, that named range is dropped and
the control is broken.

Steps to Reproduce:
1. In Excel, create a document with a combo box form control, a named range for
values in the combo box, and a named cell for its target.
2. Set that form control's "Input range" or "Cell link" to a named range/cell
(as appropriate).
3. Pick something from the combo box and see that it shows the right items and
changes the correct cell.
3. Save the file.
4. Open it in LibreOffice.
5. Observe that the combo box doesn't show the correct range and/or update the
correct cell.


I'll provide a sample document assuming I can attach one after creating the
bug.

Actual Results:  
If the "Input range" is set to a name, the range disappears and the combo box
is empty.

If the "Cell link" is set to a name, the link disappears and the combo box
doesn't change the desired cell.

Expected Results:
Combo box still works.


Reproducible: Always


User Profile Reset: No



Additional Info:
I tested with 5.3.6.1, but first reported this issue in OpenOffice.org 2.0.2.


Version: 5.3.6.1
Build ID: 686f202eff87ef707079aeb7f485847613344eb7
CPU Threads: 8; OS Version: Windows 6.2; UI Render: GL; Layout Engine: new; 
Locale: en-US (en_US); Calc: group


User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML,
like Gecko) Chrome/61.0.3163.102 Safari/537.36 Vivaldi/1.93.955.48

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171106/09a2e914/attachment.html>