We have an issue with conversion of Excel report to PDF.
We have a prompt in UI to select required filters before generating report.
when user selects this filters, report works fine in excell. it filterout selected data from report but this would not work in PDF report. it shows all data in PDF report
Excel template has Aspose tags/cells and a macro and this macro used to filter the data in excel report after generate the excel report. when generating PDF this would not works.
Is there any way to achieve this in Excel (with out macro ) and PDF reports.
Thanks & Regards