Cannot open password protected XLSX file

I have a password-protected excel file created with MS Office of MacOS.
When trying to open it with LibreOffice, it opens a “Text Import” prompt and tries to import gibberish (encrypted stuff I presume).
It doesn’t ask me to enter my password.

What is your LIbreOffice version?

Can you remove the password with MSO on your Mac and than open and protect the file in LibO?

Sounds like a good candidate for a bug report. Can you reproduce the bug by creating a new, sanitized file? (we don’t want to ask you to put any sensitive information up on bugzilla)

similar problem had a solution there: Misleading message wastes time troubleshooting wrong problem