assay catalogue

Divergence catalogue

247 entries · 1,304 test references · seeded 2026-04-25

Engines (8)
Causes (9)
Categories (4)
ID Cause Engines Category Tests Subjects
DV-0001 missing-function pycel value 200 AVEDEV, AVERAGEA, COLUMNS +75
DV-0002 missing-function excelformulashyperformulaironcalclibreofficepycel value 93 ADD, AVERAGE.WEIGHTED, DIVIDE +12
DV-0003 missing-function hyperformulaironcalcpycel value 88 ACCRINT, AMORLINC, ASC +28
DV-0004 missing-function libreofficepycel value 68 ACOTH, ARABIC, BINOM.INV +27
DV-0005 missing-function ironcalcpycel value 55 ADDRESS, CHAR, CLEAN +17
DV-0006 missing-function hyperformula value 53 AND, AVERAGE, AVERAGEIFS +19
DV-0007 missing-function libreoffice value 41 BITAND, BITLSHIFT, BITOR +10
DV-0008 error-code libreoffice value 40 ACOSH, ATANH, BIN2DEC +35
DV-0009 missing-function excel value 37 DETECTLANGUAGE, EPOCHTODATE, GOOGLEFINANCE +8
DV-0010 missing-function formulashyperformulaironcalclatticelibreofficepycel value 37 DETECTLANGUAGE, EPOCHTODATE, GOOGLEFINANCE +8
DV-0011 missing-function formulashyperformulapycel value 36 DAVERAGE, DCOUNT, DCOUNTA +8
DV-0012 error-code hyperformula value 35 DATEDIF, DATEVALUE, DAYS +8
DV-0013 missing-function hyperformulaironcalclibreofficepycel value 32 FORECAST.LINEAR, MODE.SNGL, MUNIT +9
DV-0014 error-code hyperformulapycel value 23 DAY, EDATE, EOMONTH +4
DV-0015 missing-function hyperformulalibreoffice value 17 CONCAT, IFS, XOR
DV-0016 missing-function hyperformulapycel value 17 CONVERT, ERROR.TYPE, GESTEP +4
DV-0017 missing-function hyperformulalibreofficepycel value 17 BETA.DIST, BINOM.DIST, ERF.PRECISE +10
DV-0018 error-code lattice value 16 ADD, AVERAGE, AVERAGE.WEIGHTED +5
DV-0019 error-code excel value 15 ARRAYFORMULA, ISDATE, JOIN +3
DV-0020 missing-function gsheets value 12 IMAGE, IMPORTDATA, IMPORTFEED +4
DV-0021 missing-function formulas value 11 OFFSET, SUBTOTAL
DV-0022 shape libreoffice value 7 MINVERSE, MMULT, TRANSPOSE
DV-0023 error-code gsheets value 7 CONCAT, FILTER, NORM.S.DIST +1
DV-0024 missing-function formulashyperformulaironcalclibreofficepycel value 7 ISDATE, JOIN
DV-0025 missing-function formulaslibreofficepycel value 7 BASE, COMBINA
DV-0026 missing-function excelformulashyperformulaironcalclibreoffice value 7 POW
DV-0027 missing-function ironcalc value 6 REPLACE, SUMPRODUCT
DV-0028 error-code ironcalc value 6 HOUR, MINUTE, SECOND
DV-0029 missing-function formulasironcalclibreofficepycel value 6 ARRAYFORMULA, SPLIT
DV-0030 error-code ironcalc value 6 INDIRECT, OFFSET, lit:array
DV-0031 arg-semantics excelformulasgsheetslibreoffice value 6 CLEAN, LEFTB, RIGHTB +1
DV-0032 missing-function excel value 5 ARRAY_CONSTRAIN, FLATTEN
DV-0033 missing-function formulashyperformulalatticepycel value 5 CELL
DV-0034 arg-semantics pycel value 5 INDIRECT, OFFSET, XOR
DV-0035 missing-function formulaspycel value 5 COMBIN, QUOTIENT
DV-0036 format-rendering lattice value 4 COMPLEX, IMCONJUGATE, IMDIV
DV-0037 error-code formulas value 4 COUNTA, IMPRODUCT, SEARCH
DV-0038 missing-function excelformulashyperformulaironcalclatticelibreofficepycel value 4 ENCODEURL, ISURL
DV-0039 error-code formulasironcalc value 4 COLUMNS, ROWS
DV-0040 error-code pycel value 4 OFFSET
DV-0041 missing-function formulasironcalcpycel value 4 SERIESSUM
DV-0042 precision hyperformula value 4 NORM.INV, NORM.S.INV, NORMINV +1
DV-0043 missing-function ironcalclibreofficepycel value 4 UNICHAR
DV-0044 missing-function gsheetshyperformulalibreofficepycel value 4 TEXTAFTER, TEXTBEFORE
DV-0045 error-code formulas value 3 IMDIV, IPMT, PPMT
DV-0046 arg-semantics hyperformula value 3 PMT, PPMT
DV-0047 arg-semantics hyperformula value 3 ISLOGICAL, ISODD
DV-0048 missing-function formulashyperformula value 3 INDIRECT
DV-0049 missing-function excelformulasironcalclibreofficepycel value 3 COUNTUNIQUE
DV-0050 missing-function formulashyperformulaironcalcpycel value 3 DOLLAR
DV-0051 shape libreoffice value 2 FREQUENCY
DV-0052 error-code lattice value 2 BITLSHIFT, BITRSHIFT
DV-0053 format-rendering lattice value 2 COMPLEX, IMCONJUGATE
DV-0054 format-rendering lattice value 2 COMPLEX, IMCONJUGATE
DV-0055 error-code lattice error-code 2 AVERAGE, SUM
DV-0056 shape gsheets value 2 SORTN
DV-0057 precision excelformulasgsheetslattice value 2 EFFECT, NOMINAL
DV-0058 error-code libreoffice value 2 IFNA, IRR
DV-0059 arg-semantics excel value 2 PMT, PPMT
DV-0060 arg-semantics libreoffice value 2 PMT, PPMT
DV-0061 arg-semantics formulas value 2 ISNUMBER, N
DV-0062 error-code lattice error-code 2 ERROR.TYPE, INDIRECT
DV-0063 intentional-spec lattice value 2 COLUMN
DV-0064 precision ironcalc value 2 PI, RADIANS
DV-0065 precision hyperformula value 2 PI, RADIANS
DV-0066 precision libreoffice value 2 PI, RADIANS
DV-0067 arg-semantics formulas value 2 CEILING.PRECISE, ISO.CEILING
DV-0068 precision ironcalc value 2 GAMMALN, GAMMALN.PRECISE
DV-0069 precision hyperformula value 2 GAMMALN, GAMMALN.PRECISE
DV-0070 shape formulas value 2 MUNIT
DV-0071 error-code gsheets value 2 MID, PERMUTATIONA
DV-0072 error-code hyperformula value 2 LOGNORMDIST, NORMSDIST
DV-0073 format-rendering hyperformula value 2 TEXT
DV-0074 arg-semantics lattice value 2 NOW, TODAY
DV-0075 shape hyperformulalattice value 2 COLUMN, ROW
DV-0076 precision excelformulasgsheetslatticepycel value 1 op:/
DV-0077 precision ironcalc value 1 op:/
DV-0078 precision hyperformula value 1 op:/
DV-0079 precision libreoffice value 1 op:/
DV-0080 precision excelgsheetslattice value 1 MINVERSE
DV-0081 shape libreoffice value 1 MINVERSE
DV-0082 shape libreoffice value 1 MMULT
DV-0083 error-code excelformulasgsheetslatticelibreoffice value 1 MMULT
DV-0084 shape libreoffice value 1 FREQUENCY
DV-0085 error-code formulas value 1 op:&
DV-0086 shape lattice value 1 LEN
DV-0087 error-code gsheetslattice value 1 op:+
DV-0088 missing-function hyperformula value 1 op:+
DV-0089 arg-semantics formulas value 1 SUMPRODUCT
DV-0090 format-rendering pycel value 1 SUMPRODUCT
DV-0091 format-rendering pycel value 1 SUMPRODUCT
DV-0092 format-rendering pycel value 1 SUMPRODUCT
DV-0093 error-code hyperformulaironcalc value 1 DATEVALUE
DV-0094 error-code gsheetshyperformulaironcalclibreoffice value 1 NETWORKDAYS
DV-0095 error-code gsheetshyperformulaironcalc value 1 WORKDAY
DV-0096 error-code excellattice error-code 1 HSTACK
DV-0097 arg-semantics hyperformulapycel value 1 BITAND
DV-0098 format-rendering pycel value 1 COMPLEX
DV-0099 format-rendering pycel value 1 COMPLEX
DV-0100 format-rendering lattice value 1 COMPLEX
DV-0101 format-rendering pycel value 1 COMPLEX
DV-0102 format-rendering pycel value 1 COMPLEX
DV-0103 format-rendering lattice value 1 COMPLEX
DV-0104 format-rendering lattice value 1 IMSUM
DV-0105 error-code ironcalc value 1 IMSUM
DV-0106 format-rendering lattice value 1 IMSUM
DV-0107 format-rendering lattice value 1 IMSUM
DV-0108 format-rendering lattice value 1 IMSUB
DV-0109 format-rendering lattice value 1 IMSUB
DV-0110 format-rendering lattice value 1 IMSUB
DV-0111 format-rendering lattice value 1 IMPRODUCT
DV-0112 format-rendering lattice value 1 IMPRODUCT
DV-0113 format-rendering lattice value 1 IMPRODUCT
DV-0114 missing-function excel error-code 1 INDIRECT
DV-0115 missing-function gsheetshyperformulalattice value 1 AGGREGATE
DV-0116 arg-semantics lattice error-code 1 IF
DV-0117 shape gsheets value 1 QUERY
DV-0118 shape gsheets value 1 QUERY
DV-0119 error-code excelformulashyperformulaironcalclattice value 1 CUMPRINC
DV-0120 precision gsheets value 1 DDB
DV-0121 precision gsheets value 1 DDB
DV-0122 precision formulas value 1 DDB
DV-0123 precision gsheets value 1 DDB
DV-0124 precision excelformulasgsheetslattice value 1 EFFECT
DV-0125 precision ironcalc value 1 EFFECT
DV-0126 precision hyperformula value 1 EFFECT
DV-0127 precision libreoffice value 1 EFFECT
DV-0128 precision excelformulasgsheetslattice value 1 FV
DV-0129 precision hyperformula value 1 FV
DV-0130 precision libreoffice value 1 FV
DV-0131 precision excel value 1 FV
DV-0132 precision formulasgsheetslattice value 1 FV
DV-0133 precision hyperformula value 1 FV
DV-0134 precision libreoffice value 1 FV
DV-0135 arg-semantics excelgsheetshyperformulalatticelibreoffice value 1 FVSCHEDULE
DV-0136 arg-semantics formulas value 1 FVSCHEDULE
DV-0137 precision formulas value 1 FVSCHEDULE
DV-0138 precision excelgsheetslattice value 1 IPMT
DV-0139 precision ironcalc value 1 IPMT
DV-0140 precision hyperformula value 1 IPMT
DV-0141 precision libreoffice value 1 IPMT
DV-0142 arg-semantics hyperformula value 1 IPMT
DV-0143 precision excelformulasgsheetslattice value 1 NOMINAL
DV-0144 precision excelformulasgsheetslatticelibreofficepycel value 1 NPV
DV-0145 arg-semantics ironcalc value 1 NPV
DV-0146 precision hyperformula value 1 NPV
DV-0147 precision excelgsheetslattice value 1 PDURATION
DV-0148 precision ironcalc value 1 PDURATION
DV-0149 precision hyperformula value 1 PDURATION
DV-0150 precision formulas value 1 PDURATION
DV-0151 arg-semantics formulasgsheetslattice value 1 PMT
DV-0152 arg-semantics gsheets value 1 PPMT
DV-0153 arg-semantics lattice value 1 PPMT
DV-0154 arg-semantics ironcalc value 1 PPMT
DV-0155 precision excelformulasgsheetslatticepycel value 1 PV
DV-0156 precision ironcalc value 1 PV
DV-0157 precision hyperformula value 1 PV
DV-0158 precision libreoffice value 1 PV
DV-0159 precision excelformulasgsheetslatticepycel value 1 PV
DV-0160 precision ironcalc value 1 PV
DV-0161 precision hyperformula value 1 PV
DV-0162 precision libreoffice value 1 PV
DV-0163 precision excelformulasgsheetslattice value 1 RRI
DV-0164 precision ironcalc value 1 RRI
DV-0165 precision hyperformula value 1 RRI
DV-0166 precision excelformulasgsheetslattice value 1 SYD
DV-0167 arg-semantics ironcalc value 1 SYD
DV-0168 precision hyperformula value 1 SYD
DV-0169 precision libreoffice value 1 SYD
DV-0170 precision excelformulasgsheetslattice value 1 SYD
DV-0171 arg-semantics ironcalc value 1 SYD
DV-0172 precision hyperformula value 1 SYD
DV-0173 precision libreoffice value 1 SYD
DV-0174 arg-semantics libreoffice value 1 SYD
DV-0175 error-code hyperformulalibreoffice value 1 XNPV
DV-0176 arg-semantics formulas value 1 XNPV
DV-0177 arg-semantics libreoffice value 1 ISNUMBER
DV-0178 arg-semantics formulas value 1 N
DV-0179 arg-semantics pycel value 1 XOR
DV-0180 precision ironcalc value 1 RADIANS
DV-0181 precision hyperformula value 1 RADIANS
DV-0182 precision libreoffice value 1 RADIANS
DV-0183 precision ironcalc value 1 RADIANS
DV-0184 precision hyperformula value 1 RADIANS
DV-0185 precision libreoffice value 1 RADIANS
DV-0186 arg-semantics formulas value 1 FLOOR.PRECISE
DV-0187 precision excel value 1 MULTINOMIAL
DV-0188 precision excel value 1 MULTINOMIAL
DV-0189 precision excel value 1 MULTINOMIAL
DV-0190 format-rendering pycel value 1 FACTDOUBLE
DV-0191 format-rendering pycel value 1 FACTDOUBLE
DV-0192 error-code gsheetshyperformulalatticepycel value 1 FACTDOUBLE
DV-0193 arg-semantics hyperformula value 1 INT
DV-0194 arg-semantics hyperformula value 1 MOD
DV-0195 arg-semantics formulashyperformulapycel value 1 ROUND
DV-0196 precision ironcalc value 1 SQRT
DV-0197 precision hyperformula value 1 SQRT
DV-0198 precision libreoffice value 1 SQRT
DV-0199 format-rendering pycel value 1 SUMPRODUCT
DV-0200 precision ironcalc value 1 EXP
DV-0201 precision hyperformula value 1 EXP
DV-0202 precision libreoffice value 1 EXP
DV-0203 precision excelgsheets value 1 LN
DV-0204 error-code gsheetspycel value 1 POW
DV-0205 precision formulaslattice value 1 CONVERT
DV-0206 precision formulas value 1 CONVERT
DV-0207 null-vs-zero lattice value 1 REGEXREPLACE
DV-0208 arg-semantics lattice value 1 REGEXEXTRACT
DV-0209 error-code excel interaction 1 feature:spill-blocking
DV-0210 missing-function gsheets interaction 1 feature:spill-blocking
DV-0211 error-code excel interaction 1 feature:spill-blocking
DV-0212 missing-function gsheets interaction 1 feature:spill-blocking
DV-0213 error-code excel value 1 FILTER
DV-0214 shape libreofficepycel value 1 lit:array
DV-0215 missing-function hyperformulaironcalc value 1 FORECAST
DV-0216 precision pycel value 1 INTERCEPT
DV-0217 precision pycel value 1 SLOPE
DV-0218 precision excelformulasgsheetslattice value 1 PROB
DV-0219 error-code excelformulasgsheetshyperformulaironcalc value 1 AVERAGEA
DV-0220 arg-semantics libreoffice value 1 COUNT
DV-0221 precision gsheets value 1 GEOMEAN
DV-0222 arg-semantics ironcalclibreoffice value 1 GEOMEAN
DV-0223 error-code libreoffice value 1 STANDARDIZE
DV-0224 precision lattice value 1 BINOM.DIST
DV-0225 precision gsheetslattice value 1 GAMMA
DV-0226 arg-semantics libreoffice value 1 COUNT
DV-0227 error-code excelformulasgsheetshyperformulalattice value 1 CODE
DV-0228 arg-semantics excelformulasgsheetshyperformulaironcalclatticelibreoffice value 1 SEARCH
DV-0229 arg-semantics excelgsheetshyperformulaironcalclatticelibreoffice value 1 SEARCH
DV-0230 arg-semantics excelformulasgsheetslatticelibreoffice value 1 SEARCHB
DV-0231 error-code excelhyperformula value 1 SPLIT
DV-0232 format-rendering lattice value 1 TEXT
DV-0233 format-rendering hyperformula value 1 TEXT
DV-0234 error-code lattice value 1 TEXT
DV-0235 format-rendering hyperformula value 1 TEXT
DV-0236 error-code excelformulasgsheetshyperformula value 1 UNICHAR
DV-0237 error-code excelformulashyperformulaironcalclatticelibreofficepycel value 1 VALUE
DV-0238 error-code excelformulashyperformulaironcalclibreofficepycel value 1 MID
DV-0239 format-rendering pycel value 1 TRIM
DV-0240 arg-semantics lattice value 1 SUM
DV-0241 error-code excellattice value 1 op:+
DV-0242 arg-semantics lattice value 1 SUM
DV-0243 error-code lattice value 1 op:unary+
DV-0244 arg-semantics hyperformulalattice value 1 T
DV-0245 array-handling hyperformula value 1 RAND
DV-0246 arg-semantics lattice volatile 1 RANDBETWEEN
DV-0247 arg-semantics lattice value 1 NOW