If setValuesByHeaderNames updates a range that includes a cell with a non-blank value populated by an array formula, the function will replace the formula value with an equal literal value, breaking the entire array formula. The function should expect that there could be array formulas tucked into the header row, check for that, and ignore any values in the column where the header contains a formula.
If setValuesByHeaderNames updates a range that includes a cell with a non-blank value populated by an array formula, the function will replace the formula value with an equal literal value, breaking the entire array formula. The function should expect that there could be array formulas tucked into the header row, check for that, and ignore any values in the column where the header contains a formula.