Free office packages are all you need unless it comes to spreadsheets with certain types of macros.
When Open Office does not open files, try Libre Office as well. It split off from Open Office and seems to be the better updated version right now.