Ask Your Question

How do I have a column (Calc) to be all caps?

asked 2020-01-22 17:19:48 +0200

ETobias gravatar image

I want to have a column in Calc that will convert my entries into caps. After entering the text I am able to select a column and convert everything into caps. I want not to do that step and have the original entries to be converted on the fly.

edit retag flag offensive close merge delete



Type in uppercase.. SCNR.

erAck gravatar imageerAck ( 2020-01-22 19:07:45 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2020-08-04 00:10:59 +0200

LeroyG gravatar image

Writer has the font effect Capitals. Not so Calc.

But you can select a font that use all caps. E.g.: Perpetua Titling MT, Engravers MT, Algerian, Castellar, Felix Titling, Goudy Stout, Showcard Gothic, Stencil. Some are suitable for common text, and some are not.

You can make a internet search for "free all caps fonts".

@erAck, Thanks for the dose of humor. :-)

Edit your question if you want to add more information; also can comment an answer (Add Answer is reserved for solutions).

Check the mark (Correct answer mark) to the left of the answer that solves your question.

edit flag offensive delete link more



Also you may see OpenType features of a font that supports it (see Features button on Font tab; try with e.g. a Linux Libretine font).

Mike Kaganski gravatar imageMike Kaganski ( 2020-08-04 06:48:30 +0200 )edit

I never saw it before. You need to change 'caps' Capitalization to Uppercase, it remain as a cell format.

LeroyG gravatar imageLeroyG ( 2020-08-04 14:00:05 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-01-22 17:19:48 +0200

Seen: 40 times

Last updated: Aug 04