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 Answers, 1 is accepted
0
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
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.
0
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
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.