https://issues.apache.org/ooo/show_bug.cgi?id=60305
orcmid <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|ACCEPTED |CONFIRMED CC| |[email protected] --- Comment #44 from orcmid <[email protected]> --- Currently, Excel and OpenOffice Calc (using ODF) do not use compatible protection keys. The keys are digital hashes produced in a different way using different hash algorithms. It is not possible to translate between the two. The current behavior is to make no attempt to preserve the protection locks arriving in a "non-native" format because the lock formats are incompatible and not inter-convertible. This is true in both directions. The 2008 proposal that kyoshida@ links to was never incorporated in ODF 1.2. (That proposal is best re-activated by breaking it into separate individual proposals and having them introduced as JIRA issues for features in ODF 1.3.) In order for the same password to work, it is necessary to be able to preserve the Excel password digest and method in OpenOffice and in the resulting ODF document, when saving as ODF. If the protection is first set in OpenOffice, the entered password needs to be hashed twice, once each in ODF and Microsoft hash format, so that the correct form can be used when the document is saved (either as ODF or .xls or .xlsx). It is permissible to add the Excel digest algorithm to ODF 1.2 documents as an implementation-defined value. Ideally, the URI used to identify that method is published and becomes one that all producers of ODF documents can use to preserve protection passwords originally set in a Microsoft Office documents. If one becomes standard in ODF 1.3, migration to that URI can occur over time. -- You are receiving this mail because: You are on the CC list for the bug.
