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

Export Number To Excel

1 Answer 27 Views
GridView
This is a migrated thread and some comments may be shown as answers.
Sergey
Top achievements
Rank 1
Sergey asked on 06 Nov 2013, 09:02 AM
Hello!

My radGridView is filled by numbers. I export it to excel.  All cells in this file has type 'Common'.
This cause some values look rounded. 
For example: real number is 113199997.01, but in excel it looks like '113199997'.

How can I force cell to be 'Numeric' type?






1 Answer, 1 is accepted

Sort by
0
Yoan
Telerik team
answered on 07 Nov 2013, 04:21 PM
Hello Sergey,

With the current version (Q3 2013) of our controls, it is possible to modify the data type. I would suggest you to check this help article for a reference. Basically, you should subscribe to GridView's ElementExporting event and set the args.VisualParameters as GridViewExcelMLVisualParameters).DataType property to Numeric.


Regards,
Yoana
Telerik
TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for WPF.
Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
Sign up for Free application insights >>
Tags
GridView
Asked by
Sergey
Top achievements
Rank 1
Answers by
Yoan
Telerik team
Share this question
or