Wrap doesn't work when writing to excel 2007

Questions and answers on how to use XLSReadWriteII 3/4/5.
Post Reply
grchristin
Posts: 3
Joined: Sat May 29, 2010 3:53 am

Wrap doesn't work when writing to excel 2007

Post by grchristin »

I'm using the following code to set the wrap property in Excel for all cells. This works fine when writing to exel97 sheets but doesn't work for excel2007. Do you have a fix for this?

aXLS.Sheet[fNewSheetRefNumber].Range[
0,
0,
aXLS.Sheet[fNewSheetRefNumber].LastCol,
aXLS.Sheet[fNewSheetRefNumber].LastRow].FormatOptions := [foWrapText];
grchristin
Posts: 3
Joined: Sat May 29, 2010 3:53 am

Re: Wrap doesn't work when writing to excel 2007

Post by grchristin »

FYI - I'm on version
XLSReadWriteII 4.00.45 using Delphi 7.
Post Reply