Description: LibreOffice Calc has a spellchecker. The spellchecker supports spreadsheets written in multiple languages. Unfortunately this feature is hidden behind an unobvious user interface. I expected to be able to set the language for selected cells via the Tools -> Language menu, but It currently only offers me to set the language "For all text". In order to set the language only for cells you selected I currently have to: 1. Right click 2. Select "Format Cells..." 3. Select "Font" 4. Find my language in the "Language" drop-down This is counterintuitive for multiple reasons: 1. After not finding an option to change the language in the Tools -> Language menu a user is likely to assume that this feature is not supported 2. Spell checking has little to do with formatting and even less to do with font Please add an option to set the language "For selected cells" to the Tools -> Language menu Steps to Reproduce: 1. Select a cell 2. Open the Tools -> Language menu Actual Results: See that it does not offer you an option to set the language only for cells you selected and keep the language for the rest of the spreadsheet the same Expected Results: I expected to see an option named "For selected cells" under the option named "For all text" Reproducible: Always User Profile Reset: No Additional Info: Version: 7.1.8.1 Build ID: 10(Build:1) CPU threads: 2; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: en-US (C.UTF-8); UI: en-US Calc: threaded I have found out about this hidden feature here https://ask.libreoffice.org/t/calc-how-do-i-set-the-language-for-a-selection-of-cells/35252
Hi Hexagon Version 7.5 of LibreOffice now makes it easier to reach that Font tab: use the Status bar's language menu, click "more". In previous versions, it would lead to the Languages section of the Options menu. Can you please test version 7.5 and report back? Thank you!
(In reply to Stéphane Guillou (stragu) from comment #1) > Hi Hexagon > > Version 7.5 of LibreOffice now makes it easier to reach that Font tab: use > the Status bar's language menu, click "more". That's an inaccurate description. "More" just goes to the same place as [CTRL]+[1] for the selected cells. If the latest-used tab was "Font", then you get to "Font", but if the latest was, say, "Number", then that's the tab you see. IOW, right-clicking on the status bar "Language", then navigating to "more" is just the same as [CTRL]+[1]. And the same as cell's right-click > Format Cells. [OT] And we lost the possibility to get to the general Language Options directly from the status bar, instead of adding a clear submenu item within that same status bar "language" right-click menu, among several alternative solutions. [/OT].
Dear hexagon-recursion, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Dear hexagon-recursion, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp
(In reply to ady from comment #2) > (In reply to Stéphane Guillou (stragu) from comment #1) > > Hi Hexagon > > > > Version 7.5 of LibreOffice now makes it easier to reach that Font tab: use > > the Status bar's language menu, click "more". > > That's an inaccurate description. "More" just goes to the same place as > [CTRL]+[1] for the selected cells. If the latest-used tab was "Font", then > you get to "Font", but if the latest was, say, "Number", then that's the tab > you see. You're right, ady, I got confused there. This report actually matches an enhancement request that's been around for a while: bug 76750. Let's mark as a duplicate. *** This bug has been marked as a duplicate of bug 76750 ***
(In reply to ady from comment #2) > If the latest-used tab was "Font", then > you get to "Font", but if the latest was, say, "Number", then that's the tab > you see. The relevant issue is bug 127856.