Bug 145355

Summary:	EDITING: CellStyle should allow making text all UPPERCASE or all lowercase
Product:	LibreOffice	Reporter:	Tom Williams <tomdkat>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED WONTFIX
Severity:	enhancement	CC:	miguelangelrv
Priority:	medium
Version:	7.1.6.2 release
Hardware:	All
OS:	Linux (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description Tom Williams 2021-10-28 02:54:25 UTC

Description:
I'm working on a spreadsheet that can have a text string in a given cell.  If this particular string is entered, I want conditional formatting to apply a style that sets the text to all UPPERCASE or all lowercase.  Currently, this is not supported by "CellStyle".

Steps to Reproduce:
1. Create a new spreadsheet
2. Define a style for text that sets the background color and makes the font bold
3. Notice there's no option to set the case of the text to all UPPERCASE or all lowercase

Actual Results:
There's no option to set the case of the text to all UPPERCASE or all lowercase.

Expected Results:
There should be an option to set the case of the text to all UPPERCASE or all lowercase.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 7.1.6.2 / LibreOffice Community
Build ID: 10(Build:2)
CPU threads: 2; OS: Linux 5.11; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Ubuntu package version: 1:7.1.6-0ubuntu0.21.04.1
Calc: threaded

Comment 1 m_a_riosv 2021-10-28 23:56:36 UTC

What you are asking meaning change the cell content. Modify the format never carries a change on the content.
I guess you know there is an option to Menu/Format/Text to do it.

Comment 2 Tom Williams 2021-10-29 01:37:37 UTC

Thanks for the reply.  Yes, I'm aware I can manually change the case of the text but I was looking for a way to do it automatically and conditionally.  :)