In Word, you can toggle among small case – initial caps - all caps
easily – but not in Excel.
Er, we are not talking about Word, either!
Can you toggle among case sizes in Libre Calc?
Not that I know of. But you could easily copy material into a text
(Writer) document, modify it there, and copy it back. If you use
Paste
Special... and paste it into the text document as HTML you should see
a table. That way, you can handle arbitrary ranges in one go, not
just
individual cells.
I created a Calc document.
Step 1: Select all cells of interest:
Step 2: Use
(1) Format > UPPERCASE
(2) Format > lowercase
(3) Format > Capitalize Every Word
(4) Format > Sentence Case
(5) Format > Toggle case
This directly changes the text of interest, but, I think that it will
NOT affect text shown that is produced by an equation. For example,
=UPPER(A1) will always show as upper case.
In Write, special case is handled using the Character Style. I do not
believe that you can use a character style in Calc. A character style
dictates how characters are displayed. They have a property
CharCaseMap
Specify how characters should be displayed using the
com.sun.star.style.CaseMap constant group. This does not change the
actual text—only the way it is displayed.
• NONE = 0 – No case mapping is performed; this is the most
commonly used value.
• UPPERCASE = 1 – All characters are displayed in uppercase.
• LOWERCASE = 2 – All characters are displayed in lowercase.
• TITLE = 3 – The first character of each word is displayed in
uppercase.
• SMALLCAPS = 4 – All characters are displayed in uppercase,
but with a smaller font.
If you edit a character style, click on the Font Effects tab and the
"Effects" drop-down allows you to set this.
In calc, if you Format a Cell, there is also a Font Effects tab, but,
there is no "Effects" drop-down or any other way to change how the text
is displayed with respect to case. Although a Calc cell contains a text
object, I do not see the CharCaseMap property in the text object. Seems
that CharCsaeMap is an optional property so it need not be supported
https://api.libreoffice.org/docs/idl/ref/servicecom_1_1sun_1_1star_1_1style_1_1CharacterProperties.html#ab8138e9a5d1a97f5fbbc2b431ca0cffa
I trust this helps.
Brian Barker
--
To unsubscribe e-mail to: [email protected]
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
