After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 166498 - values not recalculated
values not recalculated
Status: RESOLVED DUPLICATE of bug 166492
Product: Gnumeric
Classification: Applications
Component: General
1.4.x
Other All
: Normal normal
: ---
Assigned To: Jody Goldberg
Jody Goldberg
Depends on:
Blocks:
 
 
Reported: 2005-02-06 21:49 UTC by Helmut Wollmersdorfer
Modified: 2005-02-09 16:12 UTC
See Also:
GNOME target: ---
GNOME version: ---


Description Helmut Wollmersdorfer 2005-02-06 21:49:17 UTC 
Version details: 1.4.1
Distribution/Version: Debian/Sarge

If
cell E19: 37
     E20: =sumif(offset($D$6:$F$8,E15,E16),"<10",) -> #VALUE!
     E21: =if(E$19=E20,1,0) -> 1

This occurs after opening the file .xls, where the output of E20 changes
incorrectly to #VALUE! (see bug 166492).

I would expect, that each cell shows an actual and correct value in any cases.
In this case the value of E21 should be #VALUE!

Helmut Wollmersdorfer
Comment 1 Morten Welinder 2005-02-09 16:12:12 UTC 
xls files store the result of the last calculation, so this is just a
consequence of the previous bug.


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