Issue 112345

Summary: Cell's Format Code fails when auto spell check active
Product: Calc Reporter: tommyk <tommy.kelly>
Component: formattingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P4 CC: issues, rainerbielefeld_ooo_qa
Version: OOO320m12Keywords: oooqa
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Further details and example of Format Code bug
none
Please see comments from rainerbielefeld Sun Jun 13 18:01:58 none

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