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

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #2 from Eike Rathke <erack at redhat.com> ---
4 double quotes is nonsense. In any literal string in formula expressions, a
double quote is escaped by doubling it. The 4 quotes in the example are a
literal string containing *one* quote, i.e. the enclosing double quotes and in
the middle the escaped double quote.

For the example given here it should be
=SUBSTITUTE(A1, """foo""", "bar")

-- 
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/20171122/cc33ef78/attachment.html>