SheetProtection equal DefaultSheetProtections

Questions and answers on how to use XLSReadWriteII 3/4/5.
Post Reply
Steph.Schie
Posts: 5
Joined: Thu Aug 12, 2010 10:15 am

SheetProtection equal DefaultSheetProtections

Post by Steph.Schie »

Hello!

We need to protect a sheet but allow everything.
This is possible in Excel 2003 and has following effect:
All locked cells are write protected.
Everthing can be selected.

This isn't possible with the XLSReadWriteII 3/4, because of
this code fragment:

procedure TXLSWriteII.WriteToStream(Stream: TStream);
[...]
if FXLS.Sheets[i].SheetProtection <> DefaultSheetProtections then
FXLS.Sheets[i]._Int_Records.PROTECT := 1
else
FXLS.Sheets[i]._Int_Records.PROTECT := 0;
[...]

We now implemented a workaround for this.
We revoked the spEditObjects protection, because we dont need graphical object.

Is it possible to "fix" this?
Steph.Schie
Posts: 5
Joined: Thu Aug 12, 2010 10:15 am

Re: SheetProtection equal DefaultSheetProtections

Post by Steph.Schie »

We still need a fix for that.

:-)
Post Reply