jahav

ce.RegisterFunction("SUM", 1, int.MaxValue, Sum, FunctionFlags.Range, AllowRange.All);

private static AnyValue Sum(CalcContext ctx, Span<AnyValue?> args)
{
    var sum = 0.0;
    foreach (var nullableArg in args)
    {
        if (!nullableArg.HasValue)
            continue;

jahav

using System;
using BenchmarkDotNet.Attributes;
using BenchmarkDotNet.Running;
using ClosedXML.Excel;

namespace ClosedXML.Sandbox
{
    [RPlotExporter]
    public class FormulaBenchmark
    {

jahav

/*
|        Method |         Mean |      Error |     StdDev |
|-------------- |-------------:|-----------:|-----------:|
|   ReturnValue |     42.18 ns |   0.736 ns |   0.689 ns |
| ExceptionPath | 24,777.17 ns | 199.816 ns | 177.131 ns |
*/

public class FormulaExceptionVsReturnBenchmark
{
    private string formExc = "=ABS(-1)/ABS(0)";

jahav

public class ReturnValueVsException
{
    private readonly int _depth;
    private readonly int _result;
    public ReturnValueVsException(int depth = 1, int result = -1)
    {
        _depth = depth;
        _result = result;
    }

jahav

/*
My results
|        Method |         Mean |      Error |     StdDev |
|-------------- |-------------:|-----------:|-----------:|
|   ReturnValue |     61.06 ns |   1.304 ns |   1.281 ns |
| ExceptionPath | 31,077.00 ns | 371.773 ns | 347.757 ns |
*/
public class FormulaExceptionVsReturnBenchmark : IDisposable
{
    private readonly IXLWorkbook _workbook;

jahav

using FluentValidation;
using FluentValidation.Results;
using Microsoft.AspNetCore.Builder;
using Microsoft.AspNetCore.Hosting;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Mvc;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.Hosting;
using SoapCore;
using SoapCore.Extensibility;