I am attempting to use the CountIf(). However, when opening the spreadsheet in Excel, i get a #NAME? error in the cell(s) where the formula is used. A Typical formula looks like this:
COUNTIF(D3: D3, "C") // space added after colon to keep emoticon from forming
If i place my cursor in the function editor bar and simply press return, Excel updates the function and all is well. So it is syntactically correct. How can I use the COUNTIF() function?
Also, is there anyway to use formulas that are not already coded into the Aspose object? I don't care about the Excel.CalculateFormula(). I can let Excel do the calculations when the user opens the spreadsheet...Thanks.