[RESOLVED] Export to Excel cell's row height more than 409

Hi All,

My exporting excel file will get the record from database.
My remark cell has a lot of word to be loaded.
My problem is when the row height exceed than 409 the remaining word will not be printed.

How to rectify my problem ?
can anyone give me some guide to resolve my problem.

Thanks a million.

i believe the text will all be in the cell, just not visible
limitations vary depending on excel version

merge cells? makes it bigger

Thanks westconn1,

The text will all be in the same cell just cannot be print if the text more caused the cell row height exceed than 409.

Got any method can rectify my issue ?

Cruncher,

I think merge cell can't resolve my problem because the text all are still inside the same cell. Can I do separation of row if the text exceed than row height 409 ?
How to accomplish this ?

Thanks for advice.

row height? does that mean you are using big font??

uhm i think merge cells will fix your problem, look

http://i481.photobucket.com/albums/r...g?t=1244393614

as for the coding, i can't help... i dont know anything about writing vb for excell or word etc

Thanks Cruncher,

I think you misundestood my problem.
The problem was not caused by font height.
You may try to select a single row , press the mouse right button and select row height.
Adjust the row height to 410 or above you will see something.The cell must be fixed and enabled wrap text.

Thanks.

as far as i am aware, Maximum row height is 409, your choices are to
reduce the amount of text,
widen the column, to the extent the text will fit in the allowed height
split the text into portions and insert extra rows as required to get the height required, merged or not
or
update to see if 2007 allows bigger rows

i did do some work on this problem before, posted in office development forum, see
http://www.vbforums.com/showthread.p...cel+row+height
http://www.vbforums.com/showthread.p...cel+row+height

Thanks westconn1,

The problem resolved. I set my cells will split into another row if the cells text was exceed 800 characters.