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 10 hours 30 minutes ago