Spire.XLS is a professional Excel API that enables developers to create, manage, manipulate, convert and print Excel worksheets. Get free and professional technical support for Spire.XLS for .NET, Java, Android, C++, Python.

Thu Nov 07, 2019 5:33 am

Hello,

trying to do a COUNT IF NOT formula but its saying there is an invalid character. Code is below. Is there documentation on how to use a count if not formula? Thanks.

Code: Select all
 
string other = "COUNTIF(Q2:Q9999,\"<>New South Wales\")";
                var otherCount = book.CaculateFormulaValue(other);
                string otherVal = otherCount.ToString();

kitPrecision
 
Posts: 1
Joined: Thu Nov 07, 2019 5:31 am

Thu Nov 07, 2019 6:56 am

Hi,

Thanks for your inquiry.
I have noticed that it returned “invalid characters..” when calculating your COUNT IF NOT formula, the issue has been logged into our bug tracking system, once it is fixed or there is any update, I will inform you. Apologize for the inconvenience caused.

Sincerely,
Nina
E-iceblue support team
User avatar

Nina.Tang
 
Posts: 1182
Joined: Tue Sep 27, 2016 1:06 am

Return to Spire.XLS