Google Answers Logo
View Question
 
Q: Excel XP cell truncation ( No Answer,   0 Comments )
Question  
Subject: Excel XP cell truncation
Category: Computers > Software
Asked by: sturgis85-ga
List Price: $50.00
Posted: 16 Oct 2005 11:27 PDT
Expires: 16 Oct 2005 11:41 PDT
Question ID: 580951
Using Excel XP (2002...), running on /XP....

I cannot print or display a cell containing 1500 or so characters. 
The worksheet is a single cell.  The cell is formatted as general or
text, word-wrapped and aligned to the top.  The text is pure ascii,
pasted from NotePad.  Increasing the size of the cell horizontally
affects the amount printed or displayed by a small bit -- (apparently
Excel tries to calculate how much will fit on the last line) -- but
the text is still truncated.  Increasing the size of the cell
vertically has no affect other than to add more white space at the
bottom (no additional text).  Playing with fonts (fonts, sizes) or
scaling has no real affect.

But the text is definitely there:  clicking on the cell displays all
of the text in a popup window.

Any way around this?  (We're actually trying to automate this,
extracting text from a database, so I'd pay extra for a solution that
allows auto-sizing.  But just learning how to do this manually would
be a major step.)
Answer  
There is no answer at this time.

Comments  
There are no comments at this time.

Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  


Google Home - Answers FAQ - Terms of Service - Privacy Policy