Ask Your Question
0

calc format cells to upper case

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

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
0

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

Comments

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
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 38 times

Last updated: Sep 13