Second batch of built-in Excel formula function implementations. More...

#include "XLDateTime.hpp"
#include "XLFormulaEngine.hpp"
#include "XLFormulaUtils.hpp"
#include "XLCellReference.hpp"
#include <algorithm>
#include <array>
#include <cmath>
#include <numeric>
#include <string>
#include <vector>

Detailed Description

Second batch of built-in Excel formula function implementations.

This file adds three groups of functions that were absent from XLFormulaFunctions.cpp:

Batch 1 – Math / Trig (pure <cmath> wrappers): LN, ATAN, ATAN2, SINH, COSH, TANH, ASINH, ACOSH, ATANH, SQRTPI, FACT, FACTDOUBLE, COMBIN, COMBINA, PRODUCT, GCD, LCM, EVEN, ODD, QUOTIENT

Batch 2 – High-frequency utility functions: SUBTOTAL, CHOOSE, ROW, COLUMN, DATEDIF, IRR, MIRR, RATE, IPMT, PPMT, MODE.SNGL, SKEW, KURT, FORECAST.LINEAR

Batch 3 – Statistical distributions: Shared helpers: xlMathNormSInv, xlMathIncGamma, xlMathIncBeta NORM.S.DIST / NORMSDIST NORM.DIST / NORMDIST NORM.S.INV / NORMSINV NORM.INV / NORMINV T.DIST / T.DIST.2T / T.DIST.RT / TDIST T.INV / T.INV.2T / TINV CHISQ.DIST / CHISQ.DIST.RT / CHIDIST CHISQ.INV / CHISQ.INV.RT / CHIINV BINOM.DIST / BINOMDIST POISSON.DIST / POISSON EXPON.DIST / EXPONDIST

All implementations follow the project conventions:

Use numerics(), toDouble(), isNumeric(), isEmpty(), toString()
Return errValue() / errNum() / errDiv0() / errNA() as appropriate
Functions are static members of XLFormulaEngine