what version of gnumeric do you use? your example opens fine with gnumeric 1.7.2-1ubuntu1 on my desktop -- gnumeric can't read formule from a gnumeric file create with gnumeric windows https://launchpad.net/bugs/45342