[Libreoffice-bugs] [Bug 119646] New: EDITING: Hide and omit single quote before equal sign at start of cell string (escape formula recognizer like number recognizer)

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 119646
           Summary: EDITING: Hide and omit single quote before equal sign
                    at start of cell string (escape formula recognizer
                    like number recognizer)
           Product: LibreOffice
           Version: 6.1.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: gekacheka at yahoo.com

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

-- 
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/20180902/0f913873/attachment.html>