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
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 (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
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?
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
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
:-\