Download it now!
Bug 123877 - "Hash incompatible" in calc spreadsheet
Summary: "Hash incompatible" in calc spreadsheet
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) rc
Hardware: All All
: medium normal
Assignee: Not Assigned
: 123920 (view as bug list)
Depends on:
Blocks: XLSX-Sheet
  Show dependency treegraph
Reported: 2019-03-05 15:39 UTC by Mike Kaganski
Modified: 2020-08-11 09:05 UTC (History)
7 users (show)

See Also:
Crash report or crash signature:

Spreadsheet giving "Re-type Password" on saving autorecovery information (15.52 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-03-05 15:39 UTC, Mike Kaganski
Simple reproducer document (9.42 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2020-02-27 11:22 UTC, Gabor Kelemen
Screenshot of the reproducer document (39.58 KB, image/png)
2020-02-27 11:24 UTC, Gabor Kelemen

Note You need to log in before you can comment on or make changes to this bug.
Description Mike Kaganski 2019-03-05 15:39:37 UTC
Created attachment 149748 [details]
Spreadsheet giving "Re-type Password" on saving autorecovery information


Open attachment; make a minimal edit and let Save AutoRecovery information timeout pass; on auto-saving, a dialog "Re-type Password" appears with "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" text.

Tested with Version: (x64)
Build ID: 7bcb35dc3024a62dea0caee87020152d1ee96e71
CPU threads: 12; OS: Windows 10.0; UI render: default; VCL: win; 
Locale: ru-RU (ru_RU); UI-Language: en-US
Calc: threaded
Comment 1 Oliver Brinzing 2019-03-08 17:54:41 UTC
*** Bug 123920 has been marked as a duplicate of this bug. ***
Comment 2 Stephan van den Akker 2019-06-11 09:45:35 UTC
I can confirm this problem on openSUSE Tumbleweed 20190607 in version:

Build ID: 20(Build:2)
CPU threads: 8; OS: Linux 5.1; UI render: default; VCL: gtk3; 
Locale: en-GB (en_GB.UTF-8); UI-Language: en-GB
Calc: threaded

While reading through a XLSX document provided by the Dutch Government.
Comment 3 Gabor Kelemen 2020-02-27 11:22:41 UTC
Created attachment 158225 [details]
Simple reproducer document

This also happens when saving Excel 2016 made XLSX files with sheet protection to ODS format.

This started to happen since 6.1, 6.0 did not read the password yet.
Comment 4 Gabor Kelemen 2020-02-27 11:24:29 UTC
Created attachment 158226 [details]
Screenshot of the reproducer document

Version: (x64)
Build ID: 41177730421f9be9ad955766a5a19667d8003b11
CPU threads: 8; OS: Windows 10.0 Build 17134; UI render: GL; VCL: win; 
Locale: hu-HU (hu_HU); UI-Language: en-US
Calc: CL
Comment 5 giors_00 2020-08-07 06:53:50 UTC
Also here. Very annoying. Only happends with autosave.
Comment 6 NISZ LibreOffice Team 2020-08-11 09:05:06 UTC
@Eike, I though you might be interested in this one...