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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
