Multiple line bold cell has line truncated when printing

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


April 2nd, 2015 8:27pm

Hi Matt,

I have received the sample file. Based on my tested, I can reproduce this issue with your attachment in Excel 2013/2010.

I found that you set a fixed row height in the sample file, if we manually modify the height of a row and then format a cell in that row to wrap text, Excel does not change the height of the row to fit all the text in the cell.This behavior is by design.

Thus, if we apply the bold formatting to the text, the pixel of the text has increased, but Excel did not fit it. We need to modified it manually or use AutoFit Row Height option.

I create a new file and re-create it in Excel 2013/2010 and use "AutoFit Row Height" feature, this issue disappeared, please see this image:

Hope it's helpful.

Reference:

http://support.microsoft.com/en-us/kb/149663

Regards,Regards,

George Zhao
TechNet Community Support

Free Windows Admin Tool Kit Click here and download it now
April 6th, 2015 10:44pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics