MythSheetIn development
Formulas
What the MythSheet formula engine covers today, and its known limits.
The engine
MythSheet's formula engine is built on IronCalc, pinned at version 0.9.0, with locally reviewed patches.
Implemented and tested with samples
- Common maths
- Conditional aggregates
- Lookups
- Dates
- Finance
- Some dynamic array formulas
Recent fixes corrected range-size checks in the IFS family of functions and range adjustment in SUMIF and AVERAGEIF.
Known limits
- Some argument combinations are not supported or not yet verified. For example, certain
TEXTJOINarray uses are not supported. - The number of registered functions is not a measure of Excel compatibility. Compatibility is checked function by function.
- MythSheet does not support every Excel formula and is not 100% compatible with Excel.