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.
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.
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].
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.