Apache OpenOffice (AOO) Bugzilla – Issue 88908
Cannot input all-uppercase month names into cells
Last modified: 2008-11-21 22:37:53 UTC
I do not see a way to input strings like "OCT" and "NOV" into OOCalc cells without OOCalc helpfully lowercasing all but the initial letter. Pressing Ctrl-Z does not undo the autocorrection, and if I edit the cell to recapitalize all characters, OOCalc persists by lowercasing the string again. I turned off all the AutoCorrect options that I could, yet this problem persists.
I checked with "3.0.0 Beta Multilingual version English UI WIN XP: [300m1 (Build9298)]" and can confirm the effect (more or less) With All language setings to ENGLISH, all options in menu 'tools -> AutoCorrect -> Options' unchecked, input "JAN" will be changed to "Jan", but "MAR" will remain. We had a similar report in invalid Issue 69984, but I doubt that the problem has been recognized there correctly because of the rare report. @cluster: Pls specify your OS and Platform! Workaround if you need the capitalized words as string: enter a single quote in front of it.
Created attachment 53296 [details] sample file showing my results
The problem is connected to the sort lists. OOo uses the first sort list, where the entry matches, for its recognition. If you want month names in capitals but still be the data type 'date' (which is a sort of number), then delete the 'Jan,Feb,Mar,...' list and add a 'JAN,FEB,MAR,..' list. But then you cannot have lower characters. I don't know a way to get both spellings.
Apologies for not including the OS; I thought Issuezilla captured my browser string. I run Gentoo Linux. I changed the OS field of this bug from Windows XP back to All, since apparently it affects at least Linux and Windows. I have no reason to think it doesn't affect other OSes. About the sort list suggestion: I don't want /month names/ in capitals -- I want the specific "NOV" string in capitals, because in my case it is a stock symbol rather than a month name. So changing the sort list would be throwing out the baby with the bathwater. Maybe a solution would be to make sort lists case-insensitive and not to "correct" cells based on sort lists?
If it is not a month name but a simple string, then rainerbielefeld told you: type an apostrophe in front.
When I prepend NOV with an apostrophe, the apostrophe ends up in the cell as well. Do I need to enable an option to get OOCalc to remove the apostrophe once I submit cell data? OOCalc's behavior of propercasing month names is not documented, as far as I can tell. At the very least OOCalc should treat this correction the same as other AutoCorrect options and allow Ctrl-Z to undo it.
Choose Tools|Contents|AutoInput in order to switch off the behaviour you are complaining about. ;-)
Closing invalid.