[Solved] Variable case for text in a cell in Calc

Discuss the spreadsheet application
Post Reply
MCLow
Posts: 2
Joined: Wed Feb 06, 2019 11:08 pm

[Solved] Variable case for text in a cell in Calc

Post by MCLow »

I am trying to enter upper case letters after lower case letters in a cell in Open Office 4.1.5 Calc. The same text is in another cell with all upper case so the program changes my text to all upper case. I have tried to use the Format Change case but that makes all of the word upper or lower case. What if I want to only change a middle letter to upper case? I have tried to adjust the autocorrect options but couldn't figure out how to get the result that I want.

I know this isn't a common useage.
Last edited by robleyd on Tue Feb 12, 2019 3:22 am, edited 3 times in total.
Reason: Add green tick
OpenOffice 4.1.5 on Windows 10
FJCC
Moderator
Posts: 9248
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Variable case for text in a cell in Calc

Post by FJCC »

Try removing the selection from the menu item Tools -> Cell Contents -> AutoInput
OpenOffice 4.1 on Windows 10 and Linux Mint
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
MCLow
Posts: 2
Joined: Wed Feb 06, 2019 11:08 pm

Re: Variable case for text in a cell in Calc

Post by MCLow »

It looks like that did it. Thanks FJCC. I have been using Open Office Calc for many years and appreciate it.
OpenOffice 4.1.5 on Windows 10
Post Reply