OpenOffice files are not to be opened with Spreadsheet::ParseExcel.
For OpenOffice there is Spreadsheet::ReadSXC, which also happens to happily parse OO-2.0 (ods) files.
CPAN::Forum
Spreadsheet-ParseExcel - Re: problem reading number in openoffice calc File