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.