Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am very new with Open Office and spread sheets in general. In a column whenever I add a new entry it changes all the letters to upper case. Is there a way to disable this? If not, many entries already have been made with lower case letters and it looks bad that the entries are the same except for their capitalization, so is there a way all the rest could be made all uppercase? For example in this one column when I try to add A12b it changes to A12B but it didn't use to and it looks bad now that there's a mix.

EDIT: It only happens on the exact entry T61p. For example if I type in T62p the p remains lower case.

share|improve this question
I'm not sure if openoffice has the formula =UPPER(). You could add a column and use this on every cell, then copy/paste values to remove the formulas. This is for the second possibility. – Jerry Jul 3 '13 at 17:26
OpenOffice uses auto-completion. So if there is a "T61P" in the table, "T61p" will be suggested to "T61P". Just disable in the options. – BurninLeo Aug 9 '13 at 10:51

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.