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

1 posts, 0 answers
  1. Lior
    Lior avatar
    28 posts
    Member since:
    Aug 2012

    Posted 02 Aug 2013 Link to this post

    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)
Back to Top