johannesboyne
Jan 11, 2023Brass Contributor
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