https://bugs.documentfoundation.org/show_bug.cgi?id=161369
Bug ID: 161369
Summary: LibreOffice Calc conditional date formatting
Product: LibreOffice
Version: 7.6.7.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I created a conditional date format in my date column, and it doesn't work.
Steps to Reproduce:
1.Click on conditional, then date
2.Choose date is for yesterday, then choose a style
3.Click on add, the date is, the, choose today, and choose a style once again.
4.Hit shrink, and then highlight A2:A50 which contain date from 6/1/24 -
7/15/24, and then hit enter.
Actual Results:
The date in A2 is 6/1/24, so the condition for yesterday should have kicked in
for today, but didn't. I won't know until tomorrow if the other style will
kick in.
Expected Results:
The date in A2 for 6/1/24 with the condition for yesterday should kick in for
today, but didn't.
Reproducible: Always
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows 10
OS is 64bit: yes
Copied from the information from menu Help - About LibreOffice.
Version: 7.6.6.3 (X86_64) / LibreOffice Community
Build ID: d97b2716a9a4a2ce1391dee1765565ea469b0ae7
CPU threads: 16; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
