Change width of column in excel and wrap text

[lifzgud]

Hi,
I am creating a list report with output as excel 2000 single sheet.
Can somebody please tell me how to change the width of a column in the sheet and wrap text accordingly?
Thanks

[nj]

Lifzgud

I found that I couldn't change these via a report when outputting to single sheet. I seem to remembr that you can affect the column width when outputting to Excel 2007, however. I have to use the MS Compatibility Pack that allows you to open the .xlsx format that this outputs to. Here's the link:

http://www.microsoft.com/downloads/details.aspx?FamilyID=941b3470-3ae9-4aee-8f43-c6bb74cd1466

I'll admit I haven't looked to hard into forcing 2000 to do what I want however.

Not sure that helps...

Nik

[lifzgud]

hi nj,
Thanks for your reply.
What are the chnages we need to make?
At this point of time i find positioning--size and overflow option the only sensible one.
is it correct?

[Gopinath]

Hi,

Yes you have to use size & overflow property to set the width but this property won't work if you have your list inside a table or a block, also if you have a table or a block in your report header.

For text wrapping set White Spcae property to No Wrap

[lifzgud]

My list is not inside a table and i've tried everything that i could in the options.
the report shows changes in html but not in excel
:-\