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.
*** Bug 75839 has been marked as a duplicate of this bug. ***
reproducible with LO 4.2.1.1 (Win 8.1)
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...
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (4.4.3 or later) https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results; 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2015-06-08
LibreOffice 4.4.3.2 is behaving a bit differently but this bug is essentially still there if you follow the steps mentioned. It seems like the spell check doesn't work correctly after switching a cell's language.
*** Bug 99409 has been marked as a duplicate of this bug. ***
Still reproducible in LibreOffice Calc 5.2.3.3.
*** Bug 76714 has been marked as a duplicate of this bug. ***
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
Still reproducible in LibreOffice 6.0.3.2.
The problem still exists in LibreOffice 6.2.3.2. I'm not seeing all the nuances described in the original report, but the basic problem remains that changing a cell's language does not cause the automatic spelling correction underlines to change.
It works for me. Version: 6.3.6.2 (x64) Build ID: 2196df99b074d8a661f4036fca8fa0cbfa33a497 CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; Locale: fr-FR (en_US); UI-Language: en-US Calc: threaded