Re: [libreoffice-users] Libre Calc – Excel corrected?

> > 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: users+unsubscribe@global.libreoffice.org
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