Errors.cs

/*
 * NanoXLSX is a small .NET library to generate and read XLSX (Microsoft Excel 2007 or newer) files in an easy and native way
 * Copyright Raphael Stoeckli © 2026
 * This library is licensed under the MIT License.
 * You find a copy of the license in project folder or on: http://opensource.org/licenses/MIT
 */
 
using System;
 
namespace NanoXLSX.Enums
{
    public static class Errors
    {
        public enum FormulaError
        {
            NoError,
            UnknownError,
            Null,
            DivisionByZero,
            Value,
            Reference,
            Name,
            Number,
            NotAvailable,
            GettingData
        }
 
        //TODO Expose public?
        internal static bool TryParseFormulaError(string value, out FormulaError error)
        {
            switch (value)
            {
                case "#NULL!":
                    error = FormulaError.Null;
                    return true;
                case "#DIV/0!":
                    error = FormulaError.DivisionByZero;
                    return true;
                case "#VALUE!":
                    error = FormulaError.Value;
                    return true;
                case "#REF!":
                    error = FormulaError.Reference;
                    return true;
                case "#NAME?":
                    error = FormulaError.Name;
                    return true;
                case "#NUM!":
                    error = FormulaError.Number;
                    return true;
                case "#N/A":
                    error = FormulaError.NotAvailable;
                    return true;
                case "#GETTING_DATA":
                    error = FormulaError.GettingData;
                    return true;
                default:
                    error = FormulaError.UnknownError;
                    return false;
            }
        }
 
        //TODO Expose public?
        internal static string FormulaErrorToString(FormulaError error)
        {
            switch (error)
            {
                case FormulaError.Null:
                    return "#NULL!";
                case FormulaError.DivisionByZero:
                    return "#DIV/0!";
                case FormulaError.Value:
                    return "#VALUE!";
                case FormulaError.Reference:
                    return "#REF!";
                case FormulaError.Name:
                    return "#NAME?";
                case FormulaError.Number:
                    return "#NUM!";
                case FormulaError.NotAvailable:
                    return "#N/A";
                case FormulaError.GettingData:
                    return "#GETTING_DATA";
                default:
                    throw new FormatException($"An invalid error type '{error}' was specified");
            }
        }
    }
}