Issue 88908 - Cannot input all-uppercase month names into cells
Summary: Cannot input all-uppercase month names into cells
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.4.0
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Keywords: needmoreinfo, oooqa
Depends on:
Reported: 2008-05-01 06:08 UTC by cluster
Modified: 2008-11-21 22:37 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

sample file showing my results (67.62 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-05-01 08:00 UTC, Rainer Bielefeld
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description cluster 2008-05-01 06:08:54 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.
Comment 1 Rainer Bielefeld 2008-05-01 07:59:07 UTC
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.

Pls specify your OS and Platform!
Workaround if you need the capitalized words as string: enter a single quote in
front of it.
Comment 2 Rainer Bielefeld 2008-05-01 08:00:34 UTC
Created attachment 53296 [details]
sample file showing my results
Comment 3 Regina Henschel 2008-05-01 10:25:33 UTC
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.
Comment 4 cluster 2008-05-01 18:08:23 UTC
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?
Comment 5 Regina Henschel 2008-05-01 19:44:26 UTC
If it is not a month name but a simple string, then rainerbielefeld told you:
type an apostrophe in front.
Comment 6 cluster 2008-05-01 20:25:32 UTC
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.
Comment 7 Stefan Weigel 2008-11-21 22:36:50 UTC
Choose Tools|Contents|AutoInput in order to switch off the behaviour you are
complaining about.
Comment 8 Stefan Weigel 2008-11-21 22:37:53 UTC
Closing invalid.