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

[bugzilla-daemon]

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

Adolfo Jayme  changed:

   What|Removed |Added

 Whiteboard||target:7.3.0
 Status|NEW |RESOLVED
   Assignee|libreoffice-b...@lists.free |stevemfanning...@gmail.com
   |desktop.org |
 Resolution|--- |FIXED

--- Comment #10 from Adolfo Jayme  ---
https://git.libreoffice.org/help/+/a79ac40adfad119a8957200defabe16282ea5204%5E%21

-- 
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

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

[bugzilla-daemon]

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

--- Comment #9 from Steve Fanning  ---
Created attachment 173041
  --> https://bugs.documentfoundation.org/attachment.cgi?id=173041=edit
Suggested text to be added to Text Functions help page

The attached Writer file contains a proposed new section that could be added at
the top of the relevant help page (text/scalc/01/04060110.xhp).

-- 
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

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

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

 Blocks|80430   |


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=80430
[Bug 80430] [META] LOCALHELP: Features x Documentation gap
-- 
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

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

[bugzilla-daemon]

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

Olivier Hallot  changed:

   What|Removed |Added

 Depends on||80430


Referenced Bugs:

https://bugs.documentfoundation.org/show_bug.cgi?id=80430
[Bug 80430] [META] LOCALHELP: Features x Documentation gap
-- 
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

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

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

 Status|REOPENED|NEW

-- 
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

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

[bugzilla-daemon]

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

Dan Dascalescu  changed:

   What|Removed |Added

 Status|RESOLVED|REOPENED
 Resolution|NOTABUG |---

--- Comment #8 from Dan Dascalescu  ---
The bug was to document at https://help.libreoffice.org/Calc/Text_Functions how
to escape double quotes. Reopening.

-- 
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

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

[bugzilla-daemon]

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

m.a.riosv  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |NOTABUG

--- Comment #7 from m.a.riosv  ---
Resolved as not a bug, please if you are not agree reopen it.

-- 
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

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

[bugzilla-daemon]

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

m.a.riosv  changed:

   What|Removed |Added

 CC||miguelangelrv@libreoffice.o
   ||rg

--- Comment #6 from m.a.riosv  ---
Created attachment 137929
  --> https://bugs.documentfoundation.org/attachment.cgi?id=137929=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"(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.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1

--- Comment #5 from Buovjaga  ---
(In reply to Buovjaga from comment #3)
> (In reply to Eike Rathke from comment #2)
> > For the example given here it should be
> > =SUBSTITUTE(A1, """foo""", "bar")
> 
> Dan: does this work for you? I just get the contents of A1 again (I already
> tried this variant before making my comment 1.

My problem was because I had autocorrected typographic quotes in the string:
”foo”

-- 
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

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

[bugzilla-daemon]

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

--- Comment #4 from Dan Dascalescu  ---
Doubling the double quote works. Thank you.

My request is to add how to properly escape double quotes to the documentation
for text functions at 
https://help.libreoffice.org/Calc/Text_Functions, since it's clearly not
obvious, as the discussion about four double-quotes in this ticket proves.

-- 
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

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

[bugzilla-daemon]

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

--- Comment #3 from Buovjaga  ---
(In reply to Eike Rathke from comment #2)
> For the example given here it should be
> =SUBSTITUTE(A1, """foo""", "bar")

Dan: does this work for you? I just get the contents of A1 again (I already
tried this variant before making my comment 1.

-- 
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

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

[bugzilla-daemon]

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

--- Comment #2 from Eike Rathke  ---
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.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

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

[bugzilla-daemon]

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

Buovjaga  changed:

   What|Removed |Added

 CC||todven...@suomi24.fi

--- Comment #1 from Buovjaga  ---
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
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs