We still need a fix for that.
:-)
Search found 5 matches
- Tue May 17, 2011 7:41 am
- Forum: XLSReadWriteII 3/4/5
- Topic: SheetProtection equal DefaultSheetProtections
- Replies: 1
- Views: 4586
- Wed Sep 08, 2010 8:56 am
- Forum: XLSReadWriteII 3/4/5
- Topic: Password protection
- Replies: 2
- Views: 3560
Re: Password protection
We need the same functionality.
We are using XLSReadWriteII4.
Is it possible now?
We are using XLSReadWriteII4.
Is it possible now?
- Fri Aug 13, 2010 8:03 am
- Forum: XLSReadWriteII 3/4/5
- Topic: SheetProtection equal DefaultSheetProtections
- Replies: 1
- Views: 4586
SheetProtection equal DefaultSheetProtections
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...
- Thu Aug 12, 2010 11:10 am
- Forum: XLSReadWriteII 3/4/5
- Topic: Format a whole Sheet
- Replies: 1
- Views: 2737
Re: Format a whole Sheet
procedure FormatSheet(sheetNumber: Integer); var firstRow, lastRow, firstCol, lastCol :Integer; begin XlsRw.Sheets[sheetNumber].CalcDimensionsEx; firstRow := XlsRw.Sheets[sheetNumber].FirstRow; lastRow := XlsRw.Sheets[sheetNumber].LastRow; firstCol := XlsRw.Sheets[sheetNumber].FirstCol; lastCol := X...
- Thu Aug 12, 2010 10:25 am
- Forum: XLSReadWriteII 3/4/5
- Topic: Format a whole Sheet
- Replies: 1
- Views: 2737
Format a whole Sheet
Hi Is there a way to format a whole Sheet? For example: A standard font or backgroundcolor. This would work i guess but may be very slow XLS.Sheet[0].Range.ItemsRef['A1:IV65536'].FontStyle := [xfsBold]; The file also would grow i guess. ... this isnt a very elegant way of doing it. I need to format ...