Issue 112345 - Cell's Format Code fails when auto spell check active
Summary: Cell's Format Code fails when auto spell check active
Alias: None
Product: Calc
Classification: Application
Component: formatting (show other issues)
Version: OOO320m12
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2010-06-13 16:17 UTC by tommyk
Modified: 2013-01-29 21:49 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Further details and example of Format Code bug (9.55 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-06-13 16:19 UTC, tommyk
no flags Details
Please see comments from rainerbielefeld Sun Jun 13 18:01:58 (58.52 KB, application/vnd.oasis.opendocument.spreadsheet)
2010-06-13 19:03 UTC, Rainer Bielefeld
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description tommyk 2010-06-13 16:17:11 UTC
If a text-formatted cell (e.g. one with a Format Code based on the "@" code) is
drawn to the attention of the spell checking subsystem, and a spelling error is
spotted but not corrected, then after the spell check has completed, control
appears not to pass back to the formatting mechanisms for final display of the
cell according to the format code. The result is the cell is displayed
incorrectly. It seems possible that a text cell with an uncorrected error gets
displayed using only the default "General" Format Code, and not the chosen
text-based code.

For example. Assume a cell is formatted with Format Code: @ "-----"
(Note, that is the nine-character string starting with the @ character,
including one space character, and ending with the second double-quote character.)

Assume "Check spelling as you type" is active, and assume at least one spell
check dictionary is enabled. Then the following shows how we'd expect two
different strings to be displayed and then how they are actually displayed under
the bug:

Example 1 (Correct spelling, no bug)
      Entered as: ostentatious
Expected display: ostentatious -----
  Actual display: ostentatious -----

Example 2 (Incorrect spelling, detected but uncorrected, bug displayed)
      Entered as: ostintatious
Expected display: ostintatious -----
  Actual display: ostintatious
Comment 1 tommyk 2010-06-13 16:19:10 UTC
Created attachment 69957 [details]
Further details and example of Format Code bug
Comment 2 Rainer Bielefeld 2010-06-13 19:01:58 UTC
Reproducible with "Ooo 3.1.1 WIN XP DE[OOO310m19 (Build 9420)]" and with
"Ooo-Dev 3.3 multilingual version English UI WIN XP: [DEV300m82 (Build 9510)]".
Works fine with "2.4.1  Multilingual version English UI WIN XP: [680m17(Build9310)]"

You can see the effect switching on/off auto spell check in my attached
Comment 3 Rainer Bielefeld 2010-06-13 19:03:29 UTC
Created attachment 69960 [details]
Please see comments from rainerbielefeld Sun Jun 13 18:01:58