PivotTable. Incorrect indent value

Aspose.Cells Product Family
1

Hi,


Excel shows value 2, but in Aspose.Cells value equals 0. If I change value with Excel and save, then Aspose.Cells will show correct value.
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 { }

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

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

Thanks,
Alex Shloma
2

Hi,


Thanks for providing us the template file and sample code.

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

Thank you.
3

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.

4

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

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