[Libreoffice-bugs] [Bug 113976] New: Document how to escape double quotes in text functions

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue Nov 21 16:51:41 UTC 2017


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

            Bug ID: 113976
           Summary: Document how to escape double quotes in text functions
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Documentation
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: ddascalescu+freedesktop at gmail.com
                CC: olivier.hallot at documentfoundation.org

Description:
I'm trying to SUBSTITUTE '"foo"' (including the double quotes) with "bar", but
I can't find out how to escape the double quotes.

https://help.libreoffice.org/Calc/Text_Functions#SUBSTITUTE isn't helpful.

Steps to Reproduce:
=SUBSTITUTE(A1, "\"foo\"", "bar")

Actual Results:  
Err:508

Expected Results:
A1 with '"foo"' replaced by "bar".


Reproducible: Always


User Profile Reset: No



Additional Info:
Quoting the search text using single quotes doesn't work.


User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/62.0.3202.89 Safari/537.36

-- 
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/20171121/74b73def/attachment.html>


More information about the Libreoffice-bugs mailing list