PivotTable. Incorrect 'Row/Column Headers' state. (*.xlsb)

Aspose.Cells Product Family
1

Hi,


I created a simple document with Pivot Table in *.xlsx and *.xlsb format. It’s the same document converted from *.xlsx to *.xlsb by Excel, but Aspose.Cells returns different states for ‘ShowPivotStyleColumnHeader’ and ‘ShowPivotStyleRowHeader’ fields.

*.xlsx
ShowPivotStyleColumnHeader = true
ShowPivotStyleRowHeader = true
*.xlsb
ShowPivotStyleColumnHeader = false
ShowPivotStyleRowHeader = false

Workbook wb = new Workbook(fName);
foreach(Worksheet ws in wb.Worksheets)
{
foreach(PivotTable pt in ws.PivotTables)
{
try { pt.RefreshData(); }
catch { }
try { pt.CalculateData(); }
catch { }
try { pt.CalculateRange(); }
catch { }

// my inner printing method
printLine(“ShowPivotStyleColumnHeader”, pt.ShowPivotStyleColumnHeader.ToString(), SPACE2);
printLine(“ShowPivotStyleRowHeader”, pt.ShowPivotStyleRowHeader.ToString(), SPACE2);
}
}

I use Excel 2010 and Aspose.Cells v7.3.5.1.

Thanks,
Alex Shloma
2

Hi,


Thanks for providing us the template files and sample code.

After an initial test and using your code with your template XLSB file, I have managed to reproduce the issue as you have pointed out. I have logged a ticket with an id “CELLSNET-41339” for your issue. We will look into your issue soon.

Thank you.
3
Hi,

Could you please download and try this fix: Aspose.Cells for .NET v7.3.5.3 and let us know your feedback.

I have tested with it and it works fine.

both properties are True for the XLSB file which are fine I think, e.g
ShowPivotStyleColumnHeader --> True
ShowPivotStyleRowHeader --> True

Thank you.
4

Hi,


Sorry, It’s my fault. I messed description.
Here is the correct description:
*.xlsx
ShowPivotStyleColumnHeader = false
ShowPivotStyleRowHeader = false
*.xlsb
ShowPivotStyleColumnHeader = true
ShowPivotStyleRowHeader = true

I also checked Aspose.Cell 7.3.5.3, It returns the same result as previous version.

Thank you,
Alex Shloma
5

Hi,


Yes, I have checked it and you are right, it is an issue for XLSB file format regarding PivotTable. I have reopened your issue “CELLSNET-41339” again and we will soon look into it.

Thank you.
6

Hi,

Thanks for using Aspose.Cells for .NET.

Please download and try this fix: Aspose.Cells for .NET v7.7.0.4 and let us know your feedback.

7

The issues you have found earlier (filed as CELLSNET-41339) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.