Issue 68932

Summary: Spellchecker not working for doc loaded in Calc
Product: General Reporter: t_kasi <thomas.kashofer>
Component: spell checkingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, rainerbielefeld_ooo_qa
Version: 3.3.0 or older (OOo)Keywords: oooqa
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Calc with German sentences (Richtig=correct, Falsch=wrong)
none
Row 7 - entry exists in saved file, Row 19 - typed in after doc was loaded none

Description t_kasi 2006-08-24 16:36:06 UTC 
Prereq.:
I created a document (.ods file) containing various sentences.
I put them in ONE cell, and also distributed them accross various cells (one
sentence each).

Actions:
In OO.org "writer" (as .odt file) the wrong words (same sentences!) get found
--> red underthingy. It also works fine with "impress".
When I load the document into "calc", Spellchecker is ON --> nothing gets found.
When I now enter the SAME sentence into a cell and hit return --> bingo, red
underthingy appears and I can correct the word.

I used Language German by the way.
This shappens on Windows XP Pro with OpenOffice v2.0 as well as on Linux
(kubuntu sid) with OpenOffice v2.0.3.
Comment 1 ace_dent 2006-10-16 06:21:54 UTC 
Please attach example Document(s) demonstrating this problem. Cheers.
Comment 2 t_kasi 2006-11-06 17:26:48 UTC 
Created attachment 40373 [details]
Calc with German sentences (Richtig=correct, Falsch=wrong)
Comment 3 t_kasi 2006-11-06 17:49:20 UTC 
Created attachment 40375 [details]
Row 7 - entry exists in saved file, Row 19 - typed in after doc was loaded
Comment 4 Rainer Bielefeld 2007-01-25 11:46:51 UTC 
I was able to reproduce the problem.

Steps to reproduce:
1. Open "Testdocument-012-Calc_singleWords.ods", activate "Automatic Spellcheck"
   if required.
2. Mark 'A6:A16'
   comment: for this the wrong language "English" is selected
3. Menu 'Edit - Copy'
4. Open new WRITER document (Standard language "German"), activate "Automatic 
   Spellcheck" if required.
5. Menu "Edit - Paste Special - As RTF"
6. Click into first cell of the table and press 2 times <cntrl>+<a> to mark
   all text
7. Menu "Format - Characters" to change language to "German", if required
8. Menu 'Edit - Copy'
9. Change to "Testdocument-012-Calc_singleWords.ods"
10. Dobleclick into cell 'B1'
11.  Menu 'Edit - Paste'
     Contents will all be inserted into one cell 'B1'
     Expected: misspelled words should still be underlined red
     Actual: no underlining, no spellcheck (after doubleclick into cell and F7)

I did not find any way how to "repair" the spell checking for that text. When I
add Text from 'A6' to the end of contents of 'B1' (Doubleclick 'A6', mark all,
copy, (Doubleclick'B1', paste) spellcheck works for those few words. 
No Idea what the reason for that problem might be.

I got a similar result when I copied 'A6:A16' to 'B2' with "Paste Special - AS
RTF"; no language selected and so no spell check. But here I only had to click
the cell and change language for whole cell to "German", then spell checker
worked as expected.
Comment 5 Rainer Bielefeld 2007-01-25 18:01:55 UTC 
Forgot to mention: I checked with "2.0.2  German version WIN XP:
[680m5(Build9011)]"