https://bugzilla.novell.com/show_bug.cgi?id=431196
User kyoshida@novell.com added comment
https://bugzilla.novell.com/show_bug.cgi?id=431196#c4
--- Comment #4 from Kohei Yoshida
In my view we should hide to the user the technical issue about a hash.
In general I agree with you. But in this case I find it hard to explain why the users need to re-type password without mentioning the word "hash". Having said that, I think it's okay to just remove the word 'hash' as you originally suggested. Why
isn't it possible to store the password always in such a way that the document can be exported always.
Because of incompatible password _hash_ between Excel and Calc. The document doesn't store a clear-text password for security reasons. Instead, it stores a hash value of the original password so that if you type the same password again you'll get the same hash value and the application can verify that you have typed the correct password. The problem is, Excel and Calc use different hash functions, which means they generate different hash values even from the same password. And it's not possible to generate an Excel-compatible hash value from a Calc-compatible hash value and vice versa. A hash _always_ has to be generated from the original password. So, when you are trying to save a document that was originally an Excel document (with Excel-compatible hash), to a Calc ODF document which needs a Calc-compatible hash, you have a problem. The old behavior was to discard all sheet passwords, which we considered to be a bug.
Does that need a change in ooo?
The change has already been made. I'm still working on removing the re-type dialog when going from Excel file to ODF, by using Excel's hash algorithm directly inside Calc, but it requires a file format change and needs to be worked out with the ODF TC. It's still not approved yet, which is why we still need to launch the re-type dialog until we get approval from the ODF TC for the file format change. When going from ODF to Excel, we will continue to need the re-type dialog. There is no way to remove that since we can't fix Excel. If so, a bugreport
should be filed with ooo.
It was already filed, and the bug was fixed (only in ooo-build for now). http://www.openoffice.org/issues/show_bug.cgi?id=60305
As a temporarely message I would suggest:
The document you are about to export has one or more protected items with a password which is stored non-exportable. Please re-type your password, it can be the same, to be able to export your document.
Well, on second thought, I like your first version better. :-) I think the word 're-type' already implies that the same password can be used. So, I'll stick with your first suggestion. Thanks for the discussion Freek. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.