Ask Your Question
0

Hash incompatible in calc spreadsheet

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

ilike gravatar image

updated 2019-03-04 23:25:39 +0200

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

2 Answers

Sort by » oldest newest most voted
0

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

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

Comments

Filed tdf#123877.

Mike Kaganski gravatar imageMike Kaganski ( 2019-03-05 16:39:52 +0200 )edit
0

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

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

Comments

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

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

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 )

ilike gravatar imageilike ( 2019-03-05 14:30:36 +0200 )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 +0200 )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 +0200 )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 +0200 )edit

Thank you again, Mike ))

ilike gravatar imageilike ( 2019-03-07 10:56:56 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 361 times

Last updated: Mar 05