Ask Your Question

LibreOffice 6.2 Calc Set row or column all caps?

asked 2019-04-04 16:01:32 +0200

Tecknomage gravatar image

I've looked at all the 'help' but the advice seems to be for older versions. Example, in [Format Cells][Font Effects] there is no way to set all caps as some 'help' references say.

So just how can I set a column to always use caps?

Using [Format][Text][Upper Case] does not set a selected row to caps permanently. That is, if I enter a letter in an empty cell in that row (like 'd') is does not convert to 'D'

NOTE: I created a spreadsheet using an older version of Calc and that still works.

edit retag flag offensive close merge delete


older version of Calc and that still works

Which version? All the research I have done suggests that the "automatic" conversion has never been possible (right back to OOo) and still is not.

BigRAl gravatar imageBigRAl ( 2019-04-04 17:26:48 +0200 )edit

LibreOffice 6.0 (I think)

I have a spreadsheet to keep track of my blood pressure readings. The right column is for indicating "Intermittent Heartbeat" and if I type 'i" to auto-converts to "I"

As many searched solutions show, there was a [Format][Text] Property 'All Caps' (?) in the past. Notice that the only [Format][Text][Font Effects] Properties are for Color, Relief, lining-options.

It would be nice to bring back [Format][Text][Font Effects] that include [All Caps] and [First Letter Cap].

Tecknomage gravatar imageTecknomage ( 2019-04-10 17:15:37 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-04-04 18:29:19 +0200

erAck gravatar image

AFAIK that is not and never was possible, format Upper Case only transforms existing text and is not a cell attribute. Maybe you're confusing that with Writer's Small Capitals? (which still is lower case text but represented differently).

If you say that you "created a spreadsheet using an older version of Calc and that still works" (which version btw?) then please attach such sample file.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-04-04 16:01:32 +0200

Seen: 287 times

Last updated: Apr 04 '19