Bug 159621

Summary: Highlighting Positve Numbers Libre Office Calc
Product: LibreOffice Reporter: Knu-Vise
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WONTFIX    
Severity: enhancement CC: Knu-Vise, libreoffice-ux-advise, rafael.palma.lima, stephane.guillou
Priority: medium Keywords: needsUXEval
Version: 7.5.9.2 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 107575    

Description Knu-Vise 2024-02-07 14:30:53 UTC 
Description:
Highlighting Negative Numbers is a check box --> add one for positive Numbers

for example green

Steps to Reproduce:


1. Select the cells and choose Format - Cells.

2. On the Numbers tab, select a number format and mark Negative numbers red check box. Click OK. --> Add new Check Box

Actual Results:
nothing because Enhancement

Expected Results:
New Check Box


Reproducible: Always


User Profile Reset: No

Additional Info:
https://help.libreoffice.org/latest/en-US/text/scalc/guide/cellstyle_minusvalue.html?DbPAR=CALC

On the Numbers tab, select a number format and mark Negative numbers red check box. Click OK.
Comment 1 Rafael Lima 2024-02-07 22:43:43 UTC 
FYI you can achieve this by simply entering the code below in "Format code".

[GREEN]0;[RED]-0

Also conditional formatting could be used to achieve the same result.

I'm not sure about adding a new check box in the UI.
Comment 2 Stéphane Guillou (stragu) 2024-02-22 17:07:20 UTC 
Let's see what the UX/design team thinks.
Comment 3 Heiko Tietze 2024-02-23 08:54:55 UTC 
Negative numbers in red is a typical use case for finance. Missing your use case that requires numbers in red for positive value,. And I doubt there is one, generalizable, so Rafael's advice (easy to get from the Format Code line) is the recommended way to format. 

Besides, you can always use conditional formatting.
Comment 4 Stéphane Guillou (stragu) 2024-02-27 01:45:17 UTC 
(In reply to Heiko Tietze from comment #3)
> Missing your use
> case that requires numbers in red for positive value
Just noting that OP was asking for positive numbers in green.
But I also think that workarounds available are sufficient.