XL97: Constrained Line or Arrow Pastes Incorrectly in NT 4.0

ID: Q192406

The information in this article applies to:

• Microsoft Excel 97 for Windows
• Microsoft Windows NT Workstation version 4.0
• Microsoft Windows NT Server version 4.0

SYMPTOMS

If you paste a copy of a drawn line or arrow, the position of the paste may be offset from the active cell.

CAUSE

This problem may occur if the following conditions are true:

• You are using Excel 97 on Microsoft NT version 4.0.

      -and-
  

• You draw a vertical or horizontal line or arrow either manually or constrained to the side or bottom of cell(s) by using the ALT key.

      -and-
  

• The line or arrow to be copied is drawn in a cell other that A1.

WORKAROUND

To work around this problem, select and copy all of the cells surrounding the line or arrow, rather than the line or arrow itself.

STATUS

Microsoft has confirmed this to be a problem in Excel 97 for Windows.

MORE INFORMATION

This problem only occurs in Microsoft Windows NT version 4.0. The offset of the paste does not occur with constrained lines drawn at a slant. The amount of offset varies and is based on the original location of the copied line by the number of rows from Row 1 and the number of columns from Column 1. For example, if you copy a line from cell D7 and attempt to paste it into cell B5, it will be pasted into cell E11. The amount of the offset as calculated from cell A1 (A1 minus B5) is 1 column and 4 rows, which added to cell D7, is E11.

Additional query words: XL97 winnt

Keywords          : kbdta
Version           : WINDOWS:97; WINNT:4.0
Platform          : WINDOWS winnt
Issue type        : kbbug
Solution Type     : kbpending

Last Reviewed: November 4, 1998