In excel file, after open/save, some cells from pivot tables have their behaviour changed. Cells G1, G2, G3, H3, I3, J3 can’t be accessed in excel and their values can not be changed. And third row, from G to J column (G3, H3, I3 and J3) have their background color changed. Can you help with this?
I am using aspose.cells for Java 17.11.0
Workbook workbook = new Workbook("pivot.xlsx"); workbook.save("pivot-xx.xlsx");
pivot.zip (23.5 KB)