To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=92769
User regina changed the following:
What |Old value |New value
================================================================================
Ever confirmed| |1
--------------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
--------------------------------------------------------------------------------
Summary|Degrees function evaluates|label of single row is not
| to 0 | detected
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Wed Aug 20 09:17:21 +0000
2008 -------
There is no error in the DEGREES function, but the issue is about the way Calc
determines automatic labels. You have an empty cell under Psi. Calc takes Psi as
column label and so Psi references the cell A12 with an automatically conversion
from empty to 0 for calculation. I change to summary to reflect the real
problem.
There is already issue 82330 about problems with automatic label detection.
Close duplicate, or set dependency, or split 82330 in different issues?
You can avoid such problems, if you define the labels in Insert > Names >
Labels. If you change your sheet in a way that you avoid the false detected
structure, you have to enter the formula newly to force a new label detection,
Ctrl+Shift+F9 is not enough.
---------------------------------------------------------------------
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]
