Issue 125878 - Calc incorrect diagram with empty cells
Summary: Calc incorrect diagram with empty cells
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: 4.1.1
Hardware: PC Windows 7
: P3 Normal with 3 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2014-11-19 13:16 UTC by dle
Modified: 2014-11-20 11:40 UTC (History)
2 users (show)

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

incomplet diagram from pivottable with empty cell (23.22 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-11-19 13:16 UTC, dle
no flags Details
Strange data range selected if first cell is empty (83.41 KB, image/png)
2014-11-20 11:13 UTC, oooforum (fr)
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description dle 2014-11-19 13:16:47 UTC
Created attachment 84219 [details]
incomplet diagram from pivottable with empty cell

Hi everybody,
Firstly sorry for my English!
In the attached document, diagram 1 is created from the PivotTable. This diagram is incomplete because it lacks data "Magasin 1" and the legend is made up of two lines! (32 and 33). This is because Calc finds the first non-empty cell in the first column "Produits" to create the cells ranges.
In Figure 2, the cell ranges were adjusted manually, now the chart is correct and legend also. In this example it is easy to do because there is not a lot of lines in the TCD, I can not imagine doing this on a much larger TCB.

FYI this problem does not occur with Libo and Excel.

Comment 1 phip 2014-11-19 17:21:55 UTC
incomplete picture of the pivot table with empty cell

Hi everyone,
First of all sorry for my english!
the same problem on the same file
Comment 2 oooforum (fr) 2014-11-20 11:13:16 UTC
Created attachment 84221 [details]
Strange data range selected if first cell is empty

I confirm with AOO 4.1.0 and 4.1.1
This is not linked with pivot table.
I reproduce with a small table (see screenshot) since first data is empty.
Comment 3 oooforum (fr) 2014-11-20 11:40:15 UTC
Bug present in OOo 3.4.1 too