From: Julian Gilbey <jdg@debian.org>
To: Debian bug reports <submit@bugs.debian.org>
Subject: libreoffice-calc: autocorrect option for replacing quotes should be treated separately in calc
Date: Fri, 7 Oct 2011 00:06:59 +0100

Package: libreoffice-calc
Version: 1:3.4.3-1
Severity: wishlist

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
formulae).

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
LibreOffice Calc".

   Julian