To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=112638
User er changed the following:
What |Old value |New value
================================================================================
Priority|P3 |P2
--------------------------------------------------------------------------------
Platform|Unknown |All
--------------------------------------------------------------------------------
Subcomponent|viewing |programming
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Thu Jul 8 14:04:37 +0000
2010 -------
I could not reproduce the error to vanish, in DEV300m84 I tried setting all
dates to Italian and to Default (en-US) and recalculate each time, but it didn't
change. However, two values changed once when I forced a recalculation without
changing anything.. This smells like some uninitialized variable somewhere.
Interestingly, when exported to .xls and loaded in Excel also Excel displayed
#VALUE! for every cell in Stat.C:E.
Inspecting the formulas revealed that MONTH($Data.$A$5:$F$303) is the underlying
cause, changing that to MONTH($Data.$A$5:$A$303) to use only column A makes the
calculation work as intended. Using MONTH on a non-numeric value of other
columns produces #VALUE! (since OOo3.2)
However, there's a serious flaw with the matrix initialization of the MONTH
values, one can easily see with the matrix formula {=MONTH($Data.$A$5:$F$303)}
that from the second column on arbitrary values are present, all values should
be #VALUE! and not just a few or arbitrary month numbers. These values change
when forcing a recalculation.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
