Get Free Trial

How to clear all formatting in pivot table?

Manoranjan Gahana 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 .

2 answers

Tanya Gryshko Tanya Gryshko Flexmonster 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.

Manoranjan Gahana April 13, 2017

Thank you so much Tanya..

Please login or Register to Submit Answer