Quotation marks used in Calc formula is Double universal.
Quotation marks used in Calc cell content, entered by keyboard, is English double.
Is that correct ?
Hello,
check setting Tools -> AutoCorrect Options...-> Tab: Localized Options -> Double Quotes: [x] Replace - this setting replaces " by typographical conventions in your locale (and may be also dependent to your font being used). From my perspective a questionable default setting in a spreadsheet application.
In LibreOffice, as default, when you type a (neutral) quotation mark (Unicode U+0022 ")¹ it is replaced by a left or right double quotation mark (Unicode U+201c “ and U+201d ”),² one or the other is chosen depending on whether or not there is a character to the left.
To revert the autocorrection for a single instance, press Ctrl+Z (Edit - Undo) after typing the quotation mark.
¹ https://www.unicode.org/charts/PDF/U0000.pdf
² https://www.unicode.org/charts/PDF/U2000.pdf
Tested with LibreOffice 6.4.7.2 (x86); OS: Windows 6.1.
Dear @anon73440385,
Dear @LeroyG,
Thank you for your answer, comment and explanation.
I use
=CONCAT("ThisComponent.CurrentController.ActiveSheet.getCellByPosition(",A2,", ",B2,").String = ","""",C2,"""")
instead in order to keep everything as default.
=CONCAT("ThisComponent.CurrentController.ActiveSheet.getCellByPosition(";A2;"; ";B2;").String = ";C2)
works for me, no matter if C2: is “Hello” or "Hello".
Note that I use semicolon instead of comma to separate arguments.