https://bugs.documentfoundation.org/show_bug.cgi?id=126308
Bug ID: 126308
Summary: Escape character "'" (single quote) shows in final
cell output
Product: LibreOffice
Version: 6.2.4.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Steps to reproduce:
* Open LO Calc.
* Write something that would evaluate to a date, format, or formula, prefixing
it with escape character "'" (single quote) at the beginning so that it would
interpret it as raw text. E.g. "'2019-01-33", or "'*not_bold*".
* Press enter
Expected behavior: should show the text after the "'" as simple text, without
trying to evaluate it to date/format/etc.
Actual behavior: depending on whether it's written from scratch or not, it
might respect the "'" escape character, but will end up showing it in the cell
(i.e. while MS Excel will show "2019-01-33", Calc will show "'2019-01-33"), or
in some cases when there was something there from before, will ignore the "'"
and evaluate anyway.
--
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
