"BITOR is completely unknown" exception error

[Zynke]

Hello!

In one of my excels I have a formula that uses the BITOR function, and when I try to evaluate the formulas inside a sheet, it throws the next exception error:

{NPOI.SS.Formula.FormulaParseException: Name '_xlfn.BITOR' is completely unknown in the current workbook

Post the source code just in case it can be useful:

using (var fs = new FileStream(fileName, FileMode.Open, FileAccess.Read, FileShare.ReadWrite))
{
    book = (IWorkbook) new XSSFWorkbook(fs);
}
var eval = book.GetCreationHelper().CreateFormulaEvaluator();
try
{
    eval.EvaluateAll();
}

NuGet versions:

DotNetCore.NPOI version: 1.2.0 SharpZipLib version: 1.0.0-rc2

It's not the BITOR function supported in the last release?

Thanks!

[tonyqus]

I don't think BITOR is supported at all. NPOI simulates the Excel formula engine instead of using the original Excel engine. That's why NPOI doesn't have any dependency on Excel COM API.