Ask Your Question

have Calc cells or column take input and convert to uppercase on the fly [closed]

asked 2014-05-12 00:57:09 +0100

Nothinme gravatar image

updated 2020-08-07 16:29:51 +0100

Alex Kemp gravatar image

How might I format one column of text-entry cells to act as if the CAPS LOCK KEY were turned on, while in adjacent columns it isn't, while entering data into a spreadsheet in LibreOffice Calc?



9/3/2013 | 2023 | wa5xyz | Somewhere, OK | Jake


09/03/2013 | 2023 | WA5XYZ | Somewhere, OK | Jake

I use the pipe symbols | for indicating cell boundaries.

My first place to look for the feature was in the Format Cells dialog under Font Effects (outline, shadowing, overlining, underlining, strike-through) or under Font (Language: English and other choices), then Alignment.

I have chosen a slashed-zero font for use in the call sign column, so that rules out my choosing an all-capitals font, unless there is a suitable one with a slashed zero.

Help was of little help, as it offered up the UPPER function with its cryptic explanation of how to use it. Upper function doesn't look like the proper means of locomotion to use for this job.

Any ideas? Thanks in advance!

LibreOffice Calc:  Version:
Build ID: 1c1366bba2ba2b554cd2ca4d87c06da81c05d24

From the Calc Help menu's About LibreOffice page.

Microsoft Windows XP
Home Edition
Version 2002
Service Pack 3

From My Computer, Properties

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2016-02-22 15:24:26.386174

1 Answer

Sort by » oldest newest most voted

answered 2014-05-12 01:44:20 +0100

m.a.riosv gravatar image

Perhaps not the solution, but I think Menu/Format/Change case after selecting the column can be a quick way to do it.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2014-05-12 00:57:09 +0100

Seen: 2,005 times

Last updated: May 12 '14