2008/9/10 Bill Bailey <[EMAIL PROTECTED]> > New user question: > > When pasting data into OOo Calc 2.4 from another source, such as a web > page, the data is displayed in a font other than the one specified when the > cells were formatted. For example, the cell format might be set for Tahoma > Regular 9 but the pasted data will be displayed in another font, such as MS > Sans Serif Bold 12. This behavior occurs whether the F2 key is pushed to > select "edit". > > What am I missing? There must be a way for the pasted data to be entered > in the selected font. I don't have this problem with Excel and, frankly, I > have avoided switching because of it. > > Bill in FLA > > I believe the behaviour is as follows: OOo's Paste assumes you want to keep the charasterics of the copied text. If you want to lose these and force the copied text to conform to the receiving cell's format, use Paste Special and select Unformatted text. For convenience the Paste button on the toolbar allows this option via its little drop-down list. Or you can add a specific Paste Special button to the toolbar using View>Toolbars>Customise and *Add*ing the Paste Special button from the Edit menu to whichever toolbar you like.
-- Harold Fuchs London, England Please reply *only* to [email protected]
