Hi, I've read some articles(KB010038 and your ans. in this forum) about hidden cell when exporting to excel.
The point is changing the "hidden" property.
But, I want to export to excel without columns' cell which unbounded and LabelPosition is LabelOnly.
(The header is necessary but cells are not)
For example, there's simple grid.
the column "operands" is unbounded and its LabelPosition is LabelOnly.(this column has no meaning cells and only header is necessary)
But after exporting to excel I found that the column "operands"'s cells(or spaced) were exported and hidden.
Check this out.(I cancelled hidden cells in excel)
How can I remove that cells perfectly? I think treating "hidden" property is not adequate.
Also, is there anyway that preventing hidden cells in the ultragrid from being exported?
(or preventing some column from being exported? - not hidden but filtered out)
Thanks in advance.
Hello geonmo,
I believe that I have already answered to the same question in the following forum thread:
http://community.infragistics.com/forums/t/2241.aspx.
Please do not hesitate to contact us if you need any additional assistance.