search

awalker89 / openxlsx

R package for .xlsx file reading and writing.
Other
363 stars 79 forks source link

Write a matrix formula #515

Open jrfrega opened 3 years ago

jrfrega commented 3 years ago

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()

ycphs commented 3 years ago

Could you please create this also at ycphs/openxlsx?

I am maintaining the active fork of the package.