At a guess...
The version of Gnumeric is old, predating more recent features, and as a result can't open all the latest file types accurately. Same as Excel 95 probably wouldn't open Excel 2003 formats accurately.
The only solution is to save the Excel down to an older format and try again.
Or see if you can get a better spreadsheet package for pdaXrom