Dear all,
I have the column (Datatype=system.string) in ultragrid. It is showing NA or decimal.
Actually the data is decimal (I have changed the value zero to be NA when showing in the grid. 0==> NA). But the sorting does not apply to decimal due to the datatype is string. The sorting is like below:
" 1 , 11, 2, 23, 3, 333, 4, NA " in ascending order. How can I make sorting in decimal with NA ==0 but the showing in the grid is "NA"? Is it possible??
You have two basic options here.
1) If the grid's column's DataType is a string, then you can use an IComparer to handle the sorting of the strings as numbers.
2) If the grid column's DataType is numeric, then the sorting will work correctly, and you will have to handle translating a 0 into "NA". There are a number of ways to do this. If the field is editable by the user, then you could use a DataFilter. If it's not editable by the user, then it would be easier to do this using a CreationFilter to set the Text on the TextUIElement in the cell.
I am trying to use option 2.
But I don't know why the readonly field in ultragrid is always changed from decimal datatype to string datatype. Then the sorting is in string format. Do you know why?? How to overcome this??
Dear Mike,
In my attached file,( forms scripts), I debug it and checked that the return values of this.catlist.sort(....).They are correct. I am afraid that there is a collision between mouseclick event and default behavior of ultragrid.
Would that happen??
When I disable the sorting of ultragrid, it works.
But how to make the header column sorting indicator show??
When I am trying to use sort indicator.
if (sortOrder == SortOrder.Ascending) column.SortIndicator = Infragistics.Win.UltraWinGrid.SortIndicator.Ascending; else column.SortIndicator = Infragistics.Win.UltraWinGrid.SortIndicator.Descending;
I find that the default sorting of ultragrid happen, no matter where I set below code.
this.dtgCatItemList.DisplayLayout.Override.HeaderClickAction = HeaderClickAction.Select;
Do you have any methods to work??
It works when I set HeaderClickAction.ExternalSortMulti
Hi,
It was not clear to me that you were trying to sort the data and not sort the grid rows. But if that's what you want, then you are correct to use the ExternalSortMutli option. This option tells the grid to show the sort indicator but to not actually sort the rows in the grid.