XL97: Problems Printing Comments as DisplayedLast reviewed: January 9, 1998Article ID: Q169053 |
The information in this article applies to:
SUMMARYWhen you print a worksheet in Microsoft Excel 97 that has comments, and select the As Displayed On Sheet option in the Comments box of the Page Setup dialog box, the comments may not be printed as expected. This problem may occur if comments are placed on or near a page break.
MORE INFORMATIONThis behavior will vary, depending on the active printer driver, and is expected behavior. Comments in Microsoft Excel 97 are drawing objects, just like rectangles and text boxes. You may see similar problems with other drawing objects placed on or near a page break. Use the following information for the following examples:
Example 1The comment entered in cell D4 is to the immediate left of the vertical page break. Notice that the comment is displayed to the immediate right of the vertical page break. When viewed in Print Preview, this comment will be printed on page two of the printout, rather than on page one where the actual cell is printed. When set to print as displayed, comments, just as objects, will print where they are placed, which is not necessarily on the same page as the cell contents. For example, the comment at cell D4 can be moved to page three, and it will then print on page three. If the comment needs to be printed on page one, you have the option of manually moving it to page one.
Example 2The comment for cell D6 prints all on page one, even though it crosses over the page break on screen. This is due to a by-design feature of Microsoft Excel 97 where the page-break boundaries are different, in some cases, for objects than for text, because objects do not have to be tied to column widths. For the text in this example, the page break then occurs after column D (as displayed by the dashed line on screen), and in preview, there is a lot of blank space to the right of column D. But those objects, including comments, that cross a page break get to use the "blank space" between the last column that fits on a page and the right margin, and therefore, if the Print As Displayed option is enabled, the comment will print on page one because it, itself, will fit. It was decided that it was better to print the objects if they would fit, even if the underlying text wouldn't. Another complicating factor is that the objects and fonts displayed at the ~72 dpi screen resolution do not always map correctly to the typically much higher printer resolution, which in addition to the factor above, can cause the two halves of an object on a page break to not match exactly when printed. This is also the reason why the comment for cell B4 will print on page two instead of page one like the comment in D6.
|
Additional query words: XL97
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |