[Solved] Caps won't hold

Discuss the spreadsheet application
Post Reply
Munchkin53
Posts: 1
Joined: Thu Sep 24, 2020 8:53 pm

[Solved] Caps won't hold

Post by Munchkin53 »

Open Office Calc. When entering in any cell in the sheet, the second character reverts to lower case when I attempt to make it upper case.
Example: JKwsrf888 reverts to Jkwsrf888
Cell protection is off.
Last edited by Munchkin53 on Thu Sep 24, 2020 9:48 pm, edited 1 time in total.
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Caps won't hold

Post by RusselB »

You don't have information regarding your OS or OpenOffice version, so this is based on a Windows OS and OpenOffice 4.1.7
Check the entry located by using Tools -> AutoCorrect Options -> Options (tab) -> Correct TWo INitial CApitals
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
Gazita
Posts: 2
Joined: Mon Nov 02, 2020 6:44 pm

Re: [Solved] Caps won't hold

Post by Gazita »

Similarly, when Lower case won't hold and all Tool Autocorrection options have been unchecked, I resolved my issue by turning off a different auto feature under Tools -> Cell Contents ->AutoInput. You can keep AutoInput option for the sheet to save data entry time and entry syntax errors, but remove it for particular cells that have content requiring a modified entry.
Open Office 4.1.7 on MS Windows 10
Post Reply