Apache OpenOffice (AOO) Bugzilla – Issue 3765
Cannot write "April" in cell (auto changes to lower case)
Last modified: 2003-09-08 16:55:29 UTC
I was trying to make a table with the current month name as caption. However, when I write "April" in a cell and press enter, the cell content is automatically changed to "april". The same goes for "APRIL". Seems the program thinks this word has to be low case for some reason. With a bit of experimenting I find that this does not happen with "June" nor "Apetite". So far I have only found "april" to have this behavior. This behavior does not occur in a table in a text document (in case this has anything to do with anything).
Hi, does this issue only happen on April 1st or is it reproducible on any other day ;-) Best regards, Peter BTW: I guess we need to submit another one against IsueZilla itself because we have no flag for this case. ;-))
Actually, this was not a joke, and the problem is still reproducible in my machine. This is the 641 version shipped with mandrake 8.2. Some extra information about what changes and not: April changes Aapril remains ApriL changes April_ remains April- remains (April) remains "April" remains Still, although annoying, I guess it's a minor issue.
...And since I am a seriously neurotic person without a life, I just couldn't let this rest. I've installed 641d on my WinXP machine to see if the same thing happens there. It did, so here is another set of tests: January - keeps case February - keeps case Mars - changes to lower case April - changes to lower case May - keeps case June - keeps case July - keeps case August - keeps case September - changes to lower case October - keeps case November - changes to lower case December - changes to lower case Is this a valid cause to reopen the issue?
er->joepal: Do you happen to already have the lower case strings as data somewhere in the same column above where you enter the new value, and does the behavior (changing new input to lower case) stop if you deselect menu /Tools/CellContents/AutoInput?
No, in the WinXP case I installed the app solely for testing this, and it had not been installed on that machine previously. The first thing I did was to write April (uppercase A). Deselecting /Tools/CellContents/AutoInput do stop the behavior. So I write Mars in cell a1 and it keeps case. Then I re-enable AutoInput, and write an M in cell a2. The system responds (correctly) with proposing Mars (upper M), but when I press enter, the actual cell contents are changed to mars (lower m). Now, some speculation: Fact A is that both machines I have tested on run with swedish as default language. Fact B is that only month names that are the same in swedish and english (mars, april, september, november and december) are changed to lower-case. So could it be a locale-related problem? Setting "Tools/options/language settings/language/Locale setting" to English (USA) does not change the phenomenon however. Nor does unchecking ".../language settings/writing aids/check capitalization".
I'll have a look at it. Sorry for my previous comment but it really sounds like an april prank when submitted that day ;-) Peter
No problem. :-) More test info: When entering only single words, it seems I am allowed to capitalize all swedish words *except* month names and weekday names. I had expected that numbers (Ett, Två, Tre -- One, Two, Three) would change case too, but they do not. However, when including the word in a sentence, the case is kept. As an example, it is allowed to write "April inleds med..." (April is started with...). Further, looking at "tools/options/spreadsheet/sort lists" I find all the words I am not allowed to capitalize. After having changed all weekday names to initial upper case there, I am indeed allowed to write "Måndag" (Monday). However, having done that I am no longer allowed to write "måndag" (lower m) as it changes to "Måndag". :-) (And no, having the words with both cases there did not work, as the system then forced initial upper case) Why the list sort order should decide whether I'm allowed to capitalize certain words is beyond me, but obviously there is some connection.
Hi, reproducible when installed with swedish locales. Sort lists (tools->options->spreadsheet->sort lists) in swedish are defined with lower case entries. I guess AutoCorrect uses these lists to overrule the original input. I'm not sure if this behaviour is wanted and/or correct so I'm passing this one to Eike. Best regards, Peter BTW: Please do not file these kind of bugs on april 1st again ;-))
Correct. The sort lists entries are evaluated for the AutoInput (I think this was decided because sort list entries are assumed to be correct, but no one thought of the trouble you had). This seems to be a rather obscure feature not being clear to the user, it's not even mentioned in the online help, though defined range names and so on are. To suppress AutoInput evaluation (without deactivating AutoInput completely) precede the input with a leading single quote: 'April. er->ft: Please decide if we should keep the feature of matching against sort list entries. If we keep it, we should document it.
The trick with Tools -> cell contents -> AutoInput really should be documented. People without the knowledge and patience to look in Issuezilla will be completely exasperated by it. I have just been caught trying to enter a set of mixed-case strings: "Aa, aa, AA, aA" etc and it was quite frustrating enough to send me back to Excel
Frankly: I did not check if this is documented or not but if not we should do so.
It is documented: "AutoInput is case-sensitive. If, for example, you have written "Total" in a cell, you cannot enter "total" in the another cell of that same column without first deactivating AutoInput."
Wonderful, so I close this one.
set to verified
closed verified