Format rate in cell

[Sum]

The format of this cell is currently set to 0.0%, but why is it that when I enter 1, the result becomes 100%? And when I enter 100%, the result becomes the string '100%'. How can I input 100% in a way that the displayed result remains as the rate 100%?

[Vasanth Ravi]

Hi Sum,

We have confirmed the issue as " Value converts to string when entered with % in custom format applied cell " and logged a bug report and it will be available in our Essential Studio Volume 3 release. You can track the status of the issue via the feedback link below.

Feedback link for tracking purpose: https://www.syncfusion.com/feedback/46432/value-converts-to-string-when-entered-with-in-custom-format-applied-cell

You will be informed regarding this once the fix is published.

Disclaimer: “Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works re prioritization.”

[Babu Periyasamy]

Hi Sum,

We are glad to announce that our Essential Studio 2023 Volume 3 release v23.1.36 is rolled out and is available for download under the following link. And we have included the fix for the reported issue “Value converts to string when entered with % in custom format applied cell” in this release.

https://www.syncfusion.com/forums/184588/essential-studio-2023-volume-3-main-release-v23-1-36-is-available-for-download

Feedback link: https://www.syncfusion.com/feedback/46432/value-converts-to-string-when-entered-with-in-custom-format-applied-cell

We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance.

Regards,          

Babu.