Date formats are removing while drill downing from pivot sheet in excel file.is there any code to handle this?

Aspose.Cells Product Family
1

Hi Sir,
I generated pivot output.When I double click the data column field in pivot sheet,The records related to that field are opening in a new sheet named “sheet1” but the date formats in the newly opened sheet are not retaining as in data sheet.

Please help me any code is there in aspose api?
please find attached file.

pcssup_Copy of Forecast Sets_1013415_232_1.zip (25.3 KB)

2

@padarthi,

Thanks for providing us template file and details.

Well, this is MS Excel’s behavior and nothing to do with Aspose.Cells APIs. MS Excel shows the complete Date value instead of formatted value from the source cells when you double-click on data section of the PivotTable, it will always show the details with complete DateTime value for the underlying data item(s) in the Table/List Object. I tried to to accomplish the task in MS Excel manually but to no avail. If you could accomplish the task (automatically change the DateTime value (as per the formatted cells of the source cells) when it is opened into a new sheet Table/List Object) in MS Excel manually, kindly do provide a sample file with complete details and screenshots on how to do it, we will check on how to do it via Aspose.Cells APIs.