EPPlus/FormulaParsing/Excel/Functions/Information/N.cs

using System.Collections.Generic;
using OfficeOpenXml.FormulaParsing.Exceptions;
using OfficeOpenXml.FormulaParsing.ExpressionGraph;
using OfficeOpenXml.Utils;

namespace OfficeOpenXml.FormulaParsing.Excel.Functions.Information;

public class N : ExcelFunction {
  public override CompileResult Execute(
      IEnumerable<FunctionArgument> arguments,
      ParsingContext context) {
    ValidateArguments(arguments, 1);
    var arg = GetFirstValue(arguments);

    if (arg is bool b) {
      var val = b ? 1d : 0d;
      return CreateResult(val, DataType.Decimal);
    }
    if (IsNumeric(arg)) {
      var val = ConvertUtil.GetValueDouble(arg);
      return CreateResult(val, DataType.Decimal);
    }
    if (arg is string) {
      return CreateResult(0d, DataType.Decimal);
    }
    if (arg is ExcelErrorValue) {
      return CreateResult(arg, DataType.ExcelError);
    }
    throw new ExcelErrorValueException(eErrorType.Value);
  }
}