1. Gnumeric Sheet Functions
Gnumeric currently has 607 functions for use in spreadsheets. 214 of these are unique to Gnumeric.
2. Bitwise Operations
Function |
Implementation |
Testing |
bitand |
Complete |
Exhaustive |
bitlshift |
Complete |
Exhaustive |
bitor |
Complete |
Exhaustive |
bitrshift |
Complete |
Exhaustive |
bitxor |
Complete |
Exhaustive |
3. Complex
Function |
Implementation |
Testing |
complex |
Complete |
Basic |
imabs |
Complete |
Basic |
imaginary |
Complete |
Basic |
imarccos |
Complete |
Basic |
imarccosh |
Complete |
Basic |
imarccot |
Complete |
Basic |
imarccoth |
Complete |
Basic |
imarccsc |
Complete |
Basic |
imarccsch |
Complete |
Basic |
imarcsec |
Complete |
Basic |
imarcsech |
Complete |
Basic |
imarcsin |
Complete |
Basic |
imarcsinh |
Complete |
Basic |
imarctan |
Complete |
Basic |
imarctanh |
Complete |
Basic |
imargument |
Complete |
Basic |
imconjugate |
Complete |
Basic |
imcos |
Complete |
Basic |
imcosh |
Complete |
Basic |
imcot |
Complete |
Basic |
imcoth |
Complete |
Basic |
imcsc |
Complete |
Basic |
imcsch |
Complete |
Basic |
imdiv |
Complete |
Basic |
imexp |
Complete |
Basic |
imfact |
Unique to Gnumeric |
No Testsuite |
imgamma |
Unique to Gnumeric |
No Testsuite |
imigamma |
Unique to Gnumeric |
No Testsuite |
iminv |
Unique to Gnumeric |
No Testsuite |
imln |
Complete |
Basic |
imlog10 |
Complete |
Basic |
imlog2 |
Complete |
Basic |
imneg |
Complete |
Basic |
impower |
Complete |
Basic |
improduct |
Complete |
Basic |
imreal |
Complete |
Basic |
imsec |
Complete |
Basic |
imsech |
Complete |
Basic |
imsin |
Complete |
Basic |
imsinh |
Complete |
Basic |
imsqrt |
Complete |
Basic |
imsub |
Complete |
Basic |
imsum |
Complete |
Basic |
imtan |
Complete |
Basic |
imtanh |
Complete |
Basic |
4. Database
Function |
Implementation |
Testing |
daverage |
Complete |
Basic |
dcount |
Complete |
Basic |
dcounta |
Complete |
Basic |
dget |
Complete |
Basic |
dmax |
Complete |
Basic |
dmin |
Complete |
Basic |
dproduct |
Complete |
Basic |
dstdev |
Complete |
Basic |
dstdevp |
Complete |
Basic |
dsum |
Complete |
Basic |
dvar |
Complete |
Basic |
dvarp |
Complete |
Basic |
getpivotdata |
Subset |
No Testsuite |
5. Date/Time
Function |
Implementation |
Testing |
ascensionthursday |
Unique to Gnumeric |
No Testsuite |
ashwednesday |
Unique to Gnumeric |
No Testsuite |
date |
Complete |
Basic |
date2hdate |
Unique to Gnumeric |
No Testsuite |
date2hdate_heb |
Unique to Gnumeric |
No Testsuite |
date2julian |
Unique to Gnumeric |
No Testsuite |
date2unix |
Unique to Gnumeric |
No Testsuite |
datedif |
Complete |
Basic |
datevalue |
Complete |
Basic |
day |
Complete |
Basic |
days |
Unique to Gnumeric |
No Testsuite |
days360 |
Complete |
Basic |
eastersunday |
Unique to Gnumeric |
No Testsuite |
edate |
Complete |
Basic |
eomonth |
Complete |
Basic |
goodfriday |
Unique to Gnumeric |
No Testsuite |
hdate |
Unique to Gnumeric |
No Testsuite |
hdate_day |
Unique to Gnumeric |
No Testsuite |
hdate_heb |
Unique to Gnumeric |
No Testsuite |
hdate_julian |
Unique to Gnumeric |
No Testsuite |
hdate_month |
Unique to Gnumeric |
No Testsuite |
hdate_year |
Unique to Gnumeric |
No Testsuite |
hour |
Complete |
Basic |
isoweeknum |
Unique to Gnumeric |
No Testsuite |
isoyear |
Unique to Gnumeric |
No Testsuite |
minute |
Complete |
Basic |
month |
Complete |
Basic |
networkdays |
Complete |
Basic |
now |
Complete |
Basic |
odf.time |
Complete |
No Testsuite |
pentecostsunday |
Unique to Gnumeric |
No Testsuite |
second |
Complete |
Basic |
time |
Complete |
Basic |
timevalue |
Complete |
Basic |
today |
Complete |
Basic |
unix2date |
Unique to Gnumeric |
No Testsuite |
weekday |
Complete |
Basic |
weeknum |
Complete |
Basic |
workday |
Subset |
Basic |
year |
Complete |
Basic |
yearfrac |
Complete |
No Testsuite |
6. Engineering
Function |
Implementation |
Testing |
base |
Unique to Gnumeric |
No Testsuite |
besseli |
Complete |
Basic |
besselj |
Complete |
Basic |
besselk |
Complete |
Basic |
bessely |
Complete |
Basic |
bin2dec |
Complete |
Basic |
bin2hex |
Complete |
Basic |
bin2oct |
Complete |
Basic |
convert |
Complete |
Basic |
dec2bin |
Complete |
Basic |
dec2hex |
Complete |
Basic |
dec2oct |
Complete |
Basic |
decimal |
Unique to Gnumeric |
No Testsuite |
delta |
Complete |
Basic |
erf |
Complete |
Basic |
erfc |
Complete |
Basic |
gestep |
Complete |
Basic |
hex2bin |
Complete |
Basic |
hex2dec |
Complete |
Basic |
hex2oct |
Complete |
Basic |
hexrep |
Unique to Gnumeric |
No Testsuite |
invsuminv |
Unique to Gnumeric |
No Testsuite |
oct2bin |
Complete |
Basic |
oct2dec |
Complete |
Basic |
oct2hex |
Complete |
Basic |
7. Erlang
Function |
Implementation |
Testing |
dimcirc |
Unique to Gnumeric |
No Testsuite |
offcap |
Unique to Gnumeric |
No Testsuite |
offtraf |
Unique to Gnumeric |
No Testsuite |
probblock |
Unique to Gnumeric |
No Testsuite |
8. Finance
Function |
Implementation |
Testing |
accrint |
Complete |
Basic |
accrintm |
Complete |
Basic |
amordegrc |
Complete |
Basic |
amorlinc |
Complete |
Basic |
coupdaybs |
Complete |
Basic |
coupdays |
Complete |
Basic |
coupdaysnc |
Complete |
Basic |
coupncd |
Complete |
Basic |
coupnum |
Complete |
Basic |
couppcd |
Complete |
Basic |
cum_biv_norm_dist |
Unique to Gnumeric |
No Testsuite |
cumipmt |
Complete |
Basic |
cumprinc |
Complete |
Basic |
db |
Complete |
Basic |
ddb |
Complete |
Basic |
disc |
Complete |
Basic |
dollarde |
Complete |
Basic |
dollarfr |
Complete |
Basic |
duration |
Complete |
Basic |
effect |
Complete |
Basic |
euro |
Unique to Gnumeric |
Basic |
euroconvert |
Complete |
Basic |
fv |
Complete |
Basic |
fvschedule |
Complete |
Basic |
g_duration |
Unique to Gnumeric |
Basic |
intrate |
Complete |
Basic |
ipmt |
Complete |
Basic |
irr |
Complete |
Basic |
ispmt |
Complete |
Basic |
mduration |
Complete |
Basic |
mirr |
Complete |
Basic |
nominal |
Complete |
Basic |
nper |
Complete |
Basic |
npv |
Complete |
Basic |
oddfprice |
Complete |
Basic |
oddfyield |
Complete |
Basic |
oddlprice |
Complete |
Basic |
oddlyield |
Complete |
Basic |
opt_2_asset_correlation |
Unique to Gnumeric |
Basic |
opt_amer_exchange |
Unique to Gnumeric |
Basic |
opt_baw_amer |
Unique to Gnumeric |
Basic |
opt_binomial |
Unique to Gnumeric |
Basic |
opt_bjer_stens |
Unique to Gnumeric |
Basic |
opt_bs |
Unique to Gnumeric |
Basic |
opt_bs_carrycost |
Unique to Gnumeric |
Basic |
opt_bs_delta |
Unique to Gnumeric |
Basic |
opt_bs_gamma |
Unique to Gnumeric |
Basic |
opt_bs_rho |
Unique to Gnumeric |
Basic |
opt_bs_theta |
Unique to Gnumeric |
Basic |
opt_bs_vega |
Unique to Gnumeric |
Basic |
opt_complex_chooser |
Unique to Gnumeric |
Basic |
opt_euro_exchange |
Unique to Gnumeric |
Basic |
opt_exec |
Unique to Gnumeric |
Basic |
opt_extendible_writer |
Unique to Gnumeric |
Basic |
opt_fixed_strk_lkbk |
Unique to Gnumeric |
Basic |
opt_float_strk_lkbk |
Unique to Gnumeric |
Basic |
opt_forward_start |
Unique to Gnumeric |
Basic |
opt_french |
Unique to Gnumeric |
Basic |
opt_garman_kohlhagen |
Unique to Gnumeric |
Basic |
opt_jump_diff |
Unique to Gnumeric |
Basic |
opt_miltersen_schwartz |
Unique to Gnumeric |
Basic |
opt_on_options |
Unique to Gnumeric |
Basic |
opt_rgw |
Unique to Gnumeric |
Basic |
opt_simple_chooser |
Unique to Gnumeric |
Basic |
opt_spread_approx |
Unique to Gnumeric |
Basic |
opt_time_switch |
Unique to Gnumeric |
Basic |
pmt |
Complete |
Basic |
ppmt |
Complete |
Basic |
price |
Complete |
Basic |
pricedisc |
Complete |
Basic |
pricemat |
Complete |
Basic |
pv |
Complete |
Basic |
rate |
Complete |
Basic |
received |
Complete |
Basic |
rri |
Complete |
No Testsuite |
sln |
Complete |
Basic |
syd |
Complete |
Basic |
tbilleq |
Complete |
Basic |
tbillprice |
Complete |
Basic |
tbillyield |
Complete |
Basic |
vdb |
Complete |
Basic |
xirr |
Complete |
Basic |
xnpv |
Complete |
Basic |
yield |
Complete |
Basic |
yielddisc |
Complete |
Basic |
yieldmat |
Complete |
Basic |
9. Gnumeric
Function |
Implementation |
Testing |
gnumeric_version |
Unique to Gnumeric |
Exhaustive |
10. Information
Function |
Implementation |
Testing |
cell |
Subset with_extensions |
Basic |
countblank |
Complete |
Basic |
error |
Unique to Gnumeric |
No Testsuite |
error.type |
Complete |
Basic |
expression |
Unique to Gnumeric |
No Testsuite |
get.formula |
Complete |
No Testsuite |
get.link |
Unique to Gnumeric |
No Testsuite |
getenv |
Unique to Gnumeric |
No Testsuite |
info |
Complete |
Basic |
isblank |
Complete |
Basic |
iserr |
Complete |
Basic |
iserror |
Complete |
Basic |
iseven |
Complete |
Basic |
isformula |
Unique to Gnumeric |
No Testsuite |
islogical |
Complete |
Basic |
isna |
Complete |
Basic |
isnontext |
Complete |
Basic |
isnumber |
Complete |
Basic |
isodd |
Complete |
Basic |
isref |
Complete |
Basic |
istext |
Complete |
Basic |
n |
Complete |
Basic |
na |
Complete |
Basic |
type |
Complete |
Basic |
11. Logic
Function |
Implementation |
Testing |
and |
Complete |
Basic |
false |
Complete |
Exhaustive |
if |
Complete |
Basic |
iferror |
Complete |
No Testsuite |
ifna |
Unique to Gnumeric |
No Testsuite |
not |
Complete |
Basic |
or |
Complete |
Basic |
true |
Complete |
Exhaustive |
xor |
Unique to Gnumeric |
Basic |
12. Lookup
Function |
Implementation |
Testing |
address |
Complete |
Exhaustive |
areas |
Complete |
Basic |
array |
Unique to Gnumeric |
No Testsuite |
choose |
Complete |
Basic |
column |
Complete |
Basic |
columnnumber |
Unique to Gnumeric |
No Testsuite |
columns |
Complete |
Basic |
flip |
Unique to Gnumeric |
No Testsuite |
hlookup |
Complete |
Basic |
hyperlink |
Subset |
Basic |
index |
Complete |
Basic |
indirect |
Complete |
Basic |
lookup |
Complete |
Basic |
match |
Complete |
Basic |
offset |
Complete |
Basic |
row |
Complete |
Basic |
rows |
Complete |
Basic |
sheet |
Unique to Gnumeric |
No Testsuite |
sheets |
Unique to Gnumeric |
No Testsuite |
sort |
Unique to Gnumeric |
No Testsuite |
transpose |
Complete |
Basic |
vlookup |
Complete |
Basic |
13. Mathematics
Function |
Implementation |
Testing |
abs |
Complete |
Exhaustive |
acos |
Complete |
Exhaustive |
acosh |
Complete |
Exhaustive |
acot |
Complete |
No Testsuite |
acoth |
Complete |
No Testsuite |
arabic |
Complete |
No Testsuite |
asin |
Complete |
Exhaustive |
asinh |
Complete |
Exhaustive |
atan |
Complete |
Exhaustive |
atan2 |
Complete |
Exhaustive |
atanh |
Complete |
Exhaustive |
averageif |
Complete |
No Testsuite |
beta |
Unique to Gnumeric |
No Testsuite |
betaln |
Unique to Gnumeric |
No Testsuite |
ceil |
Unique to Gnumeric |
No Testsuite |
ceiling |
Complete |
Basic |
cholesky |
Unique to Gnumeric |
No Testsuite |
combin |
Complete |
Basic |
combina |
Complete |
No Testsuite |
cos |
Complete |
Exhaustive |
cosh |
Complete |
Exhaustive |
cospi |
Unique to Gnumeric |
Exhaustive |
cot |
Complete |
No Testsuite |
coth |
Complete |
No Testsuite |
countif |
Complete |
Basic |
csc |
Unique to Gnumeric |
No Testsuite |
csch |
Unique to Gnumeric |
No Testsuite |
degrees |
Complete |
Exhaustive |
eigen |
Unique to Gnumeric |
No Testsuite |
even |
Complete |
Basic |
exp |
Complete |
Basic |
expm1 |
Unique to Gnumeric |
No Testsuite |
fact |
Superset |
Basic |
factdouble |
Complete |
Basic |
fib |
Complete |
Basic |
floor |
Complete |
Basic |
g_product |
Complete |
Basic |
gamma |
Unique to Gnumeric |
No Testsuite |
gammaln |
Complete |
Basic |
gcd |
Complete |
Basic |
gd |
Complete |
No Testsuite |
hypot |
Unique to Gnumeric |
No Testsuite |
igamma |
Unique to Gnumeric |
No Testsuite |
int |
Complete |
Basic |
lcm |
Complete |
Basic |
linsolve |
Unique to Gnumeric |
No Testsuite |
ln |
Complete |
Basic |
ln1p |
Unique to Gnumeric |
No Testsuite |
log |
Complete |
Basic |
log10 |
Complete |
Basic |
log2 |
Complete |
Basic |
mdeterm |
Complete |
Basic |
minverse |
Complete |
Basic |
mmult |
Complete |
Basic |
mod |
Complete |
Basic |
mpseudoinverse |
Unique to Gnumeric |
No Testsuite |
mround |
Complete |
Basic |
multinomial |
Complete |
Basic |
munit |
Complete |
No Testsuite |
odd |
Complete |
Basic |
odf.sumproduct |
Complete |
No Testsuite |
pi |
Complete |
Exhaustive |
pochhammer |
Unique to Gnumeric |
No Testsuite |
power |
Superset |
Basic |
product |
Complete |
Basic |
quotient |
Complete |
Basic |
radians |
Complete |
Exhaustive |
roman |
Complete |
Basic |
round |
Complete |
Basic |
rounddown |
Complete |
Basic |
roundup |
Complete |
Basic |
sec |
Unique to Gnumeric |
No Testsuite |
sech |
Unique to Gnumeric |
No Testsuite |
seriessum |
Complete |
Basic |
sign |
Complete |
Basic |
sin |
Complete |
Exhaustive |
sinh |
Complete |
Exhaustive |
sinpi |
Unique to Gnumeric |
Exhaustive |
sqrt |
Complete |
Basic |
sqrtpi |
Complete |
Basic |
sum |
Complete |
Basic |
suma |
Complete |
Basic |
sumif |
Complete |
Basic |
sumproduct |
Complete |
Basic |
sumsq |
Complete |
Basic |
sumx2my2 |
Complete |
Basic |
sumx2py2 |
Complete |
Basic |
sumxmy2 |
Complete |
Basic |
tan |
Complete |
Exhaustive |
tanh |
Complete |
Exhaustive |
trunc |
Complete |
Basic |
14. Number Theory
Function |
Implementation |
Testing |
isprime |
Unique to Gnumeric |
No Testsuite |
ithprime |
Unique to Gnumeric |
No Testsuite |
nt_d |
Unique to Gnumeric |
No Testsuite |
nt_mu |
Unique to Gnumeric |
No Testsuite |
nt_omega |
Unique to Gnumeric |
No Testsuite |
nt_phi |
Unique to Gnumeric |
No Testsuite |
nt_pi |
Unique to Gnumeric |
No Testsuite |
nt_sigma |
Unique to Gnumeric |
No Testsuite |
pfactor |
Unique to Gnumeric |
No Testsuite |
15. Random Numbers
Function |
Implementation |
Testing |
rand |
Complete |
Basic |
randbernoulli |
Unique to Gnumeric |
No Testsuite |
randbeta |
Unique to Gnumeric |
No Testsuite |
randbetween |
Complete |
Basic |
randbinom |
Unique to Gnumeric |
No Testsuite |
randcauchy |
Unique to Gnumeric |
No Testsuite |
randchisq |
Unique to Gnumeric |
No Testsuite |
randdiscrete |
Unique to Gnumeric |
No Testsuite |
randexp |
Unique to Gnumeric |
No Testsuite |
randexppow |
Unique to Gnumeric |
No Testsuite |
randfdist |
Unique to Gnumeric |
No Testsuite |
randgamma |
Unique to Gnumeric |
No Testsuite |
randgeom |
Unique to Gnumeric |
No Testsuite |
randgumbel |
Unique to Gnumeric |
No Testsuite |
randhyperg |
Unique to Gnumeric |
No Testsuite |
randlandau |
Unique to Gnumeric |
No Testsuite |
randlaplace |
Unique to Gnumeric |
No Testsuite |
randlevy |
Unique to Gnumeric |
No Testsuite |
randlog |
Unique to Gnumeric |
No Testsuite |
randlogistic |
Unique to Gnumeric |
No Testsuite |
randlognorm |
Unique to Gnumeric |
No Testsuite |
randnegbinom |
Unique to Gnumeric |
No Testsuite |
randnorm |
Unique to Gnumeric |
No Testsuite |
randnormtail |
Unique to Gnumeric |
No Testsuite |
randpareto |
Unique to Gnumeric |
No Testsuite |
randpoisson |
Unique to Gnumeric |
No Testsuite |
randrayleigh |
Unique to Gnumeric |
No Testsuite |
randrayleightail |
Unique to Gnumeric |
No Testsuite |
randsnorm |
Unique to Gnumeric |
No Testsuite |
randstdist |
Unique to Gnumeric |
No Testsuite |
randtdist |
Unique to Gnumeric |
No Testsuite |
randuniform |
Unique to Gnumeric |
No Testsuite |
randweibull |
Unique to Gnumeric |
No Testsuite |
simtable |
Unique to Gnumeric |
No Testsuite |
16. Statistics
Function |
Implementation |
Testing |
adtest |
Unique to Gnumeric |
No Testsuite |
avedev |
Complete |
Basic |
average |
Complete |
Basic |
averagea |
Complete |
Basic |
bernoulli |
Complete |
Basic |
beta.dist |
Complete |
Basic |
betadist |
Complete |
Basic |
betainv |
Complete |
Basic |
binom.dist.range |
Unique to Gnumeric |
No Testsuite |
binomdist |
Complete |
Basic |
cauchy |
Complete |
Basic |
chidist |
Complete |
Basic |
chiinv |
Complete |
Basic |
chitest |
Complete |
Basic |
confidence |
Complete |
Basic |
correl |
Complete |
Basic |
count |
Complete |
Basic |
counta |
Complete |
Basic |
covar |
Complete |
Basic |
covariance.s |
Complete |
Basic |
critbinom |
Complete |
Basic |
cronbach |
Unique to Gnumeric |
No Testsuite |
cvmtest |
Unique to Gnumeric |
No Testsuite |
devsq |
Complete |
Basic |
expondist |
Complete |
Basic |
exppowdist |
Unique to Gnumeric |
No Testsuite |
fdist |
Complete |
Basic |
finv |
Complete |
Basic |
fisher |
Complete |
Basic |
fisherinv |
Complete |
Basic |
forecast |
Complete |
Basic |
frequency |
Complete |
Basic |
ftest |
Complete |
Basic |
gammadist |
Complete |
Basic |
gammainv |
Complete |
Basic |
geomdist |
Unique to Gnumeric |
No Testsuite |
geomean |
Complete |
Basic |
growth |
Complete |
Basic |
harmean |
Complete |
Basic |
hypgeomdist |
Complete |
Basic |
intercept |
Complete |
Basic |
kurt |
Complete |
Basic |
kurtp |
Unique to Gnumeric |
No Testsuite |
landau |
Unique to Gnumeric |
No Testsuite |
laplace |
Unique to Gnumeric |
No Testsuite |
large |
Complete |
Basic |
leverage |
Unique to Gnumeric |
No Testsuite |
linest |
Complete |
Basic |
lkstest |
Unique to Gnumeric |
No Testsuite |
logest |
Complete |
Basic |
logfit |
Unique to Gnumeric |
No Testsuite |
loginv |
Complete |
Basic |
logistic |
Unique to Gnumeric |
No Testsuite |
lognormdist |
Complete |
Basic |
logreg |
Unique to Gnumeric |
No Testsuite |
max |
Complete |
Basic |
maxa |
Complete |
Basic |
median |
Complete |
Basic |
min |
Complete |
Basic |
mina |
Complete |
Basic |
mode |
Complete |
Basic |
negbinomdist |
Complete |
Basic |
normdist |
Complete |
Basic |
norminv |
Complete |
Basic |
normsdist |
Complete |
Basic |
normsinv |
Complete |
Basic |
owent |
Unique to Gnumeric |
No Testsuite |
pareto |
Unique to Gnumeric |
No Testsuite |
pearson |
Complete |
Basic |
percentile |
Complete |
Basic |
percentrank |
Complete |
Basic |
permut |
Complete |
Basic |
permutationa |
Complete |
No Testsuite |
poisson |
Complete |
Basic |
prob |
Complete |
Basic |
quartile |
Complete |
Basic |
r.dbeta |
Unique to Gnumeric |
No Testsuite |
r.dbinom |
Unique to Gnumeric |
No Testsuite |
r.dcauchy |
Unique to Gnumeric |
No Testsuite |
r.dchisq |
Unique to Gnumeric |
No Testsuite |
r.dexp |
Unique to Gnumeric |
No Testsuite |
r.df |
Unique to Gnumeric |
No Testsuite |
r.dgamma |
Unique to Gnumeric |
No Testsuite |
r.dgeom |
Unique to Gnumeric |
No Testsuite |
r.dhyper |
Unique to Gnumeric |
No Testsuite |
r.dlnorm |
Unique to Gnumeric |
No Testsuite |
r.dnbinom |
Unique to Gnumeric |
No Testsuite |
r.dnorm |
Unique to Gnumeric |
No Testsuite |
r.dpois |
Unique to Gnumeric |
No Testsuite |
r.dsnorm |
Unique to Gnumeric |
No Testsuite |
r.dst |
Unique to Gnumeric |
No Testsuite |
r.dt |
Unique to Gnumeric |
No Testsuite |
r.dweibull |
Unique to Gnumeric |
No Testsuite |
r.pbeta |
Unique to Gnumeric |
No Testsuite |
r.pbinom |
Unique to Gnumeric |
No Testsuite |
r.pcauchy |
Unique to Gnumeric |
No Testsuite |
r.pchisq |
Unique to Gnumeric |
No Testsuite |
r.pexp |
Unique to Gnumeric |
No Testsuite |
r.pf |
Unique to Gnumeric |
No Testsuite |
r.pgamma |
Unique to Gnumeric |
No Testsuite |
r.pgeom |
Unique to Gnumeric |
No Testsuite |
r.phyper |
Unique to Gnumeric |
No Testsuite |
r.plnorm |
Unique to Gnumeric |
No Testsuite |
r.pnbinom |
Unique to Gnumeric |
No Testsuite |
r.pnorm |
Unique to Gnumeric |
No Testsuite |
r.ppois |
Unique to Gnumeric |
No Testsuite |
r.psnorm |
Unique to Gnumeric |
No Testsuite |
r.pst |
Unique to Gnumeric |
No Testsuite |
r.pt |
Unique to Gnumeric |
No Testsuite |
r.ptukey |
Unique to Gnumeric |
No Testsuite |
r.pweibull |
Unique to Gnumeric |
No Testsuite |
r.qbeta |
Unique to Gnumeric |
No Testsuite |
r.qbinom |
Unique to Gnumeric |
No Testsuite |
r.qcauchy |
Unique to Gnumeric |
No Testsuite |
r.qchisq |
Unique to Gnumeric |
No Testsuite |
r.qexp |
Unique to Gnumeric |
No Testsuite |
r.qf |
Unique to Gnumeric |
No Testsuite |
r.qgamma |
Unique to Gnumeric |
No Testsuite |
r.qgeom |
Unique to Gnumeric |
No Testsuite |
r.qhyper |
Unique to Gnumeric |
No Testsuite |
r.qlnorm |
Unique to Gnumeric |
No Testsuite |
r.qnbinom |
Unique to Gnumeric |
No Testsuite |
r.qnorm |
Unique to Gnumeric |
No Testsuite |
r.qpois |
Unique to Gnumeric |
No Testsuite |
r.qsnorm |
Unique to Gnumeric |
No Testsuite |
r.qst |
Unique to Gnumeric |
No Testsuite |
r.qt |
Unique to Gnumeric |
No Testsuite |
r.qtukey |
Unique to Gnumeric |
No Testsuite |
r.qweibull |
Unique to Gnumeric |
No Testsuite |
rank |
Complete |
Basic |
rank.avg |
Complete |
No Testsuite |
rayleigh |
Unique to Gnumeric |
No Testsuite |
rayleightail |
Unique to Gnumeric |
No Testsuite |
rsq |
Complete |
Basic |
sftest |
Unique to Gnumeric |
No Testsuite |
skew |
Complete |
Basic |
skewp |
Unique to Gnumeric |
No Testsuite |
slope |
Complete |
Basic |
small |
Complete |
Basic |
snorm.dist.range |
Unique to Gnumeric |
No Testsuite |
ssmedian |
Unique to Gnumeric |
No Testsuite |
standardize |
Complete |
Basic |
stdev |
Complete |
Basic |
stdeva |
Complete |
Basic |
stdevp |
Complete |
Basic |
stdevpa |
Complete |
Basic |
steyx |
Complete |
Basic |
subtotal |
Complete |
Basic |
tdist |
Complete |
Basic |
tinv |
Complete |
Basic |
trend |
Complete |
Basic |
trimmean |
Complete |
Basic |
ttest |
Complete |
Basic |
var |
Complete |
Basic |
vara |
Complete |
Basic |
varp |
Complete |
Basic |
varpa |
Complete |
Basic |
weibull |
Complete |
Basic |
ztest |
Complete |
Basic |
17. String
Function |
Implementation |
Testing |
asc |
Complete |
No Testsuite |
char |
Complete |
Basic |
clean |
Complete |
Basic |
code |
Complete |
Basic |
concatenate |
Complete |
Basic |
dollar |
Complete |
Basic |
exact |
Complete |
Basic |
find |
Complete |
Basic |
findb |
Complete |
No Testsuite |
fixed |
Complete |
Basic |
jis |
Complete |
No Testsuite |
left |
Complete |
Basic |
leftb |
Complete |
No Testsuite |
len |
Complete |
Basic |
lenb |
Complete |
No Testsuite |
lower |
Complete |
Basic |
mid |
Complete |
Basic |
midb |
Complete |
No Testsuite |
numbervalue |
Unique to Gnumeric |
Basic |
proper |
Complete |
Basic |
replace |
Complete |
Basic |
replaceb |
Complete |
No Testsuite |
rept |
Complete |
Basic |
right |
Complete |
Basic |
rightb |
Complete |
No Testsuite |
search |
Complete |
Basic |
searchb |
Complete |
No Testsuite |
substitute |
Complete |
Basic |
t |
Complete |
Basic |
text |
Complete |
Basic |
trim |
Complete |
Basic |
unichar |
Unique to Gnumeric |
Basic |
unicode |
Unique to Gnumeric |
Basic |
upper |
Complete |
Basic |
value |
Complete |
Basic |
18. Time Series Analysis
Function |
Implementation |
Testing |
fourier |
Complete |
Basic |
hpfilter |
Complete |
Basic |
interpolation |
Complete |
Basic |
periodogram |
Complete |
Basic |