<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 - EDITING: Hide and omit single quote before equal sign at start of cell string (escape formula recognizer like number recognizer)"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=119646">119646</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>EDITING: Hide and omit single quote before equal sign at start of cell string (escape formula recognizer like number recognizer)
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.0.3 release
</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>enhancement
</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>gekacheka@yahoo.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
A single quote may be used to avoid autorecognizing numbers, so they may be
stored as strings (for example to preserve leading zeros). This single quote
is hidden in the cell, but shown in the editing field.
Currently, this does not work for string values that start with an equal sign.
If the single quote is omitted, then the formula recognizer fails and an error
is produced. (Exception: a single character string consisting of the equal
sign character.) Good.
If the single quote is included as a prefix before the equal sign, then the
single quote is shown in the cell and included in the string value. Bad.
Steps to Reproduce:
STEPS TO REPRODUCE:
Type or paste the following three characters into a cell
'==
Actual Results:
ACTUAL: cell value is string
'==
(Can verify value contains the single quote ' by exporting to csv or other
format.)
Expected Results:
EXPECT: cell value is string
==
(Can verify value omits the single quote ' by exporting to csv or other
format.)
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 6.1.0.3 (x64)
Build ID: efb621ed25068d70781dc026f7e9c5187a4decd1
CPU threads: 2; OS: Windows 6.1; UI render: default;
Locale: en-US (en_US); Calc: group threaded</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>