Bug 98154 - Some Autocorrect options should be treated separately in Calc
Summary: Some Autocorrect options should be treated separately in Calc
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
: 100038 (view as bug list)
Depends on:
Blocks: AutoCorrect-Complete
  Show dependency treegraph
Reported: 2016-02-24 18:53 UTC by Stéphane Aulery
Modified: 2018-11-04 23:48 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Stéphane Aulery 2016-02-24 18:53:18 UTC
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

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

Comment 1 tommy27 2016-02-25 06:36:15 UTC
valuable enhancement request. status NEW.
Comment 2 Eike Rathke 2016-05-31 11:59:18 UTC
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, ...
Comment 3 Eike Rathke 2016-05-31 11:59:51 UTC
*** Bug 100038 has been marked as a duplicate of this bug. ***
Comment 4 Buovjaga 2016-10-21 18:47:41 UTC Comment hidden (obsolete)
Comment 5 Buovjaga 2016-10-22 07:53:41 UTC Comment hidden (obsolete)
Comment 6 V Stuart Foote 2016-10-22 23:20:04 UTC Comment hidden (obsolete)