Ask Your Question

calc format cells to upper case [closed]

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

barnmichael gravatar image

updated 2020-08-07 22:43:50 +0100

Alex Kemp 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 reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-08-07 22:44:11.900415

1 Answer

Sort by » oldest newest most voted

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

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 +0100 )edit

Not "on the fly", but .. if it is known on beforehand which ranges must get which Case, then you could write a macro that does the proper formatting of all the involved cells on demand. That would still save you some time and effort. Please ask here again if you need help which such a macro.

librebel gravatar imagelibrebel ( 2017-09-30 21:28:29 +0100 )edit

Question Tools

1 follower


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

Seen: 4,650 times

Last updated: Sep 13 '17