[Solved] Wrap Table Cells

[anoop_ind2]

Hi,
am having a long text inside my table cell... its a text item object. Now when i run the report as excel the field is not getting wrapped.Ã,  The same text item when outside the table is being wrapped in Excel. I am using the "break when necessary option" ...
any one has any suggestions?
I had read in one of the posts earlier about an option "Allow Wordwrap - Yes/No" where do i find the same?

[BIsrik]

Try setting the size and overflow of the table cell.

Srik

[Boris-A]

under "White Space" there is a setting to say "No Wrap" but unless you forced that, it shouldn't be there.

Try the same excel file on someone else's computer, I have seen this happen on certain computers and not on others.. the same file..!!!  never found the exact setting that makes it behave like that but it's known to happen.

cheers

[anoop_ind2]

Thanks for the replies...
BiSrik, i have tried changing that and there seems to be no use....
Boris-A, it happens on all the machines... the text item i am trying to put in the table cell is more than 5-6 lines.... I guess there is some limitation on the amount of data the table cell can show in EXCEL.
It jus keeps showing ####....

[bdybldr]

anoop,
Change the format of the cell to "general".  It's the only way that I've found to fix this issue.

[anoop_ind2]

You mean for the Text item right? the data format of that is already set to Default...
I guess its a known issue with CRNÃ,  :(Ã,  >:(

[bdybldr]

Right, the text item.  You are talking about how the text appears when imported to Excel, right?  Yes.  this is a known issue; just change format to general.

[anoop_ind2]

Thanks bdybldr.. but am not sure if am missing something... i dont find a property as General!!! for the Data Format property the only psbl value is Default and i dont find any General ....

[anoop_ind2]

i did find a workaround for the whole thing.. i cudnt get the data in the table cell word wrapped regardless of any settings change.. the same text was being wrapped automatically in a block.. and again if its two continuous blocks the cells were merging.......strange!
I put an empty table (with no data) in between the blocks and achieved the required result.. in the final excel output there were blank lines because of the empty tables... guess i can live it as for now!
thanks a lot for all ur suggestions!