<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 - No color highlighting of reference if it contains sheet name in single quotes (with spaces)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=114113">114113</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>No color highlighting of reference if it contains sheet name in single quotes (with spaces)
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>Inherited From OOo
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>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>mikekaganski@hotmail.com
</td>
</tr>
<tr>
<th>CC</th>
<td>erack@redhat.com
</td>
</tr></table>
<p>
<div>
<pre>When a reference in a spreadsheet formula contains the sheet name in single
quotes (e.g., when the sheet name contains spaces), the reference isn't
color-highlighted.
Steps to reproduce:
1. In a new spreadsheet, in the default sheet (Sheet1), enter "=Sheet1.A2" to
A1.
2. After reentering the formula bar of A1, see that A2 is highlighted with blue
(both the cell itself, and its name in formula bar).
3. Now rename the sheet to "Sheet 1" (add space between "Sheet" and "1").
4. Reenter A1 formula bar; notice that the formula now looks like "='Sheet
1'.A2".
Expected result: A2 should be highlighted, as at step 2.
Actual: A2 isn't highlighted, neither on spreadsheet, nor in formula bar.
Reproducible with Version: 6.1.0.0.alpha0+ (x64)
Build ID: 401a3d2336bf46b38235c498ff86ff675d0de759
CPU threads: 4; OS: Windows 10.0; UI render: default;
Locale: ru-RU (ru_RU); Calc: CL
and also with OpenOffice.org 3.3.0
OOO330m20 (Build:9567)</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>