Welcome to MacForumz.com!
FAQFAQ   SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log in/Register/PasswordLog in/Register/Password

Is it just me...?

 
Goto page 1, 2
   Macintosh computer (Home) -> Excel RSS
Next:  Excel: Help with CONCATENATE and ALT ENTER  
Author Message
Guy Kudlemyer

External


Since: Apr 01, 2005
Posts: 22



(Msg. 1) Posted: Mon Oct 01, 2007 2:20 pm
Post subject: Is it just me...?
Archived from groups: microsoft>public>mac>office>excel (more info?)

Hello:

In every Mac application I've ever used (and I've been using Macs since
1984), it has always been that, once you copy something to the Clipboard, it
stays there until you copy something else to replace it. You can paste it an
endless number of times regardless of whatever else you've done since the
last time you copied.

In Excel, it seems that once you've pasted from the Clipboard into the cell,
and move out of that cell, Excel "forgets" whatever was on the clipboard,
and you cannot re-paste it; you have to re-copy it first (it's the same way
on the Windoze version).

I've seen some boneheaded "features" in Microsoft products before, but this
has got to be the damn DUMBEST things I've yet bumped into from them, if it
is not fixable (and I've seen them do some DUMB things...)

Does anyone have a fix for this? Is it just me? Have I got something setting
incorrectly set? If so, how do I correct it?

I'm using a PPC Mac with OSX 10.4.10 and Excel 11.3.7.

I appreciate anything anyone can offer!

--Guy
Thurston, OR

 >> Stay informed about: Is it just me...? 
Back to top
Login to vote
JE McGimpsey

External


Since: Mar 07, 2004
Posts: 3828



(Msg. 2) Posted: Mon Oct 01, 2007 8:35 pm
Post subject: Re: Is it just me...? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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

> Does anyone have a fix for this? Is it just me?

I think it's just you...

Or at least, I haven't heard of anyone else having this problem.

> Have I got something setting incorrectly set? If so, how do I correct
> it?

There's no setting that would override this. However, if you have any
event macros running, they may do something that clears the clipboard.

Haxies may also cause a problem, I suppose.

 >> Stay informed about: Is it just me...? 
Back to top
Login to vote
Jim Gordon MVP

External


Since: Mar 01, 2004
Posts: 1464



(Msg. 3) Posted: Mon Oct 01, 2007 9:39 pm
Post subject: Re: Is it just me...? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Hi Guyu,

I'm also using Excel 11.3.7 but can not reproduce the problem as you
describe it. Excel behaves as expected. I don't know of a setting that would
cause this to happen.

Maybe if you delete the excel plist preference files it would help ( you'll
lost any excel customizations).

-Jim


Quoting from "Guy Kudlemyer" <gwkuddles DeleteThis @comcast.net>, in article
C326B2AA.21BE2%gwkuddles@comcast.net, on [DATE:

> Hello:
>
> In every Mac application I've ever used (and I've been using Macs since
> 1984), it has always been that, once you copy something to the Clipboard, it
> stays there until you copy something else to replace it. You can paste it an
> endless number of times regardless of whatever else you've done since the
> last time you copied.
>
> In Excel, it seems that once you've pasted from the Clipboard into the cell,
> and move out of that cell, Excel "forgets" whatever was on the clipboard,
> and you cannot re-paste it; you have to re-copy it first (it's the same way
> on the Windoze version).
>
> I've seen some boneheaded "features" in Microsoft products before, but this
> has got to be the damn DUMBEST things I've yet bumped into from them, if it
> is not fixable (and I've seen them do some DUMB things...)
>
> Does anyone have a fix for this? Is it just me? Have I got something setting
> incorrectly set? If so, how do I correct it?
>
> I'm using a PPC Mac with OSX 10.4.10 and Excel 11.3.7.
>
> I appreciate anything anyone can offer!
>
> --Guy
> Thurston, OR
>

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info http://mvp.support.microsoft.com/
 >> Stay informed about: Is it just me...? 
Back to top
Login to vote
PhilD

External


Since: Jun 11, 2007
Posts: 24



(Msg. 4) Posted: Tue Oct 02, 2007 12:17 am
Post subject: Re: Is it just me...? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On Oct 1, 10:20 pm, Guy Kudlemyer <gwkudd... DeleteThis @comcast.net> wrote:
> Hello:
>
> In every Mac application I've ever used (and I've been using Macs since
> 1984), it has always been that, once you copy something to the Clipboard, it
> stays there until you copy something else to replace it. You can paste it an
> endless number of times regardless of whatever else you've done since the
> last time you copied.
>
> In Excel, it seems that once you've pasted from the Clipboard into the cell,
> and move out of that cell, Excel "forgets" whatever was on the clipboard,
> and you cannot re-paste it; you have to re-copy it first (it's the same way
> on the Windoze version).
>
> I've seen some boneheaded "features" in Microsoft products before, but this
> has got to be the damn DUMBEST things I've yet bumped into from them, if it
> is not fixable (and I've seen them do some DUMB things...)
>
> Does anyone have a fix for this? Is it just me? Have I got something setting
> incorrectly set? If so, how do I correct it?
>
> I'm using a PPC Mac with OSX 10.4.10 and Excel 11.3.7.
>
> I appreciate anything anyone can offer!
>
> --Guy
> Thurston, OR



Are you copying a *cell*, pasting it somewhere, then typing something
before wishing to paste the same cell again? In that instance, I
think that's how Excel is "supposed" to work (presumably something to
do with knowing which cell is the centre of attention). If you do all
your pastes in succession without any other edits then you should be
fine (assuming that the paste area does not overlap the copy area).

If you're copying the *contents* of a cell (i.e. edit cell and copy
some or all text from within the cell), then Excel should remember
this and have the text available for multiple copying.

Does this help?

--
<><
 >> Stay informed about: Is it just me...? 
Back to top
Login to vote
CyberTaz

External


Since: Jul 20, 2005
Posts: 1757



(Msg. 5) Posted: Tue Oct 02, 2007 7:06 am
Post subject: Re: Is it just me...? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

Just confirming what John says - I have no problem at all copying &
repeatedly pasting to as many locations as possible. Haxies (3rd party
utilities) have *definitely* been known to interfere with clipboard
functionality.

Cutting, OTOH, is a different story - you can only paste _cut_ content once,
which is by design.

Try starting XL up while holding Shift & see if the problem persists. If so,
try logging in while holding Shift to prevent login items from loading. If
either of these suggestions work you've got another program mucking you up.

HTH |:>)
Bob Jones
[MVP] Office:Mac



On 10/1/07 10:35 PM, in article
jemcgimpsey-6F35DA.20353301102007.TakeThisOut@msnews.microsoft.com, "JE McGimpsey"
<jemcgimpsey.TakeThisOut@mvps.org> wrote:

In article <C326B2AA.21BE2%gwkuddles@comcast.net>,
Guy Kudlemyer <gwkuddles.TakeThisOut@comcast.net> wrote:

> Does anyone have a fix for this? Is it just me?

I think it's just you...

Or at least, I haven't heard of anyone else having this problem.

> Have I got something setting incorrectly set? If so, how do I correct
> it?

There's no setting that would override this. However, if you have any
event macros running, they may do something that clears the clipboard.

Haxies may also cause a problem, I suppose.
 >> Stay informed about: Is it just me...? 
Back to top
Login to vote
Guy Kudlemyer

External


Since: Apr 01, 2005
Posts: 22



(Msg. 6) Posted: Tue Oct 02, 2007 1:05 pm
Post subject: Thanx for: Re: Is it just me...? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

> Are you copying a *cell*, pasting it somewhere, then typing something
> before wishing to paste the same cell again? In that instance, I
> think that's how Excel is "supposed" to work (presumably something to
> do with knowing which cell is the centre of attention). If you do all
> your pastes in succession without any other edits then you should be
> fine (assuming that the paste area does not overlap the copy area).
>
> If you're copying the *contents* of a cell (i.e. edit cell and copy
> some or all text from within the cell), then Excel should remember
> this and have the text available for multiple copying.
>
> Does this help?



Yes, it does help, and that's what I meant to say in the first place. Sorry
'bout that. Yes, if I copy, I can paste ad nauseum UNTIL I hit a character
on the keyboard, then the Clipboard is emptied, and I cannot paste that
particular text again until I've copied it again.

So... This is how Excell is SUPPOSED to work? Why? It's dumb!

Thanx for the help!
 >> Stay informed about: Is it just me...? 
Back to top
Login to vote
Guy Kudlemyer

External


Since: Apr 01, 2005
Posts: 22



(Msg. 7) Posted: Tue Oct 02, 2007 1:08 pm
Post subject: More thanx for: Re: Is it just me...? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

> Just confirming what John says - I have no problem at all copying &
> repeatedly pasting to as many locations as possible. Haxies (3rd party
> utilities) have *definitely* been known to interfere with clipboard
> functionality.

I meant to say that I can copy and paste until my face turns blue, UNLESS I
type something on the keyboard. That action seems to erase the Clipboard. If
this is how Excel is supposed to work, I'd like to hear the convoluted logic
that went into that decision (Bill, are you listening...?) There should also
be a way to turn off that feature...

Thanx for the help!
 >> Stay informed about: Is it just me...? 
Back to top
Login to vote
JE McGimpsey

External


Since: Mar 07, 2004
Posts: 3828



(Msg. 8) Posted: Tue Oct 02, 2007 3:03 pm
Post subject: Re: More thanx for: Re: Is it just me...? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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

> I meant to say that I can copy and paste until my face turns blue, UNLESS I
> type something on the keyboard. That action seems to erase the Clipboard. If
> this is how Excel is supposed to work, I'd like to hear the convoluted logic
> that went into that decision (Bill, are you listening...?) There should also
> be a way to turn off that feature...

Still just you...
 >> Stay informed about: Is it just me...? 
Back to top
Login to vote
JE McGimpsey

External


Since: Mar 07, 2004
Posts: 3828



(Msg. 9) Posted: Tue Oct 02, 2007 3:06 pm
Post subject: Re: Thanx for: Re: Is it just me...? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

In article <C327F2B6.21C13%gwkuddles@comcast.net>,
Guy Kudlemyer <gwkuddles DeleteThis @comcast.net> wrote:

> Yes, it does help, and that's what I meant to say in the first place. Sorry
> 'bout that. Yes, if I copy, I can paste ad nauseum UNTIL I hit a character
> on the keyboard, then the Clipboard is emptied, and I cannot paste that
> particular text again until I've copied it again.
>
> So... This is how Excell is SUPPOSED to work? Why? It's dumb!

There's something else going on. I can paste, then type in a cell, then
paste again with absolutely no problem.

The only thing typing does is turn off the marching ants if the copy was
from XL cell(s).

I certainly agree it WOULD be dumb, if in fact that was the way XL
worked, but for me it works exactly as you want it to...
 >> Stay informed about: Is it just me...? 
Back to top
Login to vote
JE McGimpsey

External


Since: Mar 07, 2004
Posts: 3828



(Msg. 10) Posted: Tue Oct 02, 2007 3:54 pm
Post subject: Re: Is it just me...? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

In article <carl-263C28.17183002102007 DeleteThis @comcast.dca.giganews.com>,
Carl Witthoft <carl DeleteThis @witthoft.com> wrote:

> so yes, withing Excel you can lose the contents of
> your last Copy operation. However, once you switch to a different
> application, MacOS puts the contents into its own clipboard, and that
> does not get lost. --- I just verified this w/ Excel-X on OSX 10.3.9 .

Can you document exactly how you get XL to "lose the contents of the
last Copy operation"?

I can't make it happen at all, using the same XL version as the OP...
 >> Stay informed about: Is it just me...? 
Back to top
Login to vote
Carl Witthoft

External


Since: Mar 22, 2004
Posts: 527



(Msg. 11) Posted: Tue Oct 02, 2007 5:18 pm
Post subject: Re: Is it just me...? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

I interpret this problem differently from the other responders: I
assumed Guy was talking about pasting within Excel spreadsheets.

It has always been the (weird) case that Excel doesn't use the system
clipboard by default, so yes, withing Excel you can lose the contents of
your last Copy operation. However, once you switch to a different
application, MacOS puts the contents into its own clipboard, and that
does not get lost. --- I just verified this w/ Excel-X on OSX 10.3.9 .

In article <C326B2AA.21BE2%gwkuddles@comcast.net>,
Guy Kudlemyer <gwkuddles.TakeThisOut@comcast.net> wrote:

> Hello:
>
> In every Mac application I've ever used (and I've been using Macs since
> 1984), it has always been that, once you copy something to the Clipboard, it
> stays there until you copy something else to replace it. You can paste it an
> endless number of times regardless of whatever else you've done since the
> last time you copied.
>
> In Excel, it seems that once you've pasted from the Clipboard into the cell,
> and move out of that cell, Excel "forgets" whatever was on the clipboard,
> and you cannot re-paste it; you have to re-copy it first (it's the same way
> on the Windoze version).
>
> I've seen some boneheaded "features" in Microsoft products before, but this
> has got to be the damn DUMBEST things I've yet bumped into from them, if it
> is not fixable (and I've seen them do some DUMB things...)
>
> Does anyone have a fix for this? Is it just me? Have I got something setting
> incorrectly set? If so, how do I correct it?
>
> I'm using a PPC Mac with OSX 10.4.10 and Excel 11.3.7.
>
> I appreciate anything anyone can offer!
>
> --Guy
> Thurston, OR

--
Team EM to the rescue! mailto:carl@Team-EM.com http://www.team-em.com
 >> Stay informed about: Is it just me...? 
Back to top
Login to vote
jpdphd

External


Since: Jun 08, 2007
Posts: 36



(Msg. 12) Posted: Wed Oct 03, 2007 2:05 am
Post subject: Re: Is it just me...? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

On Oct 2, 5:54 pm, JE McGimpsey <jemcgimp... RemoveThis @mvps.org> wrote:
> In article <carl-263C28.17183002102... RemoveThis @comcast.dca.giganews.com>,
> Carl Witthoft <c... RemoveThis @witthoft.com> wrote:
>
> > so yes, withing Excel you can lose the contents of
> > your last Copy operation. However, once you switch to a different
> > application, MacOS puts the contents into its own clipboard, and that
> > does not get lost. --- I just verified this w/ Excel-X on OSX 10.3.9 .
>
> Can you document exactly how you get XL to "lose the contents of the
> last Copy operation"?
>
> I can't make it happen at all, using the same XL version as the OP...

Guy & other guys,
I just want to point to a discussion in this forum in July 2006.

http://groups.google.com/group/microsoft.public.mac.office.excel/brows...hread/t

(I hope the link survives the line feeds - is there a better way to do
this?)

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?

jpdphd
 >> Stay informed about: Is it just me...? 
Back to top
Login to vote
Guy Kudlemyer

External


Since: Apr 01, 2005
Posts: 22



(Msg. 13) Posted: Wed Oct 03, 2007 1:40 pm
Post subject: I really don't think it's "just me..." [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

> 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.
 >> Stay informed about: Is it just me...? 
Back to top
Login to vote
Carl Witthoft

External


Since: Mar 22, 2004
Posts: 527



(Msg. 14) Posted: Wed Oct 03, 2007 5:50 pm
Post subject: Re: Is it just me...? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

In article <jemcgimpsey-3E7487.15543702102007.DeleteThis@msnews.microsoft.com>,
JE McGimpsey <jemcgimpsey.DeleteThis@mvps.org> wrote:

> In article <carl-263C28.17183002102007.DeleteThis@comcast.dca.giganews.com>,
> Carl Witthoft <carl.DeleteThis@witthoft.com> wrote:
>
> > so yes, withing Excel you can lose the contents of
> > your last Copy operation. However, once you switch to a different
> > application, MacOS puts the contents into its own clipboard, and that
> > does not get lost. --- I just verified this w/ Excel-X on OSX 10.3.9 .
>
> Can you document exactly how you get XL to "lose the contents of the
> last Copy operation"?
>
> I can't make it happen at all, using the same XL version as the OP...

Typically, inside Excel, the moment you take some action such as
hitting <ESC> or editing the contents of any cell, the "marching ants"
go away and the excel-clipboard (for lack of a better term) no longer
has content.
This may not be the way Office2004 works but I don't have one handy to
check at the moment.

--
Team EM to the rescue! mailto:carl@Team-EM.com http://www.team-em.com
 >> Stay informed about: Is it just me...? 
Back to top
Login to vote
JE McGimpsey

External


Since: Mar 07, 2004
Posts: 3828



(Msg. 15) Posted: Wed Oct 03, 2007 10:36 pm
Post subject: Re: Is it just me...? [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

In article <carl-BED25D.17503803102007 DeleteThis @comcast.dca.giganews.com>,
Carl Witthoft <carl DeleteThis @witthoft.com> wrote:

> Typically, inside Excel, the moment you take some action such as
> hitting <ESC> or editing the contents of any cell, the "marching ants"
> go away and the excel-clipboard (for lack of a better term) no longer
> has content.
> This may not be the way Office2004 works but I don't have one handy to
> check at the moment.

It's not the way MacXL has ever worked. For MacXL, there isn't any
"excel-clipboard", and never has been. The only clipboard is the system
clipboard.

So the marching ants go away, but one and only clipboard isn't cleared.

I've had to deal with this for years - many of my clients want MacXL to
work the way WinXL does - it requires that you load a blank data object
into the clipboard, a bit of a PITA.
 >> Stay informed about: Is it just me...? 
Back to top
Login to vote
Display posts from previous:   
   Macintosh computer (Home) -> Excel All times are: Pacific Time (US & Canada) (change)
Goto page 1, 2
Page 1 of 2

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]