Array functions with more than one cell output #489
JanMarvin
started this conversation in
Show and tell
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
As stated in this SO:
If your Excel matrix formula creates more than one cell for output, only one cell will be populated with data when you open it and before you manually click in the cell to recalculate the formula. In the following example, the MMULT function generates a matrix multiplication of size 3 x 3. We can get the full width of the output either by checking the required size in Excel, or we can calculate the matrix size for the required cell range in Excel in R itself. If we know the output range, we can set it in
openxlsx2
. This is currently (openxlsx 0.4.1) not supported via the formula function and we have to change the internalcc
data frame which contains all worksheet data.Beta Was this translation helpful? Give feedback.
All reactions