Hi Aspose,
After re-saving the attached pivot.xlsb file, the setting “Classic PivotTable layout (enables dragging of fields in the grid)” is not retained.
Steps to reproduce the issue:
1. Open the attached pivot.xlsb file in Excel 2007
2. Verify that in PivotTable Options -> Options -> Display tab, “Classic PivotTable layout (enables dragging of fields in the grid)” is checked
3. Run the below Java code with Aspose.Cells v8.6.0
4. Open the output pivot_out.xlsb file in Excel 2007
5. Observe that in PivotTable Options -> Options -> Display tab, “Classic PivotTable layout (enables dragging of fields in the grid)” is now unchecked
Code which can reproduce the issue:
// Open Excel file.
final Workbook workbook = new Workbook(“C:\Temp\pivot.xlsb”);
// Save Excel file.
workbook.save(“C:\Temp\pivot_out.xlsb”);
Please advise how we can retain this setting. Thanks.