https://bugs.documentfoundation.org/show_bug.cgi?id=113976
Buovjaga <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |[email protected]
--- Comment #1 from Buovjaga <[email protected]> ---
I was unable to achieve this.
According to this: https://wiki.documentfoundation.org/EscapingCharacters we
express a single double quote by 4 double quotes in a row. Apparently this is
the same in Excel.
I also found information that you can use CHAR(34) to express the double quote.
I tried:
=SUBSTITUTE(A1;"CHAR(34)fooCHAR(34)";"bar")
But it just gives me the contents of A1 unchanged.
I get the same result with 5 double quotes in a row:
=SUBSTITUTE(A1;"""""foo""""";"bar")
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
