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.

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

• Edited by Bates Motel Monday, April 06, 2015 8:56 PM

Hi George,

Thank you for investigating this issue.  

In Excel 2003, I applied Format --> Row --> AutoFit and this did not correct the issue.  

A colleague in Excel 2007, applied the AutoFit Row Height option and this did not correct the issue.  

However, this colleague created a new spreadsheet manually in Excel 2007 (and by default it used Calibri 11 instead of Arial 10 font) and this seems to correct the problem.  In 2003 if I use bold Calibri 11 instead of bold Arial 10, the issue is not present.  I'm wondering if it is simply a result of the Calibri font having the same height (Descender Line to Ascender Line) in bold and regular?  

If you were to re-test the spreadsheet that does not exhibit the issue (by applying bold Arial 10), do you still see the issue?  

 
Matt