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?
SheetProtection equal DefaultSheetProtections
-
- Posts: 5
- Joined: Thu Aug 12, 2010 10:15 am
-
- Posts: 5
- Joined: Thu Aug 12, 2010 10:15 am
Re: SheetProtection equal DefaultSheetProtections
We still need a fix for that.
:-)
:-)