Hello,
Thanks in advance a lot. If anybody could look it.
we got an issue for export excel from gridview and treelistview. We use grid.ElementExporting event to export excel including ExportFormat.ExcelML. We process each element in ExportElement.
In exported Excel. each cell has an error for "Number stored as Text".
How let each cell to be correct format in elementexporting event? Is it possible to let excel format be number or percentage through that event?(2.jgp) currently we could not change current design to generate excel.
In this thread : Click Me, it could let format be Genernal, but percentage still gets error.
I.E
in Grid
Row1 78%
Row2 0.18
Expectation
Row1 78%
Row2 0.18
Actual
Row1 got number stored as "text"
Row2 got number stored as "Text"(1.jgp)
Thanks in advance a lot. If anybody could look it.
we got an issue for export excel from gridview and treelistview. We use grid.ElementExporting event to export excel including ExportFormat.ExcelML. We process each element in ExportElement.
In exported Excel. each cell has an error for "Number stored as Text".
How let each cell to be correct format in elementexporting event? Is it possible to let excel format be number or percentage through that event?(2.jgp) currently we could not change current design to generate excel.
In this thread : Click Me, it could let format be Genernal, but percentage still gets error.
I.E
in Grid
Row1 78%
Row2 0.18
Expectation
Row1 78%
Row2 0.18
Actual
Row1 got number stored as "text"
Row2 got number stored as "Text"(1.jgp)