XL2000: Hidden Property Not Retained When Pasting Selection from Word

ID: Q228868

The information in this article applies to:

Microsoft Excel 2000

SYMPTOMS

When you copy a selection in Microsoft Word 2000 that contains hidden text, and then paste the selection in a Microsoft Excel 2000 worksheet, the hidden text becomes visible. In contrast, if you paste the selection in Word, the text retains its hidden formatting property.

CAUSE

This behavior occurs because Excel does not support hidden text the way Word does. When you copy a selection containing hidden text in Word, it preserves the hidden formatting. That is, when you paste the selection in Word, it retains the hidden property. Because it does not know whether you want to keep the hidden text or not, Excel retains the text, but drops the hidden formatting property.

WORKAROUND

To work around this problem, after you paste the selection, delete the text you do not want.

Additional query words: XL2000

Keywords : kbinterop xlformat
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb