Hello,
I have a Data Grid with several hidden columns. When I export the grid to an Excel file, it contains the hidden columns - which is what I want. The problem is that the hidden columns in the Excel sheet set the width of the columns to nearly zero. I originally thought the columns were missing until I realized that some of the column header letters seemed to also be missing, and only when I did a column resize of the entire grid is when I realized that the hidden columns were present.
Is there a way to set the Excel column widths of hidden Data Grid columns so that they do not appear missing?
Thanks in advance to anyone that can assist,
John
Hello @John Bradley ,
Outsystems Data Grid is based on Wijmo Flexgrid. You can check this post regarding your use-case: Here.
Full documentation: Here .
Dear John,To resolve the issue of hidden columns having zero width in the Excel export, use the Advanced Excel Forge component in OutSystems: https://www.outsystems.com/forge/component-overview/355/advanced-excel-o11
install the Advanced Excel Forge.
Set Column Width for Hidden Columns:Use the component to export your data grid and explicitly set column widths for hidden columns before exporting.
Export:Trigger the export, and the hidden columns will have a visible width.
This will fix the issue of hidden columns appearing with zero width in Excel.
Best regards,Mukesh Kumar S
Great solution @Mihai Melencu ! this way you can extend the OutSystems Data grid with the full potential of the Wijmo Flexgrid.
Maybe a good addition to the Data grid extension component
I did not know about this extension. Thanks for mentioning it!
@Mihai Melencu Thank you! It worked perfectly! Good learning lesson on how the grid works, too.