When LibreOffice Calc Tools | Protection is used to protect a sheet and the document, and the document is save as an ODF 1.0/1.1 document according to the Tools | Options Load/Save settings, the table:protection-key is correctly derived using SHA1. However, the ODF 1.2-only attribute table:protection-key-digest-algorithm is provided with information that is defined only for ODF 1.2. This attribute should not be used in an ODF 1.1 document. At <http://tools.oasis-open.org/version-control/svn/oic/TestSuite/trunk/odf12/ProtectionKeyResilience/>, the files ProtectionKeyResilience-05-ODF1.2-1.1-offBase.ods and -06-ODF1.2-1.1-offBase.ods demonstrate this defect. The abridged and annotated content.xml file, ProtectionKeyResilience-06-ODF1.2-1.1-offBase-content.xml demonstrates the defect in the second of those two files.
Let me have a look at it. Should be a quite easy fix.
sent a possible patch to the ML