Bug 145355 - EDITING: CellStyle should allow making text all UPPERCASE or all lowercase
Summary: EDITING: CellStyle should allow making text all UPPERCASE or all lowercase
Status: RESOLVED WONTFIX
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.6.2 release
Hardware: All Linux (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-10-28 02:54 UTC by Tom Williams
Modified: 2021-10-29 01:37 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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.  :)