We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

PivotTable. Incorrect indent value

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

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.

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.

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.