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
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
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
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
• 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
I trust this helps.
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Impressum (Legal Info)
: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (MPLv2
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our trademark policy