Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
90
Cell value display format
posted

Experts,

I want to my values in the UltraGrid as "#0.00" and after user clicks a cell, the value in the cell shows the original whole digital values.

For example, I have a column called "MD" and a value show as "1428.82" and after user clicks the cell, the value in the cell shows as "1428.8237".

My question is that, is there any Properties in the ultragrid for the user to set to get this functionality. Thanks very much.

Jeff 

  • 3565
    Verified Answer
    posted

    There are two properties that you will be particularly interested in when formatting a cell; the Format and Mask Input properties of a column. The format property is how the data will be displayed when the cell is not in edit mode, the Mask Input property as its name implies is how the data will be formatted when the cell is being edited.

    When a cell is a certain data type a drop down list is available for the Mask Input property that shows some common sample formats. An example mask that would work for you would be somthing like {double:9.2} or {LOC}nnnnnnn.nn.