RadGrid GridNumericColumn negative amounts switch to positive when editing

8 posts, 0 answers
  1. bryan
    bryan avatar
    12 posts
    Member since:
    Feb 2016

    Posted 21 Aug 2017 Link to this post

    There is a serious bug in the AJAX radgrid, when using a bound GridNumericColumn, where NumericType = "currency" to set the display format.  

     

    When the  datasource has negative amounts, this will be displayed in the format "($1.22)", which is what is expected with a currency format.  But, as soon as you try to edit this column, it opens the editor, and misinterprets this negative, and transforms the amount to positive.   The currency format should be shown in non edit mode, but it should interpret this properly and display a number with a negative sign in edit mode.  When edit has closed, the display should revert back to currency format.

     

    This is a very serious issue with financial applications, such as those that deal with hundreds of million sof dollars in a corporate Profit And Loss, or Forecasting system.

     

     

  2. bryan
    bryan avatar
    12 posts
    Member since:
    Feb 2016

    Posted 22 Aug 2017 Link to this post

    forgot to mention....

    This issue is for BatchEdit mode.

  3. Eyup
    Admin
    Eyup avatar
    4031 posts

    Posted 28 Aug 2017 Link to this post

    Hello Bryan,

    I believe this is the same case from your formal support thread. I am glad the provided sample has proven helpful.

    Regards,
    Eyup
    Progress Telerik
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  4. bryan
    bryan avatar
    12 posts
    Member since:
    Feb 2016

    Posted 28 Aug 2017 in reply to Eyup Link to this post

    yes, same issue.  Maybe I put this in the wrong forum, I wanted to report this as a (non trivial) bug that needs to be fixed.  The other post in the support forum was to get an urgent workaround.
  5. Dave Wolf
    Dave Wolf avatar
    38 posts
    Member since:
    Feb 2006

    Posted 24 Jan Link to this post

    What was the fix for this?  I'm having a similar issue.
  6. bryan
    bryan avatar
    12 posts
    Member since:
    Feb 2016

    Posted 25 Jan in reply to Dave Wolf Link to this post

    Hi Dave, they never did fix that grid issue, but there is a workaround.   But the workaround is for batch edit mode...is that the mode you are using?
  7. Eyup
    Admin
    Eyup avatar
    4031 posts

    Posted 29 Jan Link to this post

    Hi,

     

    Yes, this behavior is present only with Batch editing mode which does not support automatic handling of formats. You can use InPlace editing instead which would be more suitable in this case:
    https://www.telerik.com/support/kb/aspnet-ajax/grid/details/radgrid-batch-editing-templates-and-specifics

     

    Regards,
    Eyup
    Progress Telerik

    Get quickly onboarded and successful with UI for ASP.NET AJAX with the Virtual Classroom technical trainings, available to all active customers. Learn More.
  8. bryan
    bryan avatar
    12 posts
    Member since:
    Feb 2016

    Posted 04 Feb in reply to Dave Wolf Link to this post

    Dave, as I mentioned...if its batch mode you are using there is a workaround solution, without the need to do inline editing.  It willwork for batch mode.  let me know.
Back to Top