asked on April 12, 2017
For example,I applied some formatting (filter,format cell,conditional formatting,grand total,sub total ,layout etc.) on pivot table.I want to clear all the formatting & just want to get the pivot back .
⋅ April 12, 2017
Hello Manoranjan,
Thank you for your question. We would like to inform you that in order to clear all formatting you have two possible options. The first option is to save your report in the current state and restore it whenever is necessary. API calls flexmonster.setReport() and flexmonster.getReport() will help you. Please have a look at the example on JSFiddle. The second option implies clearing the report and leaving only the data source. This can be done with the following code: flexmonster.setReport({dataSource: flexmonster.getReport().dataSource}). You are always welcome to find more information about different API calls in our documentation. We would be grateful for your feedback.
Regards,
Tanya
⋅ April 13, 2017
Thank you so much Tanya..
