Free Support Forum - aspose.com

Wrong displaying of grouped rows in pivot table

hello

when I group datas manually i get proper table

Etykiety wierszy Count of nazwa produktu
<100 50
100-150 20
150-200 32
200-250 25
250-300 32
300-350 20
350-400 24
400-450 25
450-500 23
500-550 25
550-600 22
600-650 20
650-700 27
700-750 25
750-800 23
>800 107
Suma końcowa 500



Using aspose I get this

Etykiety wierszy Count of nazwa produktu
<100 50
>800 107
100-150 20
150-200 32
200-250 25
250-300 32
300-350 20
350-400 24
400-450 25
450-500 23
500-550 25
550-600 22
600-650 20
650-700 27
700-750 25
750-800 23
Suma końcowa 500

Why is line '>800' in wrong place?

part of my code:

pivotTableGrup.AddFieldToArea(PivotFieldType.Row, "sprzedaż");
pivotTableGrup.AddFieldToArea(PivotFieldType.Data, "nazwa produktu");

PivotField sprzedaz = pivotTableGrup.RowFields[0];
ArrayList list = new ArrayList();
list.Add(PivotGroupByType.RangeOfValues);
pivotTableGrup.SetManualGroupField(sprzedaz, 100, 800, list, 50);

Thanks

Hi,

Thanks for your posting and using Aspose.Cells.

Please provide us your full simple runnable sample console application project replicating this issue with the latest version: Aspose.Cells for .NET 8.5.0.

Please also provide us your source excel file, your actual and expected output excel files. You can create your expected excel file manually using Microsoft Excel and attach it here for our investigation.

It will also be helpful if you could also provide us the steps you took to create your expected excel file using Microsoft Excel in some screenshot.

We will look into your issue and help you asap. Thanks for your cooperation.

Hello

I send you full project with files you required. They are in Resources folder. I also add Aspose.Cells.dll 8.5.0.0.

Steps I took create expected excel File:
Insert->pivot Table -> Click OK-> move Field ‘sprzedaz’ to Rows and Field ‘nazwa produktu’ to datas ->right mouse click on Rows Section->Group-> set parametrs: 100,800,50
See also screenShot. I hope it is clear




Hi,

Thanks for your sample project, screenshot, explanations and using Aspose.Cells.

We were able to observe this issue as mentioned by you. >800 is at the wrong line inside the Pivot Table grouped rows which should be fixed.

We have logged this issue in our database for investigation. We will look into it and fix this issue. Once the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-43747 - Wrong displaying of Grouped Rows in Pivot Table