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.
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
@arekarek ,
This is to inform you that your issue (logged earlier as “CELLSNET-43747”) has been resolved. The fix will be included in our upcoming release (Aspose.Cells v23.11) that we plan to release in the second/third week of this month (November). You will be notified when new version is released.
The issues you have found earlier (filed as CELLSNET-43747) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi