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
65
WinGrid column Format..
posted

I have a few columns in my wingrid whose display format needs to be set to 3 digit precison.  In the InitializeLayout event, I've set the "MaskInput" property  of those columns to "nn,nnn.nnn".  This works fine (displays 3 digits after decimal pint) when user clicks into the cell to edit it.  However after databinding for normal display a rounding/truncation seems to occur  ie. 1.234 is displayed as 1 and 12,345.678 is displayed as 12,346

Can someone help me in setting the display format explicitly & correctly?

 

Thanks,

Anand

 

 

  • 180
    Verified Answer
    Offline posted

    Set the format of the  band.column at the same time you set the MaskInput

     

    Dim band As UltraGridBand = Me.ugSp.DisplayLayout.Bands(0)

            Dim oCol As UltraGridColumn
            For Each oCol In band.Columns
                With oCol
                    Select Case .Index
                        Case 0
                            .Format = "#,##.000"
                            .MaskInput = "nn,nnn.nnn"