ag-grid行排序不适用于小数和空值

// 自定义比较函数
function customComparator(valueA, valueB, nodeA, nodeB, isInverted) {
  // 处理小数和空值
  if (valueA === null || valueA === undefined || valueA === "") {
    return isInverted ? -1 : 1;
  }
  if (valueB === null || valueB === undefined || valueB === "") {
    return isInverted ? 1 : -1;
  }

  // 进行数值比较
  return valueA - valueB;
}

// 在列定义中设置自定义比较函数
var columnDefs = [
  {
    headerName: "Number",
    field: "number",
    sort: "custom",
    comparator: customComparator
  }
];

// 创建ag-grid实例
var gridOptions = {
  columnDefs: columnDefs,
  // 其他配置项...
};

// 初始化ag-grid
new agGrid.Grid(document.querySelector("#myGrid"), gridOptions);