You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2014/02/21 10:15:41 UTC
[Bug 124283] New: Destroy sheet protect when insert sheet
https://issues.apache.org/ooo/show_bug.cgi?id=124283
Bug ID: 124283
Issue Type: DEFECT
Summary: Destroy sheet protect when insert sheet
Product: Calc
Version: 4.0.1
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: P3
Component: code
Assignee: issues@openoffice.apache.org
Reporter: oukcha.fr@gmail.com
CC: issues@openoffice.apache.org
Hi developpers,
Step to reproduce :
-1: create a new Calc document
-2: select one, or more sheet, without Sheet1
-3: menu Tools > Protect document > Sheet
-4: Input password and confirm
To destroy password :
-5: select all sheets
-6: menu Tools > Protect document > Sheet
-7: validate without password
-8: menu Tools > Protect document > Sheet > remove protect in all sheets
without password.
If all sheets are selected when you use menu Tools > Protect document > Sheet,
just insert a new sheet in first position in spreadshead, and do step 5 to 8 to
destroy password.
For better protection, you must use sheet and document password, break the
sheet protect is within reach of a child.
Regards
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124283] Destroy Password Sheet Protection when add sheet with
protection without password
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124283
--- Comment #7 from Oukcha <ou...@gmail.com> ---
Protect sheet work fine with OOo 2.4.2 :
-5: select all sheets
-6: menu Tools > Protect document > Sheet
-7: validate without password
-> there is message "wrong password" for each protected sheet
Thanks
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124283] Destroy sheet protect when insert sheet
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124283
Oukcha <ou...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |oukcha.fr@gmail.com
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124283] Destroy Password Sheet Protection when add sheet with
protection without password
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124283
Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|Destroy sheet protect when |Destroy Password Sheet
|insert sheet |Protection when add sheet
| |with protection without
| |password
--- Comment #4 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
Additional Info:
----------------
(a) Situation with existing documents is a little worrying, so I tested
strictly to reporter's steps with blank new documents:
(a1) Already reproducible with sever installation of "OOo 3.2.1 English UI
/ German locale [OOO320m18 (Build 9502)]" on WIN7 Home Premium (64bit) DE
(a2) Was still ok with server installation of "Ooo 3.1.1 German WIN7
Home Premium (64bit) DE [OOO310m19 (Build 9420)]"
Was still ok with server installation of "OOo 2.0.2 [680m5 (Build 9011)]"
German WIN7 Home Premium (64bit): In reporter's step 7 Message "Wrong
(b1) Might be related to document source code. With 4.0.1 and later
reporter's trick will not work with a document protected from
OOo 2.0.2, I get message "Wrong Password"
(b2) Might also be related AOO UI. Sample document protected
with 4.1.0 due to reporter's steps 1 ... 4 can not be unprotected
with steps 5 ... 7 with OOo 2.0.2, trick only will work with later
versions
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124283] Destroy Password Sheet Protection when add sheet with
protection without password
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124283
bmarcelly <ma...@club-internet.fr> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |marcelly@club-internet.fr
--- Comment #8 from bmarcelly <ma...@club-internet.fr> ---
There is a warning in the Help , page Protecting Cells from Changes
You find this page by searching in Help : protecting;cells and sheets
These protection features are just switches to prevent accidental action. The
features are not intended to provide any secure protection. For example, by
exporting a sheet to another file format, a user may be able to surpass the
protection features. There is only one secure protection: the password that you
can apply when saving an OpenDocument file. A file that has been saved with a
password can be opened only with the same password.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124283] Destroy sheet protect when insert sheet
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124283
brinzing <ol...@gmx.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |CONFIRMED
CC| |oliver.brinzing@gmx.de
Ever confirmed|0 |1
--- Comment #1 from brinzing <ol...@gmx.de> ---
i can confirm this behaviour with aoo401/oo32.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124283] Destroy sheet protect when insert sheet
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124283
Rainer Bielefeld <ra...@bielefeldundbuss.de> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |regression
CC| |rainerbielefeld_ooo_qa@biel
| |efeldundbuss.de
--- Comment #2 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
Reproducible with "AOO 4.0.1 – German UI / German locale [Rev. 1524958
2013-09-20 11:40:29]" on German WIN7 Home Premium (64bit)", “historic” 4.0 User
Profile used for all predecessor versions.
Was OK with OOo 3.3.0, so regression. I will do some more research.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124283] Destroy Password Sheet Protection when add sheet with
protection without password
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124283
Oliver-Rainer Wittmann <or...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Version|4.0.1 |OOo 3.3 or older
--- Comment #6 from Oliver-Rainer Wittmann <or...@apache.org> ---
adjusting version field due to comment #4
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124283] Destroy sheet protect when insert sheet
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124283
--- Comment #3 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
Seems I made a mistake, is already a problem with OOo 3.3.0
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124283] Destroy Password Sheet Protection when add sheet with
protection without password
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124283
--- Comment #5 from Rainer Bielefeld <ra...@bielefeldundbuss.de> ---
Created attachment 82653
--> https://issues.apache.org/ooo/attachment.cgi?id=82653&action=edit
Test Kit
With attached test kit you can do your own investigations, especially for
Comment 4 b1 / b2.
Sample202.ods has been created with OOo 2.0.2, Sample410.ods has been created
from AOO 4.1.0-dev
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.