[Solved] How to stop capitalize first letter in cell
[Solved] How to stop capitalize first letter in cell
I have a large spreadsheet of usernames and passwords for various sites. I have "cap first letter of sentence" unchecked. However, it persists in recording each password with a leading cap! I have to manually correct each time. And now it has started capitalizing all alpha characters! What can I do? I don't use Writer very much, so I am content with whatever happens in Writer as a result of adjusting the Calc settings. --Eleanor
Last edited by Hagar Delest on Sat Jun 16, 2018 5:00 pm, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
Re: How to stop capitalize first letter in cell
Type a leading apostrophe. It won't be part of the text value.
Turn off Tools>CellContents>Auto Completion
Turn off Tools>CellContents>Auto Completion
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: How to stop capitalize first letter in cell
Yes, I can do that, but I'd prefer to solve the underlying problem and not be forced into a workaround for almost every entry!
AOO 4.1.8 and LO 6.4.5 on MacOS 10.15.7
Re: How to stop capitalize first letter in cell
Did you turn off auto completion in the tools menu?
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: How to stop capitalize first letter in cell
I don't see Tools > Autocompletion (OO v. 4.1.3) - I have Tools > Autocorrect, and Tools > CellContents > AutoCalculate and Tools > CellContents > AutoInput. If I uncheck AutoInput, that seems to help so far...
AOO 4.1.8 and LO 6.4.5 on MacOS 10.15.7
Re: How to stop capitalize first letter in cell
Click on "Tools" > "Autocorrect Options" > uncheck "Capitalize first letter of every sentence and you're all set.
OpenOffice 4.1.3
Re: How to stop capitalize first letter in cell
I'm sorry to be so forgetful, but I seem to not have the problem any more and I forget what fixed it! In any case, the option "Capitalize first letter..." is already unchecked... Thanks for your interest.
AOO 4.1.8 and LO 6.4.5 on MacOS 10.15.7
-
- Posts: 3
- Joined: Thu Jul 28, 2016 5:43 pm
Re: [Solved] How to stop capitalize first letter in cell
Good thread, unchecking the box seems to have worked for me. I say "seems to have worked" because I fixed it once before and it worked for a while, but came back with a new version of the software. Hopefully it will stay away this time.
Apache OpenOffice 4.1.2 on Windows 10