Hi,

I noticed a problem when creating a multiple line cell with bold text -- that a line of text was missing when printing (and in the print preview).  

To reproduce, create a spreadsheet like this with 20 lines in one cell (F3).  I also added 10 lines in F5.

(I apologize, but this site is not letting me post the screen shots that I took).  Create a spread sheet adding text in cells A1-A5 through I1-I5.  Add 20 different lines to cell F3 and 10 different lines to cell F5.  I added "Hello 1" through "Hello 20" in F3 and "World 1" through "World 10" in F5.  The text in cells F3 and F5 need to be in bold.  

Go to the print preview and you will noticed that "Hello 1" in F3 is missing.  "World 1" in F5 is truncated.  It is also missing when printed.  

It looks like the problem is caused by the multiple line font being bold weight.  If you remove the bold weight, then the print preview (and printed copy) display all lines properly.  It almost seems that the method to scale the cell for printing is relying on the cell height without considering the additional height increase from bold weight text -- with 20 lines in cell F3, an entire line is missing, with 10 lines in cell F5 only part of a line is missing.  

I manually created this spreadsheet using MS Excel 2003.  A colleague has MS Excel 2010 and the same spreadsheet prints the same (with 2010).  

I'm working around this problem by avoiding bold weight for multiple line cells.  Is this a known issue?  Am I doing something incorrect?  Any help or suggestions appreciated -- thanks!

Matt

Hi,

Please see this article to verify the account and then we can upload the screenshots.

http://social.technet.microsoft.com/wiki/contents/articles/15960.how-to-verify-your-msdntechnet-forums-account-so-that-you-can-post-images-and-links.aspx

Or you may send a sample file via Email (ibsofc@microsoft.com). I'd like to test it.