Hi All,
I am using Hierarchical Ultrawebgrid control which displays my data in Parent rows n child rows format.
To export the data into excel, i am using UltraWebGridExcelExporter by
UltraWebGridExcelExporter1.Export(UG1);
Currently after exporting user can expand or collapse the data even in excel but, i want data to open by default in expanded form
Can you suggest me some solution.
Regards,
Alok
Hi,
are you talking about in expanded form in the excel file, in the grid or in both?
in the grid I think it is using UG1.ExpandAll
Fernando
Hola,
I think he is talking about in the excel file. Every time I export a hierarchical grid to excel, the rows are collapsed by default in the excel spread sheet. I don't know how to solve this problem either and would be interested in a solution as well. Not to step on anyone else's thread but It would also be nice to format the cells width in the spread sheet to.
Patrick
Anybody every figure this out? I need to expand all rows when exported to excel. I have tried the following but am have no luck:
UltraWebGridExcelExporter1.RowExporting
e.CurrentWorksheet.Rows(e.CurrentRowIndex).Hidden =
False
Sub
mmmm yo creo q eso es asunto de Excel, no del exportador....
(I think that has to be solved with Excel... but I will keep looking for any solution)
Saludos!