Hi all,
just wondering if there is anyone that can assist with this - we have a grid that by default it loads additional fields that are initially hidden from view. Using the Column Chooser you are able to slecte these columns and show them in the grid. So far so good.
The problem is when you export the gris it doesn't export the additional fields that were added, even though the xamDataGrid field property for that column is set to visible.
Any idea why this may be happening or how to troubleshoot? (btw, we are using v10.1)
Cheers,
Steve
Hello again,
just wanted to follow up on this to see if anyone had any ideas or suggestions on what may be causing this issue. I've messed arount with export options and looked again at the samples but I cannot see what I might be missing.
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;
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,