incubator-ooo-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [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.
Date Mon, 02 Jul 2012 03:21:36 GMT
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.

Mime
View raw message