https://bugs.documentfoundation.org/show_bug.cgi?id=150098
Bug ID: 150098 Summary: TODAY() function and Validity... combination does not work Product: LibreOffice Version: 7.4.0.0 beta1+ Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: medium Component: Calc Assignee: libreoffice-bugs@lists.freedesktop.org Reporter: ovari...@zoho.com Description: Cells produce a Validity error if A3 and C3 if they are changed from =TODAY() to =TODAY()+3 This change should be allowed as the value would be greater than or equal to A2 and C2, respectively. If A3 is changed is fixed to today's date with Ctrl+; today's date is shown. However, retyping into A3 =TODAY() also produces a validity error so the former value can no longer be entered. Typing into cell E3 =TODAY()+3 does work; hence, it seems to be a problem with the combination of: Validity... and the function TODAY() Steps to Reproduce: A3 and C3 cells produce a Validity error if changed from =TODAY() to =TODAY()+3 This change should be allowed as the value would be greater than or equal to the values in A2 and C2, respectively. If A3 is fixed to today's date with Ctrl+; today's date is shown. However, retyping into A3 =TODAY() also produces a validity error so the former value can no longer be entered. Typing into cell E3 =TODAY()+3 does work; hence, it seems to be a problem with the combination of: Validity... (Menu Bar > Data > Validity...) and the function TODAY() Thank you Actual Results: TODAY() function and Validity... combination does not work Expected Results: TODAY() function and Validity... combination should work Reproducible: Always User Profile Reset: No Additional Info: Will attach spreadsheet to this issue as unsure how to do so now. Linux Mint Version: 20.3 Desktop environment: Cinnamon LibreOffice Version: 7.4.0.1 / LibreOffice Community Build ID: 43e5fcfbbadd18fccee5a6f42ddd533e40151bcf CPU threads: 2; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded -- You are receiving this mail because: You are the assignee for the bug.