Bug 75838 - FORMATTING: Red underline by spell checker is broken if you change the (cell) language
Summary: FORMATTING: Red underline by spell checker is broken if you change the (cell)...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Spreadsheet (show other bugs)
Version: unspecified
Hardware: Other All
: medium normal
Assignee: Not Assigned
QA Contact:
URL:
Whiteboard:
Keywords:
: 75839 (view as bug list)
Depends on:
Blocks:
 
Reported: 2014-03-06 12:54 UTC by Jonas Müller
Modified: 2014-05-13 08:13 UTC (History)
0 users

See Also:
i915 platform:
i915 features:


Attachments
ODS file (14.88 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-03-06 12:54 UTC, Jonas Müller
Details

Description Jonas Müller 2014-03-06 12:54:06 UTC
Created attachment 95226 [details]
ODS file

This is using german spell check by default, I don't know if this is different with another default language:

1. Open Example2.ods
2. As you can see a lot of the English text in Cell A1 is marked with a red underline. That is because the language of this Cell is German.
3. Highlight A1 and press Strg + 1 to go into the „format cell“ menu.
4. Go to „font“ and change the language to „English (UK)“
5. As you can see the English text still has a red underline despite having the correct language now. This is incorrect.
6. Now Highlight A1 and press F2 to edit the Cell.
7. As you can see now the German text get's a red underline. This is correct.
8. Press Esc to leave edit mode. Now the English text has a red underline again. This is incorrect.
9. This bug persists even if you Save & Close the file.
10. Now make a right click on A1 to enter edit mode.
11. As you can see now the red underline is & stays correct.

In short:

If you change a cell's language it doesn't show.
Comment 1 Joel Madero 2014-03-06 23:59:32 UTC
*** Bug 75839 has been marked as a duplicate of this bug. ***
Comment 2 A (Andy) 2014-03-08 09:48:27 UTC
reproducible with LO 4.2.1.1 (Win 8.1)
Comment 3 Jonas Müller 2014-05-13 08:13:34 UTC
The bug is still in LibreOffice  4.2.4.

In my opinion this is a really serious bug as it makes it really difficult to work with text of a different language in a spreadsheet. It looks really ugly when you have a whole spreadsheet full with red underlines despite making no mistakes.

The spell check features was always the one feature where LibreOffice Calc is so much better than MS Excel and I've always recommended it to colleagues if only for this feature...


Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.