[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

m.a.riosv <miguelangelrv at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |miguelangelrv at libreoffice.o
                   |                            |rg

--- Comment #6 from m.a.riosv <miguelangelrv at libreoffice.org> ---
Created attachment 137929
  --> https://bugs.documentfoundation.org/attachment.cgi?id=137929&action=edit
Sample showing no bug

I think the issue is with the search text not having double quotes as such but
as delimiters.

A1=CHAR(34)&"foo"&CHAR(34) = "foo"
=SUBSTITUTE(A1;"""foo""";"""bar""";1) = "bar"
A1="""foo""" = "foo"
=SUBSTITUTE(A1;"""foo""";"""bar""";1) = "bar"

It works as @Eike indication.

-- 
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/327688e0/attachment.html>