It seems to have been an account error. When I created a new user, gnumeric worked fine. As such I'll close this bug.
** Changed in: gnumeric (Ubuntu)
Status: Unconfirmed => Rejected
--
gnumeric (1.6.3 Dapper Flight 6) missing functions and chart
https://launchpad.net/malone/bugs/39699