[Libreoffice-bugs] [Bug 125600] New: Calc spellcheck does not recognize correct spelling

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=125600

            Bug ID: 125600
           Summary: Calc spellcheck does not recognize correct spelling
           Product: LibreOffice
           Version: 6.2.3.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: tdfpub70 at gmail.com

Description:
OS: Win 10 Home
OS Build: 17134.765
LibreOffice: Version: 6.2.3.2 (x64)
Build ID: aecc05fe267cc68dde00352a451aa867b3b546ac

I am producing an energy use calculator in LibreOffice Calc. The sheet makes
frequent use of standard acronyms such as KWh (kilowatt-hour). Every time this
acronym is used, Calc changes it to Kwh. (Both KWh and Kwh get a red underline
indicating a misspelling.) I tried to manually fix this several times by
entering the correct format directly in the input line. But Calc kept
reverting. Until I inadvertently typed Ctrl+Z. When I noticed this, I hit Enter
and the text stayed as I had typed it. However, KWh still had it's red line. I
then ran spell check and found that while it is identifying KWh as a misspelled
word, it also suggesting KWh as the correct spelling. I clicked Correct All and
the same problem remained. I tried this three times without success. I then
tried adding KWh to the dictionary. The first two times this did not work. On
the third attempt it... sort of worked. KWh still has the red line indicating a
misspelled word. However, running spell check no longer finds any problems.
Next, I saved the sheet in ODF and reopened it. Now all the identified
misspellings are gone.

Steps to Reproduce:
1. Type "KWh". Red line appears under "KWh"
2. Ran spell check. Acronym still identified as misspelling.
3. Clicked suggested correction "KWh".
4. Clicked "Correct All"
5. Closed Spell Check.
6. Reopened Spell Check and added KWh to the dictionary.
7. Saved document as a new doc and in the ODF fie format. (Original was based
on .csv)
8. Reopened the new doc and the red lines were gone.
9. Reran spell check. No identified misspellings.

Actual Results:
Spell check could not identify correct spelling of KWh even though it was
included in Spell Check's own suggestion box. Only saving the sheet as a new
doc resolved the problem.

Expected Results:
Spell Check should correctly identify misspelling and auto correct only when
there is a correct spelling entry in it's database. In addition, auto correct
should not be persistent. When I tell Spell Check to undo it's correction, it
should do as it's told.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.2.3.2 (x64)
Build ID: aecc05fe267cc68dde00352a451aa867b3b546ac
CPU threads: 8; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: en-US (en_US); UI-Language: en-US
Calc: CL

While filling out this bug report, I have opened and closed LibreOffice and the
relevant docs several times. Now I can no longer reproduce the error.
I am not sure if it is worth submitting this report or not.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190531/0102b1b2/attachment.html>