Issue 120136 - If the top left cell in data area is blank, the row will be regarded as hierarchial axis labels while create chart.
Summary: If the top left cell in data area is blank, the row will be regarded as hiera...
Alias: None
Product: General
Classification: Code
Component: chart (show other issues)
Version: 3.3.0 or older (OOo)
Hardware: All All
: P3 Normal with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2012-07-02 03:21 UTC by Shan Zhu
Modified: 2013-12-04 05:13 UTC (History)
1 user (show)

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

sample_chart.ods to reproduce the issue. (7.19 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-07-02 03:21 UTC, Shan Zhu
no flags Details
2 first lines sélected as "Name" (40.86 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-12-04 05:11 UTC, papayes
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description Shan Zhu 2012-07-02 03:21:36 UTC
Created attachment 78531 [details]
sample_chart.ods to reproduce the issue.

Build info: AOO3.4.1_r1351960

This usability issue is introduced by OO3.3 new feature: Hierarchical Axis Labels for Charts.

Reproduce steps:
1. Open the sample file attached. (In this file, there is a cell range B5:F9 filled with data as data source of chart. 2 top left cells C6:C7 in data area are blank.)
2. Select B5:F9, Insert -> Chart.

In the preview, you can see that, the content in C5:F7 will be regarded as hierarchial axis labels. It caused by the blank cells in the data area. It seems that the code search for the first cell which has a number in, and use it as the beginning of data area. 
It doesn't make sence. The blank cell in data area is common situation, especially in data source generated by Pivot Table.  

Now, to change the result into what we want, we should modify the Name range and Y-Vlue range of data serires one by one. It is unbearable, while there are lots of data series.
A workaround is fill the blank cell at the top left corner with 0.
Comment 1 Yan Ji 2012-07-09 08:18:05 UTC
Reproduced in AOO 3.4, change status to "CONFIRMED"
Comment 2 papayes 2013-12-04 05:11:30 UTC
Created attachment 82040 [details]
2 first lines sélected as "Name"
Comment 3 papayes 2013-12-04 05:13:03 UTC
AOO 4.0.1
I confirm that if the first cell of the digital data is empty
Calc considers that part of the label and name selected as the area the first 2 lines.

The workaround is simple: place a zero!

Verified on Windows (7 and 8), MacOsx10, 9 and OpenSuse7 1 and Ubuntu 12.4.
LibO 4.1.3 is not affected.