Ask Your Question

calc format cells to upper case

asked 2017-09-13 03:35:14 +0200

barnmichael gravatar image

I want to have Calc format/convert input to uppercase on the fly for certain ranges of cells. I have several spreadsheets that have data entered on a regular recurring basis. Certain cell ranges i want all upper case, while other ranges are mixed case. I don't want to keep clicking the CAPS LOCK on and off. The cells contain letters and numbers, so I'm constantly on and off the SHIFT key. I'd like it if I can just enter the information and have Calc apply the proper format on the fly. Going back after the session and highlighting cells and hitting the UPPERCASE button is a pain as well. Is Calc capable of doing this? In searching the web, I find lots of people have asked about this, but no decent solution has been offered that I can find.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-09-13 04:49:53 +0200

librebel gravatar image

Hello @barnmichael,

Unfortunately the CellStyle does not support case conversion, but it does support setting a different Font for your cell.

Just create a new CellStyle for your selected cell range, and set its Font to "Latin Modern Roman Caps" ( or any other UPPERCASE font that you have in your font list ).

HTH, lib

edit flag offensive delete link more


Close, but not quite. For various political reasons, we are using the Consolas font. They like the slashed zeros. But, otherwise, the UPPERCASE fonts have uppercase letters, but they are big and small. Still have to use SHIFT or CAPS LOCK to get full sized characters. Not a suitable solution. I guess we just live with the fact it cannot be done.

barnmichael gravatar imagebarnmichael ( 2017-09-13 08:28:12 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-09-13 03:35:14 +0200

Seen: 10 times

Last updated: Sep 13