Discuss the spreadsheet application


Postby BetaRayBill » Fri Aug 07, 2020 1:25 am

I asked this question before and thought I solved it, but there's still a little problem that I can't figure out. In a spreadsheet I will type something in all caps, but once I leave the cell it reverts to lowercase. Then I will have to go to format and make it uppercase that way. Originally it was suggested that I remove Auto Input feature and that works, but I like the convenience of typing something, seeing it completed for me, and selecting it. With Auto Input off I can type something in uppercase and it stays that way. Oddly, with it on, I will see the uppercase version of something I typed before show up; but even if I select it, it will revert to lower case as soon as I leave the cell. I just don't get it. It obviously recognizes the uppercase version of something I typed earlier in that column, but even if I select it, it will revert to lowercase (even if there is no lowercase version of the word anywhere in the column or document!) There hast to another feature that's affecting it, but I can't figure out what it is.

Open Office 4.1.2
MAC OSX Sierra
Posts: 3
Joined: Mon Jul 02, 2018 5:34 am

Re: Uppercase/Lowercase

Postby Lupp » Fri Aug 07, 2020 9:36 am

There is the AutoCorrect tool (I tenderly call it AutoSpoil). >Tools>AutoCorrect Options...>(Dialog with 4 tabs). Thoroughly study the tabs of that dialog and the options/entries there. Then set them consciously as you want them.
There may be a few replacement entries "hardened" against effective deletion. If you experience a problem of the kind, come back with a more detailed report.
On Windows 10: LibreOffice 7.0 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
Lupp from München
User avatar
Posts: 2999
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Return to Calc

Who is online

Users browsing this forum: Google [Bot], mike.stirton and 8 guests