Excel export – Processing duplicates is not working in XLSX
Posted: Mon Mar 26, 2018 7:04 am
Excel export – Values hidden using processing duplicates is not working while exporting to excel (XLSX)
Hello,
Please can you advice on the below issue while exporting to excel.
The values which are hidden using the processing duplicates option with ‘Global Hide based on Value and Tag’ value is appearing in excel export.This is working perfectly in preview mode and PDF export but fails in excel export.
I am using the ‘Global Hide based on Value and Tag’ option since using simple ‘Hide’ mode doesn’t work since values starts appear is the records are continuing from a previous page to next page.
Please refer the screenshots in preview mode, PDF mode and excel exported document. Please can you help?
Additional Information : When the text component is given "General Format" this is working ; this is why the second column in excel is working fine. But first is of 'Number' format and last column is of 'Currency' format.
Hello,
Please can you advice on the below issue while exporting to excel.
The values which are hidden using the processing duplicates option with ‘Global Hide based on Value and Tag’ value is appearing in excel export.This is working perfectly in preview mode and PDF export but fails in excel export.
I am using the ‘Global Hide based on Value and Tag’ option since using simple ‘Hide’ mode doesn’t work since values starts appear is the records are continuing from a previous page to next page.
Please refer the screenshots in preview mode, PDF mode and excel exported document. Please can you help?
Additional Information : When the text component is given "General Format" this is working ; this is why the second column in excel is working fine. But first is of 'Number' format and last column is of 'Currency' format.