Thread: Wrap Text
View Single Post
  #5   Report Post  
Mark Leyden
 
Posts: n/a
Default

I didn't know about double-click either, but I tried it when trying to figure
out why my text was not showing up.

Pre-SP2: Text with/without ALT+ENTER autogrow my cell. Before installing the
SP, my XLS showed my wrapped text.

Post-SP2: Text shown is single line only (no wrapping). Double-clicking the
cell allows me to see the text in the cell (not just the formular bar). As
soon as I leave the cell, my text disappears.

This behaviour is new since installing SP2.

"Dave Peterson" wrote:

That limit of 1024 characters visible in a cell is easily overcome by adding
alt-enters to the value in that cell (every 80-100 characters).

Mike wrote:

I never heard of double clicking a cell within Excel.

If you go to excel help and enter limits you will see a variety of limits
including how many characters are displayed within a cell. I believe it is
still 1024 characters.

I have seen blank space abovve my text if the last character comes close to
the right edge.

You don't have like white text on white background? I will never forget
that help desk call from retiring Agnes Olson.

"Mark Leyden" wrote:

I just installed the SP2 for Office 2003 and now "wrapped" text does not
appear in my cells. They are not merged cells. Prior to updating, the wrapped
text automatically fit my text. Since updating, even if I manually resize the
row the text does not appear until I double-click the cell. Once I leave the
cell, the text disappears again?

When I turn off "wrap text", the text reappears.

Has anyone else experienced this? Is it a bug? Is there a workaround?

Thanks
Mark.


--

Dave Peterson