Ask Your Question


asked 2020-08-02 16:13:29 +0100

a1istair gravatar image

updated 2020-08-05 11:42:26 +0100

blashrkh gravatar image

Please please please please please tell me what special kind of idiot thinks that having a default setting to automatically style quote marks is a good idea in a formula based program?

edit retag flag offensive close merge delete


What is your question? An enquiry about design decision or a request for a workaround?

ajlittoz gravatar imageajlittoz ( 2020-08-02 16:41:09 +0100 )edit

Every design decision is made based on wishes of users, and on current perception of UX people on the ratio between proponents and opponents, and on other considerations like ease of discoverability of the option in question for both groups.

Every decision is a compromise; every may be not optimal, and may be reviewed and changed - and there is the bug tracker (where enhancement requests are tracked, too) for that.

But every time I read something like what is posted here as a "question", I know I am reading something that only a special kind of idiot, who truly believes to know The Ultimate Truth, might write.

Mike Kaganski gravatar imageMike Kaganski ( 2020-08-02 17:04:25 +0100 )edit
  1. just look around, there might be an option to change it as you wish to have it,
  2. please learn to ask in an appropriate gentle manner, you will surely get better answers ...
newbie-02 gravatar imagenewbie-02 ( 2020-08-02 23:39:47 +0100 )edit

Every design decision is made based on wishes of users

Every? Really? Show me the user(s) whose wishes were behind the notorious Personal label in pre-7.0 builds!

gabix gravatar imagegabix ( 2020-08-03 08:31:19 +0100 )edit

@gabix: That was not a design decision, but marketing. Please don't throw irrelevant comments.

Mike Kaganski gravatar imageMike Kaganski ( 2020-08-03 08:59:00 +0100 )edit

an architectural decision? I must admit I was concerned when I saw "Personal Edition" -- about the future of LO.

blashrkh gravatar imageblashrkh ( 2020-08-05 11:38:08 +0100 )edit

@blashrkh: another offtopic comment. There's a dedicated question for that, not here.

Mike Kaganski gravatar imageMike Kaganski ( 2020-08-05 11:45:08 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-08-03 01:38:26 +0100

Earnest Al gravatar image

I find the tone of the "question" disagreeable, and disrespects those people who have done so much work to bring LO to where it is today. I first came across this issue years ago copying formulae from Word (automatically changes quotes to curly quotes) to Excel, since then I have been aware of the issue.

Incidentally, in Calc within a formula (starting with =) the quotes don't appear to change to curly quotes even if the Autocorrect option is set to change them.

When making a new installion of LO on a computer one of the first things I do is: in the menu (of Calc or Writer, it doesn't matter) click Tools > Autocorrect > Autocorrect Options..., in the window that opens in the Replace tab select the default language of your douments, in my case "English (UK)", then click on the tab Localized Options and untick Single Quotes and Double Quotes, OK out. This solves the problem for Calc

If I need curly quotes for Writer then I have another option as long as I have the Lightproof Grammar Checker (English) installed, which often comes with Windows installation but otherwise see extension . In menu click Tools > Options in the windows that opens under Language Settings > Writing Aids check that Lightproof Grammar Checker (English) is ticked. In Language Settings > English Sentence Checking under Punctuation tick the box Quotation Marks (and Apostrophe too). Straight quotation marks will be marked with a blue wavy underlineindicating a grammar error, right-clicking will give an option to replace with curly quotes.

Happily, these settings have remained as set by me through multiple upgrades of LibreOffice. Cheers, Al

edit flag offensive delete link more
Login/Signup to Answer

Question Tools



Asked: 2020-08-02 16:13:29 +0100

Seen: 106 times

Last updated: Aug 03 '20