Issue 92769 - label of single row is not detected
Summary: label of single row is not detected
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.4.1
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
: 121696 (view as issue list)
Depends on:
Blocks:
 
Reported: 2008-08-13 19:13 UTC by tab
Modified: 2013-02-24 16:31 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
File where Degrees() evaluates inconsistently (9.84 KB, text/plain)
2008-08-13 19:16 UTC, tab 		no flags Details
file where B12=0 (9.56 KB, text/plain)
2008-08-20 02:50 UTC, tab 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description tab 2008-08-13 19:13:43 UTC 
Open AngRaDeg.ods
Cell B17 evaluates properly; Cell B12 has a similar formula but gives a wrong
result.
Comment 1 tab 2008-08-13 19:16:03 UTC 
Created attachment 55751 [details]
File where Degrees() evaluates inconsistently
Comment 2 Regina Henschel 2008-08-13 19:48:33 UTC 
I see no error. The values are accurate with at least 14 digits.

Change the format to scientific and increase the number of shown digits to see
the whole numbers.
Comment 3 tab 2008-08-20 02:47:13 UTC 
That's weird. The problem disappeared with the file I uploaded, AngRaDeg.ods:
contents of cell B12 is now correct  --I am not questioning the accuracy.
...And reappeared with the very similar AngRaDegB.ods, attached: contents of
cell B12 should not be 0.
Comment 4 tab 2008-08-20 02:50:33 UTC 
Created attachment 55871 [details]
file where B12=0
Comment 5 Regina Henschel 2008-08-20 10:17:21 UTC 
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.
Comment 6 tab 2008-08-20 15:16:13 UTC 
Thank you.
I hope the problems involved will be solved, because automatic labels are really
handy! So much so, I stumbled onto them by chance.
Comment 7 Regina Henschel 2013-02-24 16:31:32 UTC 
*** Issue 121696 has been marked as a duplicate of this issue. ***