Decimal precision in editable format
Hi,
I have a requirement that when I am entering a decimal value by default it has to add two decimal places (.00) after entering. for example if I enter
564545 it has to become 564545.00 and again if I am going to Enter it should not be come like 564545 it has to be like 564545.00.
Means In editable mode also I want two decimal places by default.
Please Refer Screen shot:
***Updated by Moderator: Marissa to update categories***
**Moderation Team has archived post**
This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.
Hi,
I tried your suggestions. It is working fine for grid. But not for sections. But I need it for sections only.
Thanks,
Renuka
Hi ,
In the cell properties, please select the option Display value using read-only format.
This way after you enter and tab out, you will see the correct format.
Thanks,
Gisela
Hi Gisela,
When I select the check box "Display value using read-only formatting" , then every time after the conversion to decimal is done, a default tool tip can be seen on mouse hover that says "You must use this format:".
Any solutions for this. I do not want the tool tip to appear.
Hi,
Inorder to achieve your requirement, you can try the following configuration on the presentation tab of the control for the particular field in editable mode as shown below:
But before doing so, please make sure that the value in the before screen gets updated on to the clipboard. If both the fields are on the same screen, then you can make use of Refresh Section feature as follows:
If the first field from which you are retrieving value and show-casing in the second field, is in a repeating grid, then you can make use of Refresh Current Row action on the On-Change event of the first field value.
Thanks,
Praveen.