排序时实现类Excel提示

var sortAZ = GC.Spread.Sheets.Designer.getCommand("sortAZ");

var oldSortAZExecute = sortAZ.execute;

sortAZ.execute = function (context, propertyName) {
  var activeSheet = context.getWorkbook().getActiveSheet();
  var flag = false;
  var selection = activeSheet.getSelections()[0];

  for (var i = selection.row; i < selection.row + selection.rowCount; i++) {
    if (selection.col > 0) {
      var valueLeft = activeSheet.getValue(i, selection.col - 1);
      if (valueLeft != null) {
        flag = true;
        break;
      }
    }
    if (selection.col + selection.colCount < activeSheet.getColumnCount()) {
      var valueRight = activeSheet.getValue(
        i,
        selection.col + selection.colCount
      );
      if (valueRight != null) {
        flag = true;
        break;
      }
    }
  }

  if (flag) {
    GC.Spread.Sheets.Designer.showMessageBox(
      "发现在选定区域旁边还有数据。该数据未被选择，将不参与排序。",
      "提示",
      GC.Spread.Sheets.Designer.MessageBoxIcon.warning,
      function () {
        oldSortAZExecute.call(this, context, propertyName);
      }
    );
  } else {
    oldSortAZExecute.call(this, context, propertyName);
  }
};