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

Discuss the spreadsheet application

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

Postby MCLow » Wed Feb 06, 2019 11:21 pm

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
MCLow
 
Posts: 2
Joined: Wed Feb 06, 2019 11:08 pm

Re: Variable case for text in a cell in Calc

Postby FJCC » Thu Feb 07, 2019 12:17 am

Try removing the selection from the menu item Tools -> Cell Contents -> AutoInput
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
FJCC
Moderator
 
Posts: 7257
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Variable case for text in a cell in Calc

Postby MCLow » Tue Feb 12, 2019 3:11 am

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
MCLow
 
Posts: 2
Joined: Wed Feb 06, 2019 11:08 pm


Return to Calc

Who is online

Users browsing this forum: Google [Bot] and 18 guests