You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2012/07/02 05:21:36 UTC
[Bug 120136] New: If the top left cell in data area is blank, the
row will be regarded as hierarchial axis labels while create chart.
https://issues.apache.org/ooo/show_bug.cgi?id=120136
Priority: P3
Bug ID: 120136
Assignee: ooo-issues@incubator.apache.org
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: shanzhu33@gmail.com
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.
[Bug 120136] If the top left cell in data area is blank, the row
will be regarded as hierarchial axis labels while create chart.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120136
papayes <jy...@free.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |jyl44@free.fr
--- Comment #2 from papayes <jy...@free.fr> ---
Created attachment 82040
--> https://issues.apache.org/ooo/attachment.cgi?id=82040&action=edit
2 first lines sélected as "Name"
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
[Bug 120136] If the top left cell in data area is blank, the row
will be regarded as hierarchial axis labels while create chart.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120136
--- Comment #3 from papayes <jy...@free.fr> ---
Hello,
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.
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
[Bug 120136] If the top left cell in data area is blank, the row
will be regarded as hierarchial axis labels while create chart.
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=120136
Yan Ji <ya...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
Ever confirmed|0 |1
--- Comment #1 from Yan Ji <ya...@gmail.com> ---
Reproduced in AOO 3.4, change status to "CONFIRMED"
--
You are receiving this mail because:
You are the assignee for the bug.