Excel export - parameter to not export hidden rows/columns

[Wei Wang]

First of all, thank you for fixing this issue (https://bitbucket.org/apliqoc3ux/apq-c3-ux/issues/706/excel-export-hidden-rows-show-up) in the latest v2024.02 FP1 release! Perhaps the underlying enhancement that we were trying to insinuate is the ability to have a new “export hidden rows/columns” parameter where we can define if we want the export to contain any hidden rows/columns.

As the “default” behavior, I can’t imagine many situations where a user is aware of hidden rows/columns in Apliqo and would need these hidden ones exported to Excel. In fact, many uses for hidden columns are for immediate steps to aid in Apliqo formatting or displaying applicable rows. When exporting a template for Excel upload, having hidden columns also introduces issues with the file is subsequently uploaded as any adhoc columns do not correspond with TM1 element names.

This new parameter would better align most users with their expectation on the exports, as it would more closely correspond with what they see in Apliqo. Thanks!

[Joana MFC Corte-Real]

Dear Wei, Thank you for your input. We will have it in consideration and mark it as On Hold for our easier future reference.