Hi all, For .xlsx, I managed to do that by external application to change the xml. My question now, would you accept a patch to add that feature into POI, for both HSSF and XSSF? Thanks,Ahmed From: Ahmed Ashour <[email protected]> To: "[email protected]" <[email protected]> Sent: Wednesday, January 7, 2015 10:58 AM Subject: Array Formula Hi all, As hinted in [1], array formulas are not supported yet. By quickly looking into the difference of normal formula and array formula, one or two attributes are significant. Is there another reason of why array formulas are not implemented? And can I just add the attributes programatically? Thanks a lot, Ahmed
<c r="A2"> <f>SOME_FORMULA</f> </c> <c r="A2"> <f t="array" ref="A2">SOME_FORMULA</f> </c> [1] http://poi.apache.org/spreadsheet/formula.html
