https://issues.apache.org/ooo/show_bug.cgi?id=120136
Priority: P3
Bug ID: 120136
Assignee: [email protected]
Summary: If the top left cell in data area is blank, the row
will be regarded as hierarchial axis labels while
create chart.
Severity: normal
Issue Type: DEFECT
Classification: Application
OS: All
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: AOO 3.4.0
Component: formatting
Product: chart
Created attachment 78531
--> https://issues.apache.org/ooo/attachment.cgi?id=78531&action=edit
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.
Issue:
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.
--
You are receiving this mail because:
You are the assignee for the bug.
