In the attached sample file B3 gets an empty style which is expected to match A4. The issue is reflected in generated HTML (Apose.Cells 8.3.2.4):
var workbook = new Workbook(“AsposeIssues//pivot_issue.xlsx”);
workbook.CalculateFormula();
workbook.Worksheets[0].PivotTables.Cast<PivotTable>().First().RefreshData();
workbook.Worksheets[1].IsVisible= false;
var a3 = workbook.Worksheets[0].Cells[“A3”];
var b3 = workbook.Worksheets[0].Cells[“B3”];
//Assert.Equal(a3.GetStyle(),
b3.GetStyle());
workbook.Save(“AsposeIssues//pivot_issue.html”, new HtmlSaveOptions{ExportHiddenWorksheet = false});
Hi Dmitry,
Thanks for your posting and using Aspose.Cells.
We were able to observe this issue after running your sample code with your source Excel file using the latest version: Aspose.Cells
for .NET v8.3.2.5. The styles of pivot table rows are lost.
We have logged this issue in our database for investigation. We will look into it and fix this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.
This issue has been logged as
- CELLSNET-43428 - HTML rendering issue: pivot table cells in group headers have incorrect styles.
I have attached the output html and screenshot for a reference.
Hi,
We have fixed your issue “CELLSNET-43428” now.
Let us know your feedback.
Thank you.
Thanks, v8.4.0.1 fixes the issue.
Hi Dmitry,
It is good to know that you are up & running again. Please feel free to get in touch if you need our further assistance with Aspose APIs.
The issues you have found earlier (filed as CELLSNET-43428) have been fixed in this update.
This message was posted using Notification2Forum from Downloads module by Aspose Notifier.