Apache OpenOffice (AOO) Bugzilla – Issue 125878
Calc incorrect diagram with empty cells
Last modified: 2014-11-20 11:40:15 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. Regards Didier
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
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.
Bug present in OOo 3.4.1 too