Can I transfer spreadsheet data from OpenOffice?

I just found out that OpenOffice is no longer supported. Can I transfer spreadsheets from OpenOffice to LibreOffice? Also, I had some password protected documents in OpenOffice that I cannot open since the support group didn’t update OpenOffice for Mac’s Mountain Lion update. Is there any way to get those files open?

You don’t need to transfer anything (LibO and AOO use the same format of files). Just download latest LibO version for Mac and try to open your files.