https://bz.apache.org/bugzilla/show_bug.cgi?id=61469
Bug ID: 61469
Summary: [PATCH] Support Array Formulas and Matrix Functions
Product: POI
Version: 3.17-dev
Hardware: PC
Status: NEW
Keywords: PatchAvailable
Severity: enhancement
Priority: P2
Component: SS Common
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Created attachment 35267
--> https://bz.apache.org/bugzilla/attachment.cgi?id=35267&action=edit
Array Formula and Matrix Function Patch
Hi all,
Array formulas and matrix functions are currently not supported in any version
of POI.
In order to store evaluated Excel arrays, I implemented CacheAreaEval which is
based off of MockAreaEval which holds values for each of the cells in the array
range.
I have also added MatrixFunction which allows for the evaluation of transpose,
mdeterm, minverse, and mmult. This file does depend on commons math3.
The other modifications allow for the evaluation of arrays within the formula
evaluation stack.
Please let me know if there are any changes that need to take place or any
other information is necessary.
I apologize for the size of the patch; I have just recently received approval
from Lawrence Livermore National Laboratory to release the code that was worked
on all summer.
Best Regards,
Robert Hulbert
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
