[Libreoffice-bugs] [Bug 132026] New: Entering "-" in a cell formatted as text puts Calc into formula-entering mode

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 132026
           Summary: Entering "-" in a cell formatted as text puts Calc
                    into formula-entering mode
           Product: LibreOffice
           Version: 6.3.4.2 release
          Hardware: All
                OS: FreeBSD
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: list1 at gjunka.com

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:
https://ask.libreoffice.org/en/question/237810/how-to-disable-formulas/

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.

-- 
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/20200410/26a32fed/attachment.htm>