https://bugs.documentfoundation.org/show_bug.cgi?id=164751
Bug ID: 164751
Summary: Conditional formatting with formula loses "=" and
doesnt work
Product: LibreOffice
Version: 24.8.4.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 198601
--> https://bugs.documentfoundation.org/attachment.cgi?id=198601&action=edit
Showing the formula added to conditional format
Version: 24.8.4.2 (X86_64) / LibreOffice Community
Build ID: bb3cfa12c7b1bf994ecc5649a80400d06cd71002
CPU threads: 16; OS: Windows 11 X86_64 (10.0 build 22631); UI render:
Skia/Raster; VCL: win
Locale: en-CA (en_CA); UI: en-US
Calc: CL threaded
I have set a conditional format with a formula that should change the
background colour of a cell when the condition occurs. The condition is a
formula "=R7<TODAY()". When cell R7 has a date less than today, it will show a
red background with bold date with format YYYY-MM-DD. I set the red background
as a style.
If you enter the condition, it works the first time.
If you try to copy and paste the format, it fails.
If you go to edit the conditional format, you will see that the "=" has been
removed from the formula. Once you add the "=" again, press OK and exit the
dialog box, the conditional format will work again.
As soon as you save and open, the conditional format doesn't work.
Note that auto calculate is on. Apparently some other bug showed that
conditional format with formula doesn't work without auto calculate.
--
You are receiving this mail because:
You are the assignee for the bug.
