Bug 33580

Summary:	EDITING: IF-function does not correctly re-calculate with NOW() and TODAY()
Product:	LibreOffice	Reporter:	André Schnabel <andre.schnabel>
Component:	Calc	Assignee:	Kohei Yoshida <kohei>
Status:	RESOLVED DUPLICATE
Severity:	major	CC:	gerard.fargeot, mchl.rdll
Priority:	medium
Version:	unspecified
Hardware:	Other
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	test document, using affected functions

Description André Schnabel 2011-01-27 02:33:14 UTC

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:

  =IF(A1=1;NOW();"x")

-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
any notice)

Comment 1 André Schnabel 2011-01-27 02:33:56 UTC

Created attachment 42578 [details]
test document, using affected functions

Comment 2 Noel Power 2011-01-27 03:24:09 UTC

for kohei I think.

Comment 3 Kohei Yoshida 2011-01-27 06:12:12 UTC

This sounds like deja vu.  I'm sure this has already been reported somewhere...

Comment 4 GerardF 2011-01-27 08:06:21 UTC

(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

Comment 5 Kohei Yoshida 2011-01-27 08:21:33 UTC

Yes, that one.  Thank you.

*** This bug has been marked as a duplicate of bug 31939 ***