Issue 106275 - Excel sheet protection not removed
Summary: Excel sheet protection not removed
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOo 3.1.1
Hardware: Unknown Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2009-10-26 10:17 UTC by uam
Modified: 2012-09-03 08:26 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description uam 2009-10-26 10:17:02 UTC
Open a Excel table with sheet protection save as *.ods.

Whilest in OOo - Windows version a window pops up asking whether to re-enter or
omit the protection of a sheet, the Linux (opensuse and go-oo) version doesn't
ask but keeps the protection when saving the file.
Comment 1 kyoshida 2009-10-26 13:37:48 UTC
Are you sure the behaviors are flipped (i.e. the Windows and the Linux
versions)?  That dialog is currently Go-OO only, so the upstream versions
shouldn't launch that dialog.
Comment 2 kyoshida 2009-10-26 13:38:21 UTC
>Are you sure the behaviors are flipped

I meant to say "Are you sure the behaviors are *not* flipped?"
Comment 3 kyoshida 2009-10-26 13:44:39 UTC
Also, the dialog will get launched *only when* the application cannot
re-generate the password hash.  So, when saving from xls to ods, the dialog will
not get launched, the same when going from ods to ods.

The way to check if this is working as designed is to open the resaved file and
test if those sheet protections are still in place, with the same password.  If
yes, then it's working as designed.
Comment 4 uam 2009-10-26 15:15:04 UTC
Also, the dialog will get launched *only when* the application cannot
re-generate the password hash.  So, when saving from xls to ods, the dialog will
not get launched, the same when going from ods to ods.

-> ok, understood.

The way to check if this is working as designed is to open the resaved file and
test if those sheet protections are still in place, with the same password.  If
yes, then it's working as designed.

-> ok, understood. It is working as designed, I will mark it as resolved.

It was my assumption, that this is a feature to *remove* the password hash.
Is there an option to block the re-generation of the password hash?
Thanks for an answer !
Comment 5 kyoshida 2009-10-26 15:18:54 UTC
>Is there an option to block the re-generation of the password hash?

Unfortunately not currently.  But, I'll treat that as a request for a future
enhancement.  That would also help for mass conversions.
Comment 6 binguo 2012-09-03 08:26:03 UTC
Verified on Aoo_Trunk_20120829.1800, it is working as current design. so close it.