Custom Cell Formats

3 posts, 0 answers
  1. Jack
    Jack avatar
    1 posts
    Member since:
    Mar 2016

    Posted 21 Mar Link to this post

     

    Small issue with custom formatting.  Most of the ones I've tried work, but have a requirement to present a number in K dollars (ie divided by 1000).  Easy way in excel is to use a custom format like this: 

    $ #,##0.000," K";0 

    which would display 60,000 as 60.000 K. 

    However in radSpreadsheet it shows the value as 60,000.000 K, getting part of the customization right, but not the movement of the decimal.  

     

     

  2. Svetoslav
    Admin
    Svetoslav avatar
    55 posts

    Posted 24 Mar Link to this post

    Hello Jack,

    Thank you for contacting us.

    I can confirm that RadSpreadsheet displays zeros after the decimal separator if an expression like this "$ #,##0.000," K";0"  is applied. It seems that excel skips the zeros after the decimal separator. Anyway, we will need some additional time to look into this behavior and we'll write back to you as soon as we can share more information.

    Thank you for understanding. 

    Regards,
    Svetoslav
    Telerik
    Do you need help with upgrading your AJAX, WPF or WinForms project? Check the Telerik API Analyzer and share your thoughts.
  3. DevCraft banner
  4. Svetoslav
    Admin
    Svetoslav avatar
    55 posts

    Posted 25 Mar Link to this post

    Hello Jack,

    We have further investigated the issue and I can confirm that this is a bug in RadSpreadsheet. For this reason, I have logged it in our feedback portal where you can track the overall progress of the issue: "RadSpreadsheet doesn't respect comma(s) at the end of a number format which causes the number to be incorrectly scaled".

    As a token of appreciation for the bug report, I have added some Telerik points to your account.

    Regards,
    Svetoslav
    Telerik
    Do you need help with upgrading your AJAX, WPF or WinForms project? Check the Telerik API Analyzer and share your thoughts.
Back to Top