Install OpenOffice from cmd line Redhat Linux 6

I stupidly removed OpenOffice from my work laptop and have not managed to re-install it . As it is a work laptop, I have no internet access (just intranet) so I can't download it directly. I downloaded the repository of OpenOffice from a YUM server but can't get OpenOffice to open any spreadsheets. Any ideas where to go from here? Just some more information: I used yum install openoffice and then checked that the rpm was there by typing rpm -q openoffice. Also the openoffice directory is there but I think that's from the original install.