Support for functions counta(a1:d1- r1:ab1) and countblank(a1:s1- ab1:as1)

Aspose.Cells Product Family
1

Hi,

Excel supports the functions, counta() and countblank() for multiple ranges as follows:
counta(a1:d1, r1:ab1)
countblank(a1:s1, ab1:as1)

However, Aspose Cells only support single range counta() and countblank() functions as follows:
counta(a1:d1)
countblank(a1:s1)

Would you please consider to implement these functions?

Thanks & Best Regards,
Ulf Ekström


2

Hi Ulf,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

We have added your requested feature in our internal issue tracking system with issue id: CELLSJAVA-15160. We will look into your required enhancement of functions and get back to you soon.

Thank You & Best Regards,

3

Hi,

Please try the attached latest version of Aspose.Cells. It supports COUNTA function with multiple ranges. For COUNTBLANK function, it cannot be supported with multiple ranges as MS Excel does not support it.

Thank You & Best Regards,

<span style=“font-size: 10pt; font-family: “Segoe UI”;”><o:p></o:p>

4

Hi,


Thanks for the quick fix.

Best regards,
Ulf Ekström