jxls

Does JXLS support array formulas?

I'm trying to process an array formula in my template:

{=INDEKS(F2:H2;MATCH(A1;F2:H2;0))}

But jxls renders it as an ordinary formula?

=INDEKS(F2:H2;MATCH(A1;F2:H2;0))

Which doesn't work.

It seems Apache POI supports array formulas since 3.13 (the version I'm using with jxls)

https://poi.apache.org/spreadsheet/formula.html

Solution

  • No, as of jxls-2.3.0 it does not support array formulas.

    You can raise an enhancement request at Jxls issue tracker to request it.