Excel formula with FILTER function

[jefedesarrollo]

Good morning,

I am currently using Spire XLS for Java to calculate formulas with version 13.1.3, purchased about a month ago.
I have a problem executing a formula that includes the FILTER function.

Excel formula

Code: Select all

=CONCAT(FILTER(Sheet1!P:P,Sheet1!AK:AK>10,""))

When extracting the calculated value, the following error is presented:

Code: Select all

#NAME?

When exporting the Excel document and then opening it, the following error is displayed:



The code used to obtain the calculation of this formula is the following:

Code: Select all

worksheet.getCellRange("F1").setFormula("=CONCAT(FILTER(Sheet1!P:P,Sheet1!AK:AK>10,\"\"))");
String calculatedValue = worksheet.getCellRange("F1").getFormulaValue().toString()
System.out.println(calculatedValue);

Please, we need your support to move forward in this process, thank you.

[Triste.Dai]

Hi,

Thanks for your feedback.
I simulated an excel file and did an initial test with your code, I reproduced your issue. I have logged this issue into our bug tracking system with the ticket number SPIREXLS-4456, our developers will investigate and fix it. Sorry for the inconvenience caused. Once the issue is fixed, I will inform you asap.

Sincerely,
Triste
E-iceblue support team

[Triste.Dai]

Hi,

Thanks for your patience!
Glad to inform you that we just released Spire.XLS for Java 13.3.6 for Java which fixes your issues.
Please download the new version from the following link to test.
Website download link: https://www.e-iceblue.com/Download/xls-for-java.html
Install from Maven Repository:

Code: Select all

<repositories>
    <repository>
        <id>com.e-iceblue</id>
        <name>e-iceblue</name>
        <url>https://repo.e-iceblue.com/nexus/content/groups/public/</url>
    </repository>
</repositories>
<dependencies>
    <dependency>
        <groupId>e-iceblue</groupId>
        <artifactId>spire.xls</artifactId>
        <version>13.3.6</version>
    </dependency>
</dependencies>

Sincerely,
Triste
E-iceblue support team