This is a migrated thread and some comments may be shown as answers.

[Solved] GridView export excel in ExportML, but cell data format has issuse with "Number stored as Text"

0 Answers 221 Views

GridView

This is a migrated thread and some comments may be shown as answers.

This question is locked. New answers and comments are not allowed.

Lior asked on 02 Aug 2013, 05:46 AM

2.jpg

1.jpg

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)