Forums Retired Products and Controls
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
Close
Exotic
60
Change bound column data at runtime
posted

Hi,

I'm binding the ultrawebgrid control using the UltraGridColumn as below.

<igtbl:UltraGridColumn Key="TEST" BaseColumnName="TEST" Format="$###,###.00">

<Header Caption="TEST>

</igtbl:UltraGridColumn>

If a cell has 0.00 for this column, I need to replace it with - .I do not want to show $0.00.

Quick responses are highly appreciated.

Thanks in advance.

Parents
No Data
Reply
  • 21382
    posted

     You could set the .Format string for the column to an advanced formatting string for a numeric datatype

     

    e.Layout.Bands[0].Columns[0].Format = "###,##0.00;(###,##0.00);-"; 

     

    Basically the format string can take multiple masks for  +ve values ; -ve values ; zero 

Children
No Data