johannesboyne's avatar
johannesboyne
Brass Contributor
Jan 11, 2023
Status:
New

Add array formula support to Excel Office JS API

See StackOverflow post explaining the issue.

Setting an array formula like this is not working:

let sheet = context.workbook.worksheets.getActiveWorksheet(); 1
let range = sheet.getRange("A31")
range.formulas = [["{=INDEX(Data!$A$2:$A$35;MATCH(0;COUNTIF(A$1:$A9;Data!$A$2:$A$35);0))}"]]
await context.sync();
No CommentsBe the first to comment