LibreOffice changes typographic quotes to dummy quotes

[CannedMan]

I am trying to get a specific error message printed. English works fine:

Code: Select all

=KJED.SAMAN("Language mismatch (check ‘"&$Start.B5&"’, ‘"&$Start.B7&"’ and ‘"&$Start.E7&"’)")

(kjed.saman = concatenate)

However, doing the same for Norwegian does not work. The only difference is that the two quotes (‘/’) are replaced with guillemetes («/»), and whichever way I choose to input them, they get replaced by typewriter quotes ("/") after I press Enter or click the accept function button (which I yesterday did for the first time since my days of Microsoft Works). The same thing happens irregardless of whether autoreplace is on or off (under localised options) and whether or not spellcheck is on. How can I get Calc to accept my typographic quotes as characters and not replace them?

I have tried both of these:

Code: Select all

=KJED.SAMAN("Manglande språksamsvar (sjekk «"&$Start.B5&"», «"&$Start.B7&"» og «"&$Start.E7&"»)")
=KJED.SAMAN("Manglande språksamsvar (sjekk «";$Start.B5;"», «";$Start.B7;"» og «";$Start.E7;"»)")

Neither work.

[John_Ha]

A hack - try setting UK English for the sentence you want printed.

[Villeroy]

109471.ods

(8.55 KiB) Downloaded 124 times

works for me

[CannedMan]

So this is what I did:

1. I selected both cells with Norwegian text
2. I pressed Ctrl+1
3. I changed their language to UK English
4. I edited the first cell to include guillemets
5. I pressed Enter
6. The cell reverted back to typewriter quotes

The hack unfortunately didn’t work for me. Maybe I did something wrong? My installation is set to Norwegian Nynorsk. The document’s standard style is set to English (as much of the document is in English. Some styles are specifically Norwegian. Doing the manual formatting as listed above unfortunately did not, as stated, solve the issue.