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.

Is your feature request related to a problem? Please describe.
Data validation does not support this reference to other cells