https://bugs.documentfoundation.org/show_bug.cgi?id=157963
Bug ID: 157963
Summary: LibreOffice Calc | Conditional Formatting | Seeming
inability to use functions or refer to the cell's
value
Product: LibreOffice
Version: 7.6.2.1 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
