Gnumeric Sheet Functions
Gnumeric currently has 520 functions for use in spreadsheets. 154 of these are unique to Gnumeric.
Bitwise Operations
| Function | Implementation | Testing |
| bitand | Complete | Exhaustive |
| bitlshift | Complete | Exhaustive |
| bitor | Complete | Exhaustive |
| bitrshift | Complete | Exhaustive |
| bitxor | Complete | Exhaustive |
Complex
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 |
Date/Time
Engineering
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 |
Finance
Gnumeric
| Function | Implementation | Testing |
| gnumeric_version | Unique to Gnumeric | Exhaustive |
Information
Logic
| Function | Implementation | Testing |
| and | Complete | Basic |
| false | Complete | Exhaustive |
| if | Complete | Basic |
| iferror | Complete | No Testsuite |
| not | Complete | Basic |
| or | Complete | Basic |
| true | Complete | Exhaustive |
| xor | Unique to Gnumeric | Basic |