拷贝忽略隐藏行

spread.commandManager().register(
  "selectIgnoreHidden",
  {
    canUndo: false,
    execute: function (spread, options, isUndo) {
      var sheet = spread.getActiveSheet();
      spread.suspendPaint();
      var sels = sheet.getSelections();
      var newSels = [];
      for (var sel of sels) {
        var originalRange = sel;
        if (originalRange.row !== -1) {
          var newRanges = [];
          var lastVisibleRow = -1;
          for (var r = 0; r < originalRange.rowCount; r++) {
            var row = originalRange.row + r;
            if (!sheet.getRowVisible(row)) {
              if (lastVisibleRow !== -1) {
                newRanges.push(
                  new GC.Spread.Sheets.Range(
                    lastVisibleRow,
                    originalRange.col,
                    row - lastVisibleRow,
                    originalRange.colCount
                  )
                );
                lastVisibleRow = -1;
              }
            } else if (lastVisibleRow === -1) {
              lastVisibleRow = row;
            }
          }
          if (lastVisibleRow !== -1) {
            newRanges.push(
              new GC.Spread.Sheets.Range(
                lastVisibleRow,
                originalRange.col,
                originalRange.row + originalRange.rowCount - lastVisibleRow,
                originalRange.colCount
              )
            );
          }
          newSels = newSels.concat(newRanges);
        }
      }
      sheet.clearSelection();
      for (var sel of newSels) {
        sheet.addSelection(sel.row, sel.col, sel.rowCount, sel.colCount);
      }
      spread.resumePaint();
    },
  },
  186,
  false,
  false,
  true,
  false
);