我正在尝试创建一个函数，通过第4列对表格DATA进行降序排序，
```javascript
function specialSort(){
  var sheet = SpreadsheetApp.getActive().getSheetByName('DATA');
  sheet.sort({ column: 4, ascending: false })
}

<details>
<summary>英文:</summary>
I am trying to create a function which sorts the sheet DATA by column 4, in descending order,

Other answers (e.g., [here][1]) seem to recommend this approach. But why does this code throw the error `Exception: Cannot convert '[object Object]' to int`? If I instead use simply `sheet.sort(4)`, I get the result I want (sorting the whole sheet by column 4), except that it's in ascending order.
Note well: I want to (descending) sort the whole sheet by column 4, not just the column itself.
  [1]: https://stackoverflow.com/questions/35563652/automatic-sorting-on-sheets
</details>
# 答案1
**得分**: 1
From your script, I thought that `sort(sortSpecOb)` is for Class Range. The arguments of `sort(columnPosition, ascending)` of Class Sheet are `columnPosition`(整数), `ascending`(布尔值). I thought that this might be the reason for your current issue. In your script, how about the following modification?
### Modified script:
```javascript
function specialSort() {
  var sheet = SpreadsheetApp.getActive().getSheetByName('DATA');
  sheet.sort(4, false);
}