Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
590
Excel with blank columns for hidden WDG columns
posted

I use a WebDataGrid to display data. The WebExcelExporter works well with it.

For usability reasons we have built code to allow users to define grid formats that allow show/hide columns, width of the colums and change the visibile index. So all of this is stored in a database.

When users chooses a specific format, the WDG changes accordingly to display the correct columns.

When user attempts to export this customized/formatted grid the excel output contains blank columns for the ones where the wdg had a hidden column.

Hope someone can explain this behaviour and suggest a work around.