I can confirm that this issue is still happening using v11.1.20111.2113

The problem:

Fields that were initially hidden but were made visible via the column chooser do not get exported correctly. In the ExportStarted event these fields have a Visibility of Visible.

The result is that the exported grid has empty columns reserved for these fields but does not populate them with headers or values.

Please advise on a workaround

Hi Steve,

sorry about the late response - we have been a bit busy lately but this issue has cropped up again and I'm still trying to resolve it.We are now working with version 10.3.20103.1003.

Thanks for the tip! I did as you suggested and found that the visibility of all the visible fields (i.e. those that had been selected in the field chooser) had their visibility set to Visible. So it looks like all is ok.

However strange things are happening. Now the file includes a blank column for each new row that gets added via the field chooser. The field layout visibility is set to true for the newly added columns, a new column is created in the Excel worksheet, but no data or header information.

We've got the source attached to our solution now, but so far haven't been able to find anything.

Regards,

Steve

Hello Steve,

Not sure if you have gotten this to work or not, but it seems like it might have been an issue wht the version you were trying to use.  I have tried with the latest version of NetAdvantage (10.3) and the columns come up just fine in the workbook as I un hide them via the field chooser.  I will not be able to help more unless I know the version of the controls that you are using.  If you are still having problems whith this, please let me know.

A workaround would be to handle the BeginExport event and set the columns visibility inside of that event manually.

e.DataPresenter.FieldLayouts[0].Fields[0].Visibility = Visibiliyt.Visible;