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.

问题
跨sheet的公式初始化的时候不会生效

背景
引用的第二个表的数值本身就是一个公式sheet1的值也没变 , 直接改那个值也没变，但是直接编辑上去的就没有这个情况，导入的会有

屏幕截图或演示

跨表引用公式.xlsx