Show the values row incorrectly enabled

Aspose.Cells Product Family
1

When saving a worksheet with pivots tables show the values row under display on the pivot options is being enabled. This was not enabled on the excel file that was copied.

I have attached the excel file that i am using and sample code.

Dim strTemplate as string

Dim strCopyFile as string

strTemplate = "c:\ExcelTemplates\GenericReportCpt.xlsx"

strCopyFile = "c:\ExcelTempFiles\GenericReportCptOutPut.xlsx"

System.IO.File.Copy(strTemplate, strCopyFile, True)

Dim License As Aspose.Cells.License = New Aspose.Cells.License()
License.SetLicense("Aspose.Cells.lic")

Dim workbook As Workbook = New Workbook(strCopyFile)

Dim sheetOverview As Worksheet = workbook.Worksheets("Overview")
sheetOverview.PivotTables("PivotTable1").RefreshDataOnOpeningFile = True
sheetOverview.PivotTables("PivotTable5").RefreshDataOnOpeningFile = True
sheetOverview.PivotTables("PivotTable9").RefreshDataOnOpeningFile = True
sheetOverview.PivotTables("PivotTable19").RefreshDataOnOpeningFile = True
sheetOverview.PivotTables("PivotTable8").RefreshDataOnOpeningFile = True
sheetOverview.PivotTables("PivotTable12").RefreshDataOnOpeningFile = True
sheetOverview.PivotTables("PivotTable13").RefreshDataOnOpeningFile = True
sheetOverview.PivotTables("PivotTable14").RefreshDataOnOpeningFile = True
sheetOverview.PivotTables("PivotTable15").RefreshDataOnOpeningFile = True
sheetOverview.PivotTables("PivotTable16").RefreshDataOnOpeningFile = True
sheetOverview.PivotTables("PivotTable22").RefreshDataOnOpeningFile = True
sheetOverview.PivotTables("PivotTable23").RefreshDataOnOpeningFile = True
sheetOverview.PivotTables("PivotTable24").RefreshDataOnOpeningFile = True

workbook.Save(strCopyFile)
workbook.Dispose()

GenericReportCpt.zip (2.6 MB)
InitialFile.JPG (81.2 KB)
OutputFile.JPG (81.3 KB)

2

@dabatec

Thanks for using Aspose APIs.

We were able to observe this issue and logged it in our database for investigation and for a fix. Once, the issue is resolved or we have some other news for you, we will let you know asap.

This issue has been logged as

  • CELLSNET-45715 - PivotTable Options - Show the Values row - gets enabled on re-saving
3

Hi

Do you perhaps know when this will be fixed as I need to let my client know when he can expect a resolution on this.

4

@dabatec

Thanks for your posting and using Aspose.Cells.

We are afraid there is no update for you at this moment regarding this issue. However, we have logged your comment in our database against this issue and requested the product team to provide some fix or ETA for this issue. Once there is some news for you, we will update you asap by posting in this topic.

5

@dabatec,

This is to inform you that the ETA for your issue regarding PivotTable options is November 7,2017. Hopefully, we could provide you the fix before/on this date.

6

@dabatec

Please download and try the following latest fix and let us know your feedback.

7

The issues you have found earlier (filed as CELLSNET-45715) have been fixed in this Aspose.Cells for .NET 17.11 update.

Please also check the following article: