From: Julian Gilbey <firstname.lastname@example.org>
To: Debian bug reports <email@example.com>
Subject: libreoffice-calc: autocorrect option for replacing quotes should be treated separately in calc
Date: Fri, 7 Oct 2011 00:06:59 +0100
The libreoffice AutoCorrect options contains an option to replace
Single and/or Double quotes with the appropriate open and close quote
marks. This is a very nice and helpful feature, which I happily use
when writing letters and the like.
However, when using calc to write a spreadsheet, I sometimes have a
need to use a quote mark to indicate that a number-looking thing
should be treated as text, for example '5. Unfortunately, the
autocorrect option then turns that quote into an open quote symbol,
which does not have the desired effect.
What calc appears to do is to use the autocorrect quote feature only
on cells which do not begin with "=" (i.e., which are not obviously
It would be great to have an option on the Autocorrect panel which
says something along the lines of "(do not) replace these quotes in
valuable enhancement request. status NEW.
The specific leading ' problem was fixed for bug 99930.
However, in general separate settings for Calc and Writer for some AutoCorrection items would be welcomed, e.g. URL recognition, two capitalized initial letters, ...
*** Bug 100038 has been marked as a duplicate of this bug. ***