Hello Lars,
[quote="larsa"]Just use: XLS.CopyCells(ACurrSheet,2,2,2,2,ACurrSheet,2,AIndex);[/quote]
It did the job.
I also found another way to do it.
XLS.Sheet[ACurrSheet].AsRichText[2,AIndex] := XLS.Sheets[ACurrSheet].AsRichText[2,2];
Thanks for the answer.
Br,
Fabio
Search found 2 matches
- Thu Nov 05, 2009 7:33 am
- Forum: XLSReadWriteII 3/4/5
- Topic: How to copy cell format to a new cell
- Replies: 2
- Views: 4277
- Tue Nov 03, 2009 4:34 pm
- Forum: XLSReadWriteII 3/4/5
- Topic: How to copy cell format to a new cell
- Replies: 2
- Views: 4277
How to copy cell format to a new cell
Hello, I have a cell which has a specific format and I would like to copy the format to a new cells. The cell contains basically a bunch of text. The text is multi-line. The first 50 rows in my sheet is formated as follows: E.g. ======================================================== This is a samp...