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
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 >>