Pivot Table Refresh issues

Aspose.Cells Product Family
11

@sthetakali,

Please try our latest version/fix: Aspose.Cells for .NET v18.8.5:

Your issue should be fixed in it.

Let us know your feedback.

12

Hi Amjad, I cannot access drop box from work, is it possible to provide a link for the download from Aspose.Cell web site or send the zip file

13

@sthetakali,

New version is attached here for your reference.

Aspose.Cells18.8.5 For .Net4.0.Zip (4.6 MB)

Aspose.Cells18.8.5 For .Net2_AuthenticodeSigned.Zip (4.6 MB)

14

Thank you for the update, I was able to test and confirm it is resolved. Although, I fixed the issue using OpenXml APIs manipulating the xml for hiding the row item. This would be very helpful. I need to do a full regression to upgrade to this version, if my custom functions work.

Thank you
-Srinivas

15

@sthetakali,

Thank you for the feedback. Feel free to contact us again after thorough testing.

16

A post was split to a new topic: _xll attached infront of formula name

17

Hi, I am back with a new bug in the Pivot Refresh.
This time it has to do with sub totals.
Please find the complete code.

When some of the row items are collapsed, they will show the sub totals in that row in excel, even though the row field is not sub-totaled. See image for Excel behavior.

excel_behavior.JPG (283.9 KB)

  1. Create a folder C:\Dev
  2. Extract the contents and run the program.
    Bug_SourceData.xlsx is the input file, when pivot table is refreshed, it is missing the sub-totals as shown in the output file Bug_SourceData_AfterRefresh.xlsx.
    The rows are highlighted in red that have issues.
18

I am using the v18.5.5 which is referenced in the project.

19

@sthetakali,

It seems that you forgot to attach the project here. Please attach the sample project which can be used to reproduce the issue.

20

AsposeBugs_Pivot_SubTotal.zip (5.0 MB)

21

Attached the source code.

22

@sthetakali,

Thank you for providing the sample project. I have tried to re-produce issue by comparing the refresh results using Aspose.Cells and Excel only. I am afraid that I could not observe difference in the results produced by refreshing pivot table using Excel and Aspose.Cells. Please provide us more details by providing some images etc. to show the issue by comparing the refresh results.

23

excel_behavior.JPG (283.9 KB)
Aspose_after_refresh_behavior.JPG (250.2 KB)

I am attaching 2 screen shots, before and after refreshing pivot table.
you can observe the same in the files itself.
Before refresh, the row items
Risk Aversion - Nat Gas ( This is collapsed Row ) has values in the columns B through G. It is the sub-total of all the child elements under that category. ( excel_behavior.JPG )
After refresh, the values are gone, ( Screen shot - Aspose_after_refresh_behavior.JPG ).

It is the same for the similar items that are collapsed.

24

@sthetakali,

We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as

CELLSNET-46341 - Sub-Total missing when rows collapsed after Refresh
25

The way to resolve it is to find all the child rows and add up the numbers if it is a number, if it is a string, do nothing I guess. please test with string types as well in those rows instead of numbers

26

@sthetakali,

Thank you for additional information. We have logged it in our database for our reference.

27

The issues you have found earlier (filed as CELLSNET-46291) have been fixed in Aspose.Cells for .NET v18.9. This message was posted using BugNotificationTool from Downloads module by Amjad_Sahi

28

Any update on the issue ?

29

@sthetakali,

Due to complexity of the issue, it is still not resolved and ETA cannot be provided now. We will write back here as soon as some feedback is ready to share.

30

@sthetakali,

We are working over your issue and we hope your issue should be fixed by October 10, 2018.

Keep in touch.