Bug 157963

Summary: LibreOffice Calc | Conditional Formatting | Seeming inability to use functions or refer to the cell's value
Product: LibreOffice Reporter: James <user2650>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: enhancement    
Priority: medium    
Version: 7.6.2.1 release   
Hardware: x86-64 (AMD64)   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: TEST DATA
Document with four CF-Conditions

Description James 2023-10-29 07:04:31 UTC 
Description:
I wish to use conditional formatting to help provide myself with useful information at a glance e.g. it has been at least 30 days since the cell's value.

Steps to Reproduce:
TODAY() === 2023-10-29

1. Open a new spreadsheet
2. Fill a column with three dates

2023-10-29
2023-11-20
2023-11-30

3. Select the column and then Format -> Conditional -> Manage -> Add -> All cells
4. Minimum -> Formula: value < TODAY() + 15. Lime
5. Middle -> Formula: value >= TODAY() + 15. Yellow
6. Middle -> Formula: value >= TODAY() + 30. RED

Actual Results:
RED
RED
RED

Expected Results:
Lime
Yellow
RED

This should ideally be the case regardless if I am using "All cells", "Cell value", "Formula is".

If I could customize "Date is", that would also be useful for this particular use case.


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333
CPU threads: 16; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-NZ (en_NZ); UI: en-US
Calc: CL threaded
Comment 1 James 2023-10-29 07:05:44 UTC 
Created attachment 190487 [details]
TEST DATA
Comment 2 Werner Tietz 2023-10-29 15:49:12 UTC 
Created attachment 190494 [details]
Document with four CF-Conditions
Comment 3 Werner Tietz 2023-10-29 15:50:18 UTC 
Hallo James

Your Assumtion about CF: Colorscale is completly wrong!

you need →Format→Condidional Format→ Condition:

1. (for empty Cells)
Cellvalue  equal to ""
→→→Standard

2. Cellvalue less then TODAY()+15
→→→Lime

3. Cellvalue less then TODAY()+30
→→→yellow

4. Cellvalue greater|equal TODAY()+30
→→→red