Return-Path: X-Original-To: apmail-incubator-ooo-dev-archive@minotaur.apache.org Delivered-To: apmail-incubator-ooo-dev-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id A5200D451 for ; Thu, 28 Jun 2012 09:14:29 +0000 (UTC) Received: (qmail 86145 invoked by uid 500); 28 Jun 2012 09:14:29 -0000 Delivered-To: apmail-incubator-ooo-dev-archive@incubator.apache.org Received: (qmail 86077 invoked by uid 500); 28 Jun 2012 09:14:29 -0000 Mailing-List: contact ooo-dev-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ooo-dev@incubator.apache.org Delivered-To: mailing list ooo-dev@incubator.apache.org Received: (qmail 86067 invoked by uid 99); 28 Jun 2012 09:14:29 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 28 Jun 2012 09:14:29 +0000 X-ASF-Spam-Status: No, hits=1.5 required=5.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of steve.yin.aoo@gmail.com designates 209.85.217.175 as permitted sender) Received: from [209.85.217.175] (HELO mail-lb0-f175.google.com) (209.85.217.175) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 28 Jun 2012 09:14:22 +0000 Received: by lbol5 with SMTP id l5so2742452lbo.6 for ; Thu, 28 Jun 2012 02:14:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=Ei5y5LFBA86inKMfiB0WgaDKIeDF3ePDGYNPu9T1Hdc=; b=PDx2zDRce59zY/7d0EyDoxlvUXDw+zfZASkdHn5lzh3Wqc/G60x3/NE/G/Ca5q8YBK kGregn559WUOVVm3NYBVf+3fgd68oOzWZcDRZJAppZuTqknMzsg0q+7R1/Gk5DOhWHCM uXRbGLLPALNbQBzefbE7RUIQTEA+qG7HDJCBhsyxkz5WVvORMEkVvDSjIkuRLVtLtikw 27LCTrXVN7tIGmRQBCZVbN5nmz7y6NiN1BTQdhMW7zhrfuMIx2F72ySGd6rpSM1YY0/e DVm4AZ2jAizWMaW2u7P7FwfiLhRmoePlBoilKMhpakD755HVkOS0saysYiay8ClMLNBY mOaQ== MIME-Version: 1.0 Received: by 10.112.102.8 with SMTP id fk8mr689100lbb.71.1340874841934; Thu, 28 Jun 2012 02:14:01 -0700 (PDT) Received: by 10.112.49.201 with HTTP; Thu, 28 Jun 2012 02:14:01 -0700 (PDT) In-Reply-To: References: <4FEAB273.9030507@googlemail.com> Date: Thu, 28 Jun 2012 17:14:01 +0800 Message-ID: Subject: Re: [Discussion]Active Doc/Sheet protection password related blocks From: Steve Yin To: ooo-dev@incubator.apache.org Content-Type: multipart/alternative; boundary=f46d0401730ba44c0e04c384c000 --f46d0401730ba44c0e04c384c000 Content-Type: text/plain; charset=ISO-8859-1 Hi all, This feature has been tested and enabled in Symphony over 2 years. It does work. And The hash algorithm is correct. I remember Kohei's aim was to implement almost all protection features like MS Excel includes different privileges. One possible reason is the current implementation is not complete for Kohei, So he disable the feature by default at that time. However. I think we can enable it safely now. On Thu, Jun 28, 2012 at 3:35 PM, Lei Wang wrote: > Hi Jian Yuan, > > The file tabprotection.hxx is created by CWS scheetprotection02. I go > through the comments when this CWS integrated into the trunk. But I do not > find any useful information. > > If Excel use another hash algorithm, AOO can not unprotect the sheet/doc > even user input the right password. To avoid this bad situation, I guess > the developer disable related function. > > On Wed, Jun 27, 2012 at 3:12 PM, Oliver-Rainer Wittmann < > orwittmann@googlemail.com> wrote: > > > Hi, > > > > > > On 26.06.2012 08:44, Jianyuan Li wrote: > > > >> Hi, all, > >> > >> In ../sc/inc/tabprotection.hxx, a macro is defined as below: > >> #define ENABLE_SHEET_PROTECTION 0 > >> > >> So all blocks controlled by it will not be executed: > >> 1. Import/export Sheet/Doc protection password for a protected xls file. > >> 2. Import a protected xls file and show unpassword dlg to input password > >> when unprotect the sheet/doc. > >> 2. Import a ods/xls file and export it as a xls/ods file. Show password > >> retype dlg. > >> And there is an issue related to it: > >> https://issues.apache.org/ooo/**show_bug.cgi?id=119552< > https://issues.apache.org/ooo/show_bug.cgi?id=119552>. > >> I have added some > >> comments for it. > >> I had a simple test to set the macro as 1 and checked all above > scenarios. > >> It works well. So here I want to set the macro as 1. > >> > >> Any comments? Or does anyone know the initial thought for the value "0" > >> of ENABLE_SHEET_PROTECTION? > >> > >> > > I do not know anything about this code. > > > > But may be a look in the hg repository - still available at [1] - would > > help. May be the one or the other commit log message by which this macro > > has been introduced would give some answers. > > > > [1] http://hg.services.openoffice.**org/< > http://hg.services.openoffice.org/> > > > > > > Best regards, Oliver. > > > -- Best Regards, Steve Yin --f46d0401730ba44c0e04c384c000--