Description: In LibreOffice Calc enter the following text in a cell: incl. test Note that after pressing tab or enter the word "test" gets capitalized and the test becomes: incl. Test This is unexpected behavior to me, since the AutoCorrect options incl. in the Exceptions tab the word "incl." in the "Abbreviations (no Subsequent Capital)"-list. I'd rather expect the word "test" to keep the capitalization the way it was entered (i.e. lower case in my case above). Note: the issue is reproducible with other abbreviations as well. The behavior seems to be "correct" however in certain cases like: a. test Steps to Reproduce: 1. In a cell enter "incl. test" (w/o the quotes) Actual Results: text becomes "incl. Test" (w/o the quotes) Expected Results: text stays "incl. test" (w/o the quotes) Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no
On Win7, LO 6.0.5, I could reproduce this. Nick: noticing http://document-foundation-mail-archive.969070.n3.nabble.com/GSOC-100-paper-cuts-update-tt4242617.html and the fact you were working on autocapitalization, thought you might be interested in this one. Don't hesitate to uncc yourself if no time and/or not interested, etc.
The setting is in menu Tools > AutoCorrect Options. In tab Options you can uncheck "Capitalize first letter of every sentence". My personal preference is to disable them all. Or you disable this feature for the word "incl.". That is in tab Exceptions. Notice, that the exceptions depend on language. One problem with these settings is, that they are used in Writer as well, tracked in bug 98154. So this is not a bug.
@Regina, can't follow you here. Maybe I didn't express myself clear enough. Please understand that the word: "incl." is in the list under Tools -> AutoCorrect Options... -> Exceptions -> Abbreviations (no Subsequent Capital) and that the setting "Capitalize first letter of every sentence" under Tools -> AutoCorrect Options... -> Options is ticked. The document language and AutoCorrect settings are for the English (USA) local. I'll attach some screenshots to hopefully make it more clear what I see and what I actually do expect. Atm I'm not getting your point not categorizing this behavior as a bug. Could you clarify what I'm missing? However, I realize that it seems to work in a complete new spreadsheet. I've attached the ods file where I can reproduce the issue.
Created attachment 143154 [details] ods file to reproduce the issue
Created attachment 143155 [details] screenshots depicting the behavior/issue
Created attachment 143156 [details] Autocorrect Exception dialog To me, the issue seems to be the 'incl' doesn't include the dot at the end as the other abbreviations in the dialog....
Searching "incl" in Opengrok gives: https://opengrok.libreoffice.org/search?project=core&q=incl&defs=&refs=&path=extras&hist=&type= Third page shows that only "nl" and "nl-BE" locales have "incl." This explains why I can reproduce the bug (I use French UI) at least with a brand new file. Stefan: which locale do you use?
@Stefan: In your "default" cell style you have set the language to "[None]". Therefore LibreOffice cannot find the exception "incl.", because that item is bound to "English (USA)".
@Regina: Oh - wasn't aware of that setting. If you don't mind (otherwise feel free to close this issue), could you tell me how/where to change the language for the default cell style? Google didn't immediately bring up any useful hints and in the F11 dialog all entries seem to be set to English (USA) for me.
@Stefan: It might be, that you had set the language for new documents to "None" in Tools>Options at the time the document was first created. After first creating, this property is saved in the file, and is not affected by changes in Tool>Options. I don't know another reason other than someone had set it to [None] directly in the style. [BTW: Another language pitfall is the language setting "Default (...)". With that setting numbers use the delimiter, which belongs to the LibreOffice which opens the document. So a document written in a English environment shows "1.5". If the document is opened in a German environment, the number is shown as "1,5". Therefore I personally never use "Default (...)", but set the language explicitly in all cases.]
@Regina: Thanks for the explanation. If I got you right, correcting that (from my side) unintended language setting in the default cell style is not possible through the LibreOffice calc UI atm. To solve my issue I manually edited the styles.xml file and corrected the language setting (zxx/none -> en/us) which solved my problem. I'll close the issue as invalid for now. It however sounds to me as there's some design flaw that changing the language settings through the tools -> options dialog doesn't adjust that language setting as well and there not being any indication to the user that a different local applies to cell content than the one set and displayed in that options dialog. However, I'll leave this to s/o else to pursue.
(In reply to Stefan from comment #11) > @Regina: Thanks for the explanation. If I got you right, correcting that > (from my side) unintended language setting in the default cell style is not > possible through the LibreOffice calc UI atm. Of cause you can change it in the UI. In the Style&Formatting pane of the sidebar, right-click the style and use "Modify", tab Font. There you can select the intended language. You should check tab Numbers too, number formatting is independent from text formatting.
Reopening to attach another screenshot for clarification.
Created attachment 143159 [details] cell style: Default dialog
@Regina: I seem to be unable to confirm this locally. If I open the attached test.odt file and then open the Default's cell style dialog as you proposed the language setting for all categories and all formats shows: "Default - English (USA)" for me (see ods_bug_2.png which I just attached). Maybe I'm simply too stupid to get what you mean, hence pardon my incapability in advance. Feel free to disregard at any point if you think it's just a waste of your time.
The error in the attached .ods file is in the tab "Font".
oh man --- yes got it now --- thanks for your time and help --- all cleared up now