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@lists.freedesktop.org
Reporter: ddascalescu+freedesk...@gmail.com
CC: olivier.hal...@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.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs