[Libreoffice-bugs] [Bug 150098] TODAY() function and Validity... combination does not work
https://bugs.documentfoundation.org/show_bug.cgi?id=150098 Eike Rathke changed: What|Removed |Added Ever confirmed|0 |1 Status|UNCONFIRMED |NEW Version|7.4.0.0 beta1+ |Inherited From OOo Severity|normal |enhancement --- Comment #4 from Eike Rathke --- The input has to match the condition, formula results are not accepted. For that, evaluation of formulas would have to be added. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150098] TODAY() function and Validity... combination does not work
https://bugs.documentfoundation.org/show_bug.cgi?id=150098 --- Comment #3 from Óvári --- (In reply to Mike Kaganski from comment #2) Excel 2000, 2003, 2007, 2010 also allow formulae: =TODAY()+3 Can the status please be set to NEW? Thank you -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150098] TODAY() function and Validity... combination does not work
https://bugs.documentfoundation.org/show_bug.cgi?id=150098
Mike Kaganski changed:
What|Removed |Added
CC||er...@redhat.com
--- Comment #2 from Mike Kaganski ---
Same with any formula, e.g. '=DATEVALUE("2022-01-01")'
Maybe Validity does not evaluate formulas before checking the input?
FTR, Excel 2016 allows such formulas in validated cells.
--
You are receiving this mail because:
You are the assignee for the bug.
[Libreoffice-bugs] [Bug 150098] TODAY() function and Validity... combination does not work
https://bugs.documentfoundation.org/show_bug.cgi?id=150098 --- Comment #1 from Óvári --- Created attachment 181368 --> https://bugs.documentfoundation.org/attachment.cgi?id=181368=edit Today.ods -- You are receiving this mail because: You are the assignee for the bug.
