Extra row is added when using Pivot

Aspose.Cells Product Family
1

Hi Team,
We are converting our code from excel to aspose using .net.
Now we would like to use the feature of classic pivot as attached in the sample workbook.
But when we are creating it through the aspose code, then we are getting an extra line in the pivot sheet.

We had tried to use the property for pivotTable.HasBlankRows it is also returning true.

After refresh the blank line goes away, but we could not refresh the pivot since we are using some custom styling after the pivot table is created.

You can follow the below steps to create the classic pivot

  1. Select values
  2. Insert pivot
  3. Move value field to values
  4. Right click on pivot
  5. Click Pivot Table options
  6. Switch to Display
  7. Tick the checkbox in front of Classic PivotTable layout

Please refer to difference.png to see the difference.
We had already provided you

  1. Difference screenshot
  2. Sample excel file, generated by excel earlier
  3. Sample file generated by aspose
  4. Sample Code
    AsposeSample.zip (99.9 KB)
2

Hi @rgandhi,

Please, can you inform your Aspose.Cells version?

Thanks []'s

3

We are using the latest one 22.9.0

4

@rgandhi,

Thanks for the details.

Please notice, I am able to reproduce the issue as you mentioned (as per your screenshot) by using template file and sample. I found that an extra row is added when creating classic pivot table in the Excel file. I tried to workaround the issue by adopting some approaches, e.g., set compact or outline style or hiding/removing blank rows, etc., but to no avail. I have logged a ticket with an id “CELLSNET-52088” for your issue. We will investigate and look into the details of the issue to figure it out.

Once we have an update on it, we will let you know.

5

@Amjad_Sahi thanks for confirming about the reproduce of issue and trying of steps, since this issue is blocking us to release our code on production, it will be really helpful, if we can have an ETA for this to be resolved

6

@rgandhi,

We have to analyze your issue in details first then we could update you on it. Hopefully we will share an update or ETA on your issue in the next week.

7

@rgandhi,

This is to inform you that your issue has been resolved now. The fix will be included in our upcoming release (Aspose.Cells v22.10) which is scheduled in the next week early. You will also be notified when the next version is released.

1 Like
8

thanks @Amjad_Sahi for the confirmation about this

9

@rgandhi,

You are welcome.

10

The issues you have found earlier (filed as CELLSNET-52088) have been fixed in this update. This message was posted using Bugs notification tool by johnson.shi

1 Like