In some cases, the IF function fails to correctly recalculate it's value on change of the referenced cell for the condation, if NOW() or TODAY() is supposed
to be the result.
e.g given a formula like:
-will correctly evaluate to the current time, if A1=1 at the moment you enter the function.
- change A1 to "2" will cause the funtion to evaluate to "x"
- change A1 back to "1" will *not* change the value back to the current time, it will stay at "x" instead
see attached document
(Severity set to major, as user might get wrong results from calculation without
Created attachment 42578 [details]
test document, using affected functions
for kohei I think.
This sounds like deja vu. I'm sure this has already been reported somewhere...
(In reply to comment #3)
> This sounds like deja vu. I'm sure this has already been reported somewhere...
May be this one : https://bugs.freedesktop.org/show_bug.cgi?id=31939
Yes, that one. Thank you.
*** This bug has been marked as a duplicate of bug 31939 ***