Is it possible to display or hide zero values in a UltraGrid like in Excel? I've bound an ultragrid to a list of objects. Some of the properties of the object are of integer and decimal types. When I do a add new row (i.e., when a new object is created), I want to show blanks instead of 0 or 0.0 in these fields. Excel has a feature to do this (http://office.microsoft.com/en-us/excel/HP051998791033.aspx). Is there a way to do the same using UltraGrid (Wingrid)?
Good tip!
At the beginning of the number just type a Apostrophe (‘). For example, if you want a cell to display 00957, type ’00957. This will store the number as text.
Just in case anyone else finds this thread, you can use the Format property on the Column:
.Format = "0;; "
Thank you!..
This sugestion works fine if your data source supports null values... but.. this feature MUST TO BE included via an UltraWinGrid's property (i.e: ShowZeroesValues)...
In my case... the format "##" in the column filled the request and the zero values are hidden but...until you activates the cell (in my case contains a list via dropdown control).. I guess that add a blank value when the lists are defined solved in a best way the issue.
Regards
It sounds like your way will only work until you select the colmun, row, or cell. Once something gets selected, you will end up seeing white text on the selected color background.