How do I read the data of a damaged encrypted file? (With correct password)

Yesterday, when I use LibreOffice Calc to process my spreadsheets and archive errors happened.
This file is encrypted and I still remember the correct password file.
When I re-open the file and typed the correct password the screen pop out the message: “fatal Error: bad allocation”, and I cannot open this file anymore.
If I intentionally enter the wrong password the screen would poped out another message like:“Worog Password”.
I only want to recover the numbers recorded in the file so I try to decompress the ods file but still get the encrypted “content.xml” file. Is there any way to read the data of the damaged encrypted file? (With the correct password)