I have a grouping grid with number of decimal expression column. I have formatted the cell to "#,###;(#,###);-" . The problem is that when i try to sort these column, it seems to sort it as a string and not as decimals. Is there a way to resolve this? Below I have listed the function that adds to expression field.
private void AddExpressionField(string fieldName, string expression)
ExpressionFieldDescriptor ed = new ExpressionFieldDescriptor(fieldName,expression,typeof(decimal));
GridColumnDescriptor columnDescriptor = new GridColumnDescriptor(fieldName);
columnDescriptor.Appearance.AnyRecordFieldCell.Format = "#,##0;(#,##0);-";
columnDescriptor.Appearance.AnyCell.HorizontalAlignment = Syncfusion.Windows.Forms.Grid.GridHorizontalAlignment.Right;
columnDescriptor.AllowGroupByColumn = false;
ADAdministrator Syncfusion Team April 20, 2005 07:29 PM
You can work around it handling the sort yourself using a custom comparer. Here is a little sample.
FHFaraz HaqueApril 20, 2005 10:32 PM
Is this expected to be fixed in any realease soon?
Also, do you know if sorting of summary rows will be supported any time soon? is there a workaround? I need to sort on summary rows in a grouped grid. If it will not be supported by syncfusion anytime soon, i may have to write a custom workflow, as the clients need it as a top priority.
>You can work around it handling the sort yourself using a custom comparer. Here is a little sample.
ADAdministrator Syncfusion Team April 21, 2005 09:40 AM
Actually, this sorting problem is corrected in the 188.8.131.52 code base we are running in house. I see the problem with 184.108.40.206 but not 220.127.116.11.