OOo 2.3.1 on Linux, English installation
I have a spreadsheet with some English and some German text in different cells. I can set the spell checker for the English cells, but I cannot set the German spell checker correctly.
I can set "Word is German (Switzerland)" but I only can set "Paragraph is German (Germany)". It's not possible for me to set "Paragraph is German (Switzerland)". My "openoffice.org/share/dict/ooo/dictionary.lst" lists only "*de CH*" language variant and in "Tools > Options > Language Settings" I can only selecte "German (Switzerland)" (and of course English, but no "German (Germany)").
I guess, this is only a problem of the userinterface, or does OOo have some hidden spell feature I'm not aware of?
andifor
[Issue] Faulty language selection
[Issue] Faulty language selection
Last edited by Hagar Delest on Mon Jun 30, 2008 9:49 pm, edited 1 time in total.
Reason: Tagged the thread as issue (link to a bug report).
Reason: Tagged the thread as issue (link to a bug report).
Re: faulty language selection
Which distro? Did you Install the office + German lang pack by package manager or did you install Sun's original packages manually?andifor wrote:OOo 2.3.1 on Linux, English installation
How do you set up a paragraph's property in a spreadsheet? I think there are no paragraphs at all, not even in a cell with multiple lines of text.andifor wrote: I have a spreadsheet with some English and some German text in different cells. I can set the spell checker for the English cells, but I cannot set the German spell checker correctly.
I can set "Word is German (Switzerland)" but I only can set "Paragraph is German (Germany)". It's not possible for me to set "Paragraph is German (Switzerland)".
I guess, this is just another problem of a Linux distribution, trying to "enhance" and "integrate" their own compilation of this office suite.andifor wrote: My "openoffice.org/share/dict/ooo/dictionary.lst" lists only "*de CH*" language variant and in "Tools > Options > Language Settings" I can only selecte "German (Switzerland)" (and of course English, but no "German (Germany)").
I guess, this is only a problem of the userinterface, or does OOo have some hidden spell feature I'm not aware of?
andifor
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: faulty language selection
Sun?? I downloaded OOo_2.3.1_LinuxIntel_install_en-US.tar.gz from a mirror, unpacked it manually and copied all the files to my /opt/ directory. No German language pack, nothing. Just this one download.Villeroy wrote:Which distro? Did you Install the office + German lang pack by package manager or did you install Sun's original packages manually?andifor wrote:OOo 2.3.1 on Linux, English installation
(Sorry, I was so unspecific, this was the idea of the information about the English installation)
I don't, it's just the context menu that appears if I click a cell: "Word is..." or "Paragraph is..." (should probably be "Cell is...")Villeroy wrote:How do you set up a paragraph's property in a spreadsheet? I think there are no paragraphs at all, not even in a cell with multiple lines of text.andifor wrote: I have a spreadsheet with some English and some German text in different cells. I can set the spell checker for the English cells, but I cannot set the German spell checker correctly.
I can set "Word is German (Switzerland)" but I only can set "Paragraph is German (Germany)". It's not possible for me to set "Paragraph is German (Switzerland)".
Well, wrong guess. Thanks anyway.Villeroy wrote:I guess, this is just another problem of a Linux distribution, trying to "enhance" and "integrate" their own compilation of this office suite.andifor wrote: My "openoffice.org/share/dict/ooo/dictionary.lst" lists only "*de CH*" language variant and in "Tools > Options > Language Settings" I can only selecte "German (Switzerland)" (and of course English, but no "German (Germany)").
I guess, this is only a problem of the userinterface, or does OOo have some hidden spell feature I'm not aware of?
andifor
andifor
Re: faulty language selection
You installed the English original by Sun, which should be fine even without German language pack. Having additional language packs installed, you can switch the language of the user interface and help system.
Independant from the user interface language, you can install spell checker dictionaries for many languages. Menu:File>Wizzards>Install dictionary...
On cell level the spell checker language depends on the language set in the "Font" tab of the cell formatting dialogue. Within a single text-cell you can even format different portions of text. Language "[None]" implies no spell checking and no typographic features like typographic quotes:
„german“
“english”
"none"
In a multilingual spreadsheet I would create a set of cell styles for each language. This is far more comfortable than manual hard formatting.
Call the stylist (F11), hit the top-left button for cell styles, pick "hierarchical" from the bottom list, use context-menues to add/edit/remove styles.
Proposal:
The suggested set of cell styles lets you define a common set of property for all text cells, with sub-variants for each language.
A more simple variant may work for you as well:
Double-click a style in order to apply all its settings to the currently selected cells. Simply edit the style in order to change all cells sharing the same style.
Still puzzled by the paragraph formatting you mentioned: We are not talking about a table in a text document. Your table is a grid of 64536x256 cells as genearated by Menu:File>New>Spreadsheet...?
In either case you should learn about the concept of styles, which is consistant throughout the whole office suite.
Independant from the user interface language, you can install spell checker dictionaries for many languages. Menu:File>Wizzards>Install dictionary...
On cell level the spell checker language depends on the language set in the "Font" tab of the cell formatting dialogue. Within a single text-cell you can even format different portions of text. Language "[None]" implies no spell checking and no typographic features like typographic quotes:
„german“
“english”
"none"
In a multilingual spreadsheet I would create a set of cell styles for each language. This is far more comfortable than manual hard formatting.
Call the stylist (F11), hit the top-left button for cell styles, pick "hierarchical" from the bottom list, use context-menues to add/edit/remove styles.
Proposal:
Code: Select all
[+]Default
|_[+]Text (top-left orientation, font language "[None]", number format "Text")
|_Text_Swiss (font language "German(Swiss)")
|_Text_English (font language "English(GB)")
A more simple variant may work for you as well:
Code: Select all
[+]Default
|_[+]Text_Swiss (top-left orientation, number format "Text", font language "German(Swiss)")
|_Text_English (font language "English(GB)")
Still puzzled by the paragraph formatting you mentioned: We are not talking about a table in a text document. Your table is a grid of 64536x256 cells as genearated by Menu:File>New>Spreadsheet...?
In either case you should learn about the concept of styles, which is consistant throughout the whole office suite.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: faulty language selection
I don't want/need other language packages. I'm happy with what is comming with the original version from Sun.Villeroy wrote:You installed the English original by Sun, which should be fine even without German language pack. Having additional language packs installed, you can switch the language of the user interface and help system.
Independant from the user interface language, you can install spell checker dictionaries for many languages. Menu:File>Wizzards>Install dictionary...
Yes, I use a spreadsheet document and not a table in a text document, that's why I posted in the Calc group.Villeroy wrote: Still puzzled by the paragraph formatting you mentioned: We are not talking about a table in a text document. Your table is a grid of 64536x256 cells as genearated by Menu:File>New>Spreadsheet...?
In either case you should learn about the concept of styles, which is consistant throughout the whole office suite.
<offtopic>
I know about OOos style capabilities. I don't like them. The concept just doesn't work as I need it. Compare it with the paragraph and font formats (styles) Frame Maker uses (the software I use to write text with). OOos styles is a copy of MS Office' style function. Might be some improvement, but the concept is still the same.
</offtopic>
Anyway, as I think, that OOo uses the correct spell checker (no other spell checker is installed anyway), it's not a big problem. I just was surprised to find me in this situation.
Thanks so far!
andifor
- Hagar Delest
- Moderator
- Posts: 32664
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: faulty language selection
I confirm, same for me with a spreadsheet (using OOo 2.3.1, official version on Ubuntu).andifor wrote:if I click a cell: "Word is..." or "Paragraph is..." (should probably be "Cell is...")
Definitively not. But this is offtopic.andifor wrote:OOos styles is a copy of MS Office' style function. Might be some improvement, but the concept is still the same.
I've made some tries and internally OOo, it seems that there is a language guessing process. Its results depend on the sentence it seems. I just typed "Warum" in a Writer document and OOo asked me if the word or paragraph were in ... Latin ! And I don't have the Latin dictionary installed at all
Have you tried to apply cell styles as advised by Villeroy ?
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
- Hagar Delest
- Moderator
- Posts: 32664
- Joined: Sun Oct 07, 2007 9:07 pm
- Location: France
Re: faulty language selection
For information, after some searches, I've found that one: Issue 66798 - language detection in context menu is broken. I've added comments, you should subscribe and vote for it (up to 2 votes per issue).
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10