Apache OpenOffice (AOO) Bugzilla – Issue 120136
If the top left cell in data area is blank, the row will be regarded as hierarchial axis labels while create chart.
Last modified: 2013-12-04 05:13:03 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. 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.
Reproduced in AOO 3.4, change status to "CONFIRMED"
Created attachment 82040 [details] 2 first lines sélected as "Name"
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.