Ask Your Question

Hash incompatible in calc spreadsheet

asked 2019-03-04 23:24:45 +0100

ilike gravatar image

updated 2020-07-20 17:39:48 +0100

Alex Kemp gravatar image

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)

edit retag flag offensive close merge delete

3 Answers

Sort by » oldest newest most voted

answered 2019-03-05 13:30:51 +0100

ilike gravatar image

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.

edit flag offensive delete link more


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

Mike Kaganski gravatar imageMike Kaganski ( 2019-03-05 13:32:45 +0100 )edit

Sorry, Mike, but I don't know how to do it. Can you do it for me? Please look at this file 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 )

ilike gravatar imageilike ( 2019-03-05 14:30:36 +0100 )edit

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

Mike Kaganski gravatar imageMike Kaganski ( 2019-03-07 09:55:40 +0100 )edit

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

ilike gravatar imageilike ( 2019-03-07 10:16:46 +0100 )edit

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 :-)

Mike Kaganski gravatar imageMike Kaganski ( 2019-03-07 10:23:58 +0100 )edit

Thank you again, Mike ))

ilike gravatar imageilike ( 2019-03-07 10:56:56 +0100 )edit

answered 2020-08-27 17:03:50 +0100

Had same problem in LO 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.

edit flag offensive delete link more

answered 2019-03-04 23:55:47 +0100

erAck gravatar image

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.

edit flag offensive delete link more


Filed tdf#123877.

Mike Kaganski gravatar imageMike Kaganski ( 2019-03-05 16:39:52 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-03-04 23:24:45 +0100

Seen: 3,378 times

Last updated: Aug 27 '20