Apache OpenOffice (AOO) Bugzilla – Issue 96332
Text automatically converted when column contains same text in different case (autocorrect off)
Last modified: 2008-11-21 22:26:14 UTC
(This is similar to Issue 88908, but different in that it still happens when autocorrect is off, and that it doesn't relate to an outside list, but relates to other user-generated content in same column within the spreadsheet in question. Either way the workaround is not intuitive.) I am trying to create a spreadsheet with a cross-reference list for attendance at meetings. In other words, the meetings run across the column heads, and the attendees go down the rows. When a person attends a meeting, an "x" goes in the appropriate row/column combination. I am trying to use both lowercase and uppercase "x", meaning different things. However, if I already have a lowercase "x" in the column, it will replace any uppercase "X" I try to enter below it with a lowercase "x". Typing an apostrophe works, but THIS IS NOT INTUITIVE TO THE AVERAGE USER. Or to myself, whom I consider slightly above-average--I only learned of this "solution" while searching for issues before filing one of my own. This occurs in v. 2.4.1 on XP SP2. The cell format appears to be the default (number->general). This will happen for any text. Type "Gregarious", then try to type "GREGARIOUS" below it, and it automatically gets converted to the case of the earlier version.
Choose Tools|Contents|AutoInput in order to switch off the behaviour you are complaining about. ;-)
Closing invalid.