Mailing-List: contact user-help@poi.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <user@poi.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
Content-Class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
Subject: XSSF Locking
Date: Tue, 5 Jul 2011 16:32:26 +0100
Message-ID: <D3ABC28F9902184391BF3AA7A0239F520106FFDD@sam.vianet.co.uk>
Thread-Topic: XSSF Locking
thread-index: Acw7KL5kMGP8XEfJR8S8OrzIdFQLCw==
From: "Alex Panayotopoulos" <Alex.Panayotopoulos@vianet.co.uk>
To: <user@poi.apache.org>

Hi all,

Can anybody get the XSSF sheet locking functionality working? I've been
testing it, but so far it looks like either *everything* is locked, or
nothing is. If I execute:

		XSSFWorkbook wb =3D new XSSFWorkbook();
		XSSFSheet s =3D wb.createSheet("Locking");
		s.lockDeleteColumns();
		s.enableLocking();
		wb.lockStructure();
		save(wb, "locking.xlsx");

Then I would expect a worksheet that allows all changes except column
deletion. However, the result is a completely locked-down worksheet,
similar to what I would get with a "protectSheet()" call. If I comment
out the "s.enableLocking()" line, then *all* changes are permitted. How
do I disable *just* column deletion?

N.B. I did find one other thread on this list about this problem, but
the example code did not solve the problem. I also searched for open
issues in Bugzilla, but found none. Should I open a new bug?

Thanks,

Alex Panayotopoulos, Software Engineer
ViaTelemetry Limited

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org