spreadsheet

While I try to change header titles by passing array of titles to options like below it does not override the headers. Instead it writes new headers first and original data with old headers again from next cell.

I am experiencing the same problem.

In addition, sheets js is mutating the header array passed in, which is not something I would ever expect.

Example:

const head

This would be a nice little feature to have, Excel users are using this a lot.

描述错误

重现

1. 第一步操作:本地 npm run dev,打开demo
2. 第二步操作: 点开数据透视表tab页
3. 第三步操作:报错
4. 最后看到了什么错误:

期望的结果

![image](https://user-imag

Important: Please do not post usage questions here.
To get a quick response, please ask a question on Stack Overflow using gspread tag.
See existing questions: https://stackoverflow.com/questions/tagged/gspread

Describe the bug
A clear and concise description of what the bug is.

To Reproduce
Steps to reproduce the behavior:
1.
2.
3.

Expected behavior
D