Sorting grouped columns fails in chrome

[robertaandersen]

When sorting grouped columns where row-count exceeds 9 the sorting fails. The data in the column is an integer. Strings work.

http://plnkr.co/edit/yqLPx1bu40ainD1VT9Bw?p=preview

Thanks
Róbert

[robertaandersen]

This is bound to chrome

[a002194]

We facing the same issues in chrome, Custom Sorting Algorithm with Grouping is creating duplicate records in Grid.

grouping: {
groupPriority: 0
},
sort: {
direction: uiGridConstants.DESC,
priority: 0,
},
sortingAlgorithm: function (a, b, rowA, rowB, direction) {
var nulls = $scope.gridApi.core.sortHandleNulls(a, b);
if (nulls !== null) {
return nulls;
}
else {
if (a === b) {
return 0;
}
if (a.indexOf('New') != -1) {
return 1;
}
if (b.indexOf('New') != -1) {
return -1;
}
if (a.indexOf('On-Hold') != -1) {
return 1;
}
if (b.indexOf('On-Hold') != -1) {
return -1;
}
if (a.indexOf('In-Progress') != -1) {
return 1;
}
if (b.indexOf('In-Progress') != -1) {
return -1;
}
if (a.indexOf('In-Queue') != -1) {
return 1;
}
if (b.indexOf('In-Queue') != -1) {
return -1;
}
if (a.indexOf('In-Review') != -1) {
return 1;
}
if (b.indexOf('In-Review') != -1) {
return -1;
}
return 0;
}
}

[brafkind]

This is due to the fact that the group header rows are strings by default. Note the comment on groupingShowCounts under GridOptions ui.grid.grouping

shows counts on the groupHeader rows. Not that if you are using a cellFilter or a sortingAlgorithm which relies on a specific format or data type, showing counts may cause that to break, since the group header rows will always be a string with groupingShowCounts enabled.
Defaults to true except on columns of type 'date'

Disabling groupingShowCounts fixes the issue although it also hides the counts at the group level. Link to Plunkr

[murlinw]

For anyone that wants a resolution in chrome, what I've done is create a custom sorting function that sorts by looking only at the number. It'll split out between the parenthesis and the actual number and then sort the actual number.

Here's an example of the custom sort that I've done.
http://plnkr.co/edit/dvFcz1PCIXXcZP3tdcpR