I have an excel worksheet where I want to use the filter function to return all non-zero values from a user specified row of a table. After this I concatenate the non-zero values and give this string as a result. See cells B12 and B15 on the “calculation” worksheet of the attached excel file.
This excel file is then converted to a webform using Aspose.cells.
Unfortunately the result of the excel filter function is not evaluated correctly (it gives a #n/a value). According to the documentation however, the excel filter function should be incorporated. Could you check if you can reproduce this error?
Thanks in advance
filtertest.zip (12.7 KB)