Hash incompatible in calc spreadsheet

ilike · March 4, 2019, 10:24pm

I am open XLSX document with some password protected sheets, made in MS excel. After that, I make some changes in Calc (in non-protected cells). I don’t close the table and some time later (usually 5 -10 minutes) I see the error displayed is ‘Hash incompatible’. I think it’s problem with incorrect document autosaving. OpenOffice has same problems too.

Error:
Re-type Password

The document you are about to export has one or more protected
items with password that cannot be exported. Please re-type your
password to be able to export your document.

Document protection: Not protected
Sheet protection: Line 5 Hash incompatible (Re-Type)

ilike · March 5, 2019, 12:30pm

I think I found a temporary solution:
It seems we need to uncheck “Save Autorecovery information every: 10 minutes”

Tools - Options - Load/Save - General - Save:
Uncheck Save Autorecovery information every: 10 minutes

I still think that there is an error in the Аutosave mechanism. Because if I just save the table (Tap File - Save or just press Ctrl+S) this error doesn’t occur.

mikekaganski · March 5, 2019, 12:32pm

Please file a bug report, and provide a sample document there. Thanks!

ilike · March 5, 2019, 1:30pm

Sorry, Mike, but I don’t know how to do it. Can you do it for me?
Please look at this file https://ufile.io/dcig7
Just open it, put some digits in any white cell and wait about 10min (I reduced the waiting time to 1 minute for convenience, in Save Autorecovery information every: 10 minutes )

mikekaganski · March 7, 2019, 8:55am

Sigh. I see you filed another one - tdf#123920 - after mine that I mentioned in a comment to @erAck’s answer.

ilike · March 7, 2019, 9:16am

Yes, I finally figured out how to create a bug report. Probably, I should not create a duplicate

mikekaganski · March 7, 2019, 9:23am

No problem - thanks - actually it’s great you can do that now; hopefully it would be easy for you to report any problems you might find in the future

ilike · March 7, 2019, 9:56am

Thank you again, Mike ))

erAck · March 4, 2019, 10:55pm

Can happen. There are different algorithms to calculate password hashes and maybe stored by Excel was one that is not written by Calc, in which case the password has to be entered to calculate a new hash with another algorithm.

mikekaganski · March 5, 2019, 3:39pm

Filed tdf#123877.

elgaard · August 27, 2020, 3:03pm

Had same problem in LO 7.0.1.1.0
I got around this in the following way:

Both sheets were protected, marked with a padlock. I could not unprotect them without the password.

Try to save as ODS, get the incompatible hash pop-up error
for each protected sheet do:

click on “retype”
clear “New password must match the original password” checkbox
type e.g., “a” as both password and confirm
(remove password from from this protected item does not work)

now for each protected sheet right-click and choose “protect”, enter the password (“a”)

You sheets are now not protected and you can save as ods, xslx, etc and autosaving should work.