Date: prev next · Thread: first prev next last
2018 Archives by date, by thread · List index

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


Specify how characters should be displayed using the 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

I trust this helps.

Brian Barker

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


Privacy Policy | Impressum (Legal Info) | Copyright information: 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.