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