Suggest a new product idea for Infragistics ASP.NET

WebDataGrid - DataType vs DataFormatString

For a bounddatafield, if the dataType is numeric like decimal, as soon as you specify a DataFormatString, this field is treated as Text/String. When you export the grid to Excel, the column displays as Text and you can't apply SUM function to the column unless you convert it to Number. We have to give up the format in order to keep the SUM function. I'd love to know if there is a way to have both.

1 vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Shelley T.Shelley T. shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    0 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...

      Feedback and Knowledge Base