awalker89/openxlsx

Write a matrix formula

Opened this issue · 1 comments

jrfrega commented

Expected Behavior

Correctly write matrix formulae like "{=MINVERSE(A1:E5)}" spanning a 5 x 5 range

Actual Behavior

Matrix formula spans only 1 x 1 area

Steps to Reproduce the Problem

(please attach an example xlsx file if possible)
write_data.xlsx

  1. expected behavior of matrix functions

sessionInfo()

  • Version of openxlsx: ‘4.1.5’
  • Version of R: 4.0.2 (2020-06-22)
ycphs commented

Could you please create this also at ycphs/openxlsx?

I am maintaining the active fork of the package.