Bug 74987 - EDITING: Language None attribute in calc does not disable spellchecking
Summary: EDITING: Language None attribute in calc does not disable spellchecking
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.5.3 release
Hardware: x86 (IA32) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2014-02-14 15:41 UTC by Rpnpif
Modified: 2018-10-15 18:04 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Rpnpif 2014-02-14 15:41:18 UTC 
Problem description: 
Affect Language None to cells does not disable spellchecking : unknown words for the default language of LO are underlined.

Steps to reproduce:
1. Enter an unknown word in French language in a cell. Default language of the sheet is French. The word is red underlined as expected.
2. Affect Format Cell with language None.
3. The word is ever red underlined even after saving and reopen the spreadsheet.

Expected behavior:
The word should not be underlined when the language is marked unknown.

Note that if the language None is affected to the cell before entering the unknown word, there are no bug : it is not underlined as it should be.

Note also that if I right click on the unknown word with "language none", no menu appear as expected (perhaps another bug). Then when I left-click in another cell, the word is no more underlined.

              
Operating System: Debian
Version: 4.2.0.4 release
Comment 1 Rpnpif 2014-02-14 15:53:50 UTC 
(In reply to comment #0)

> Note also that if I right click on the unknown word with "language none", no
> menu appear as expected (perhaps another bug). Then when I left-click in
> another cell, the word is no more underlined.

But after saved and reopened, the bug is yet present.
Comment 2 tommy27 2014-02-15 17:23:18 UTC 
how do you set language "none" ?
Comment 3 Rpnpif 2014-02-17 09:53:14 UTC 
(In reply to comment #2)
> how do you set language "none" ?

Select Cell(s).
Menu Format, Cells, Font.
Comment 4 tommy27 2014-02-17 14:17:27 UTC 
reproducible in LibO 4.1.5.3 under Win764bit
platform ALL status NEW

I add Calc expert to CC list
Comment 5 Joel Madero 2014-02-26 03:12:22 UTC 
New as Tommy has confirmed
Comment 6 Rpnpif 2014-09-01 05:17:36 UTC 
(In reply to comment #1)
> > Note also that if I right click on the unknown word with "language none", no
> > menu appear as expected (perhaps another bug). Then when I left-click in
> > another cell, the word is no more underlined.
> 
> But after saved and reopened, the bug is yet present.

No need to reopen, when the window display is refreshed, the underlines appear again.

Still in LO 4.3.1.2.
Comment 7 rpr 2015-01-03 00:56:19 UTC 

*** This bug has been marked as a duplicate of bug 82091 ***
Comment 8 Rpnpif 2015-01-06 15:53:53 UTC 
Hi,

It is strange that this bug has be marked as a duplicate of a bug more recent.
Comment 9 Joel Madero 2015-01-06 17:41:39 UTC 
Yeah - just the other bug already had quite a bit of triage activity so it was easier to just mark this one as a duplicate. But I updated the version on that bug to reflect the same as this one. Thanks for reporting!
Comment 10 Buovjaga 2018-10-15 18:04:59 UTC 
This was not actually a duplicate, but good news: I could repro with 4.3.0, but not with master. I will close as WFM

Version: 6.2.0.0.alpha0+ (x64)
Build ID: d9ad59da50c1172fe98f94370221c9c1b688200a
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2018-10-09_01:03:44
Locale: fi-FI (fi_FI); Calc: threaded