Unable to open password protected file that has just been created

Have just created spreadsheet and saved it in xlsx format with a password. When I try to open it it tells me the password is incorrect. Are there any limitations in what can and can’t be included in a password and if so why does it accept the password? I’m using Libre Office v5.4 and the spreadsheet has been created using the same. Just have to save in xlsx format as others need to be given access

Does it happen if you create a new file?, I have test and no issue here.

I’ve got exactly the same problem.

Do you have tested with a newer version? I have tested again with Versión: 5.4.6.2 without problem.