<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Named Ranges in Excel form controls are dropped on open (FILEOPEN)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=113680">113680</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Named Ranges in Excel form controls are dropped on open (FILEOPEN)
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>3.3.0 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>parody@esglabs.com
</td>
</tr></table>
<p>
<div>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>