Page 1 of 1

SheetProtection equal DefaultSheetProtections

Posted: Fri Aug 13, 2010 8:03 am
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?

Re: SheetProtection equal DefaultSheetProtections

Posted: Tue May 17, 2011 7:41 am
by Steph.Schie
We still need a fix for that.

:-)