<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 - Entering "-" in a cell formatted as text puts Calc into formula-entering mode"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=132026">132026</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Entering "-" in a cell formatted as text puts Calc into formula-entering mode
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.3.4.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>FreeBSD
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>minor
</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>list1@gjunka.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
There should be a way to disable auto-entering formulas in Calc, similar to
disabling auto correction. Currently entering dash "-" or plus "+" and trying
to move to the next cell triggers a formula-entering mode. This behavior
persists even for cell explicitly formatted as text.
Without such option it's impossible to enter dash in a few adjacent cells
without workarounds, i.e. after entering "-" to press Enter, which moves cursor
to the cell below, then cursor Up and Right (4 strokes instead of 2).
Raised originally here:
<a href="https://ask.libreoffice.org/en/question/237810/how-to-disable-formulas/">https://ask.libreoffice.org/en/question/237810/how-to-disable-formulas/</a>
When I enter "-" or "+" into a cell and press cursor right to move to the next
cell LibreOffice thinks that I am starting to write a formula and automatically
highlights the cell I moved into. I formatted all cells as text but it doesn't
change this behavior. Is there a toggle that prevents this, similar to Auto
correction?
Steps to Reproduce:
1. Enter "-"
2. Press cursor right
Actual Results:
Formula entering mode.
Expected Results:
Cursor moved to the next cell.
Reproducible: Always
User Profile Reset: No
Additional Info:
The software should not enter into formula enter mode when the cell is
formatted as text (menu Format -> Cells...) or should provide an option to
disable this behavior, similar to disabling auto correction.</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>