Bug 33580 - EDITING: IF-function does not correctly re-calculate with NOW() and TODAY()
Summary: EDITING: IF-function does not correctly re-calculate with NOW() and TODAY()
Status: RESOLVED DUPLICATE of bug 31939
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: Other All
: medium major
Assignee: Kohei Yoshida
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-01-27 02:33 UTC by André Schnabel
Modified: 2011-01-27 09:05 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
test document, using affected functions (10.63 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-01-27 02:33 UTC, André Schnabel 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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 ***