[Libreoffice-bugs] [Bug 126308] New: Escape character "'" (single quote) shows in final cell output

[bugzilla-daemon at bugs.documentfoundation.org]

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: libreoffice-bugs at lists.freedesktop.org
          Reporter: david.cortes.rivera at gmail.com

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190709/f9084bce/attachment.html>