copy_worksheet breaks array formulas

Issue #1335 new
Liam Sanders created an issue

When a worksheet is copied via `wb.copy_worksheet`, any array formulas on the resulting sheet are broken. One cell will contain the formula but all other cells that were part of the array will contain values only.

Attached reproducible example.

Comments (3)

  1. CharlieC

    If you look at the code you’ll see that the copy_worksheet function is limited in scope. This is deliberate because the more support is added, the more decisions the library has to take. It would be possible to add support for array formulae but I’d like to see this in a tested PR.

  2. Log in to comment