Excel - long text cell

View: New views
1 Messages — Rating Filter:   Alert me  

Excel - long text cell

by thanlis81 :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Hi everyone,

I have a problem regarding excel cell containing long texts.
I have created a report containing a text field which could contain many rows of text. By the way, i want to show only 2 rows of the content and the remaining rows should be available only double-clicking on the cell.
So, in Ireport i've not checked the option "Stretch with overflow" and i've set fixed width and lenght to 2 rows. In this way, the text contained in the cell is not the full text saved on the db, but only first the 2 rows and the rest is truncated.
If i check the option  "Stretch with overflow", the cell contains the full-lenght text but the cell is stretched based on the cointaing text, which is a violatation of the initial requirement (fixed two rows)

Anyone has any hint or clue?

Thanks in Advance!