Is it just me...?

External Since: Mar 07, 2004 Posts: 3828

In article <C3294C35.21C79%gwkuddles@comcast.net>,
Guy Kudlemyer <gwkuddles.RemoveThis@comcast.net> wrote:

> > Anyway, the problem was that if you copy a formula from a cell, you
> > can paste it UNTIL you do something else (press a key, do something in
> > a menu other than paste, sneeze), then in subsequent pastes, the
> > "value" of the formula is pasted instead of the formula itself. So,
> > the clipboard persists, but not as you'd expect.
> >
> > Does this describe the behavior that Guy is being subjected to?
>
> It doesn't seem to matter what is in the cell (text, formula, value,
> whatever.) If you copy it, you can paste it until you get a nosebleed, BUT
> if you do anything other than paste, the clipboard is wiped clean. If you
> copy, paste, type something in another cell, then try to paste again, you
> must re-copy again before you can paste again--All because you typed
> something between pastings.
>
> I'm attempting to do this at home on my Mac, but two other computers that I
> use at work, both Windozers, work exactly the same way.

I expect that behavior in WinXL, since it uses a special Office
clipboard that clears after copy operations are through.

But MacXL has no special clipboard, so the only thing that can clear the
clipboard is to load something else, presumably blank, but at a minimum,
something that isn't applicable to being pasted into a cell.

I don't remember whether you've said if you're running any event macros
or haxies...

External Since: Mar 07, 2004 Posts: 3828

In article <C32A4E95.9FDF9%bob@nospam.com>,
Bob Greenblatt <bob.RemoveThis@nospam.com> wrote:

> Remember people, that Excel has worked with the clipboard a ³little
> differently² than most other apps since it was MultiPlan in day 1.

That's true, and it may be the genesis of the OP's problems.

However, the "differently" is mostly related to what information is put
on the clipboard, and what taken back out - almost all apps place
multiple entries (text, formatted text, tagged text, hyperlinks, etc) in
the clipboard, and what gets pasted depends on what information the
receiving app thinks it can use. And XL is certainly unique in what it
decides to paste.

But I still don't think that I've ever seen XL *clear* the clipboard on
its own.