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.
