How do I stop Excel from deleting the Window's Clipboard Contents

[Guest]

Note: This is with the Office Clipboard turned OFF!

For example, If I write the following in 5 cells in Excel.

[Hello ][My ][Name ][Is ][Fred ]

Then I Copy (CTRL+C) the Cells: [Is ] and [Fred ] to the
Clipboard...

Then I press [Esc] (there are a dozen other ways to do this, but, this is
the simplest)

Now, I go to any cell, anywhere in my workbook, and press Paste (CTRL+V)...

No Data... If I open up Notepad... Paste (CTRL+V).... No Data...

Excel has *decided* for me, that I want to delete the Window's Clipboard
Contents.

Although I have NEVER, EVER wanted to do this, this is what it does...

So, any ideas on how to fix?

I'm open to Registry Hacks, VBA Macros, or even tag along apps, that sniff
for the Escape Key, and save the clipboard, then send the escape, then reset
the clipboard...

Thank you, any help appreciated.

 

[Frank Kabel]

Hi
this is just the way Excel's cell formating works. One workaround:
Highlight your data in the formula bar and then press CTRL+C

Or simply avoid pressing ESC BEFORE pasting the data

 

[kkknie]

When you hit escape, the cells are no longer selected, so are not on th
clipboard anymore. If you don't hit escape, they should paste fine.
Why are you hitting escape?

If you were to edit a cell (F2), select its content and it Ctrl-C, the
would truly be copied to the clipboard.

 

[Guest]

Allow me to elaborate:

In Windows, I can copy anything to the Clipboard, by pressing CTRL+C.

The ONLY way to remove it, is:

a.) Cut or Copy new content to the clipboard (thus it is erased)
b.) Use a 3rd party application or script, to clear it

I'm ANNOYED, because Excel, has broken this rule, such that [Esc] (and other
things*), can ERASE the Clipboard contents.

Since I want to copy multiple cells, the [F2] / Formula bar won't work.

Not pressing [Esc], is also NOT an option. PS If anyone knows how to get
rid of the flashing dashed box after a Cut operation, without pressing [Esc],
please let me know.

Consider this, slightly more involved example.

A worksheet, with 20 Columns, and 40 Rows, full of data/formulas (including
some blank rows)
User decides, to Cut 5 Rows out.... (to be pasted in, elsewhere, later)
User finds the location where s/he wants to "drop" the data, but there isn't
enough room (rows).
So user, right clicks on the row headers, and is about to choose...
"Insert", but that option has been replaced with "Insert Copied Cells" (which
is UNDESIRED).

So, user presses [Esc], to get rid of the highlighted cells (that were
SUPPOSED to be CUT from the worksheet), so s/he can insert rows...

User inserts say... 10 rows, and goes to Paste the data they placed on the
Clipboard.... but its ERASED!

Now, if s/he copies from another Application, via the Clipboard, this issue
doesn't arise, Rows can be inserted, and the data can be Pasted as desired,
and nothing is deleted from the Clipboard.


*Other things that cause this Bug.
2.) Pressing [Esc], in another, unrelated worksheet, or workbook.
3.) Cut data, then goto another cell, go: Menu > Insert (Rows, Columns,
etc.) [This inserts the row, and deletes the clipboard.]
4.) R-Click Row/Column Headers > Clear Contents
5.) R-Click Row/Column Headers > Format Cells...
6.) Saving the document
7.) Changing (or even looking at) Menu > Tools > Options
etc.

The debate, is not over, whether this IS a Bug, or not (as I've had MS
Personel verify that it is), the question is, is there a realistic
workaround?... a Registry Hack?... a Secret Option?... a 3rd party tool?...
or ??? That will put an end to this totally frustrating, unwanted behaviour.

E.g. A Sniffer, that checks for calls, to Clipboard.clear() that interupts,
and prompts the user.
"A Script or Application is attempting to Clear the Windows Clipboard.
Allow?

[Yes] [[No]]"

Where No, is the Default.

Sorry for the rant, but again, any help appreciated.
Cheers.

 

[Frank Kabel]

Hi
no, this is IMHO nota bug (documented behaviour). One can argue if this
is a desirable behaviour or not though. And AFAIK there's no workaround
for this

--
Regards
Frank Kabel
Frankfurt, Germany

Allow me to elaborate:

In Windows, I can copy anything to the Clipboard, by pressing CTRL+C.

The ONLY way to remove it, is:

a.) Cut or Copy new content to the clipboard (thus it is erased)
b.) Use a 3rd party application or script, to clear it

I'm ANNOYED, because Excel, has broken this rule, such that [Esc] (and other
things*), can ERASE the Clipboard contents.

Since I want to copy multiple cells, the [F2] / Formula bar won't work.

Not pressing [Esc], is also NOT an option. PS If anyone knows how to get
rid of the flashing dashed box after a Cut operation, without pressing [Esc],
please let me know.

Consider this, slightly more involved example.

A worksheet, with 20 Columns, and 40 Rows, full of data/formulas (including
some blank rows)
User decides, to Cut 5 Rows out.... (to be pasted in, elsewhere, later)
User finds the location where s/he wants to "drop" the data, but there isn't
enough room (rows).
So user, right clicks on the row headers, and is about to choose...
"Insert", but that option has been replaced with "Insert Copied Cells" (which
is UNDESIRED).

So, user presses [Esc], to get rid of the highlighted cells (that were
SUPPOSED to be CUT from the worksheet), so s/he can insert rows...

User inserts say... 10 rows, and goes to Paste the data they placed on the
Clipboard.... but its ERASED!

Now, if s/he copies from another Application, via the Clipboard, this issue
doesn't arise, Rows can be inserted, and the data can be Pasted as desired,
and nothing is deleted from the Clipboard.


*Other things that cause this Bug.
2.) Pressing [Esc], in another, unrelated worksheet, or workbook.
3.) Cut data, then goto another cell, go: Menu > Insert (Rows, Columns,
etc.) [This inserts the row, and deletes the clipboard.]
4.) R-Click Row/Column Headers > Clear Contents
5.) R-Click Row/Column Headers > Format Cells...
6.) Saving the document
7.) Changing (or even looking at) Menu > Tools > Options
etc.

The debate, is not over, whether this IS a Bug, or not (as I've had MS
Personel verify that it is), the question is, is there a realistic
workaround?... a Registry Hack?... a Secret Option?... a 3rd party tool?...
or ??? That will put an end to this totally frustrating, unwanted behaviour.

E.g. A Sniffer, that checks for calls, to Clipboard.clear() that interupts,
and prompts the user.
"A Script or Application is attempting to Clear the Windows Clipboard.
Allow?

[Yes] [[No]]"

Where No, is the Default.

Sorry for the rant, but again, any help appreciated.
Cheers.

When you hit escape, the cells are no longer selected, so are not on the
clipboard anymore. If you don't hit escape, they should paste fine.
Why are you hitting escape?

If you were to edit a cell (F2), select its content and it Ctrl-C, they
would truly be copied to the clipboard.

K


--
kkknie
--------------------------------------------------------------------- ---
kkknie's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=7543
View this thread: http://www.excelforum.com/showthread.php?threadid=266631

 

[Guest]

Frank,

Well, if the documentation, indicates this is how it works, then, well sure,
not a bug.
[That said, I can't find such documentation... If you go into Help > Answer
Wizard > Type: "Cut" [Enter] > Select "Move or Copy cells" > Expand "Move or
copy Cells" > 1., 2., 3.]
PS The very last line... about cancelling the "moving border", DOES NOT,
explain how Excel, will DELETE the contents of the Clipboard, if used.

However, I think it is safe to say (ok, my research is limitted, but of the
50-100 users I have mentioned this too, only 2 (you and kkknie, of this
group), have disagreed.)

Since it so clearly does go against the Standard Windows Application
Behaviour, I think it is fair, to ask that Microsoft implement a Toggle for
this Behaviour. (less than 10 lines of VB by my books)

Tools > Options > Edit (Tab)

[x] Use Excel Cut/Copy/Paste behaviour.
+------------------------------------------------------------+
| Excel can assist users visually with Cut/Copy/Paste |
| operations by managing the Windows Clipboard for |
| you. If you want to use the standard Windows |
| Cut/Copy/Paste behaviour, uncheck this option |
+------------------------------------------------------------+

(or similar)

So? no workaround eh?... Well, guess its time to break out the Visual
Studio... ugh...

Cheers.

Hi
no, this is IMHO nota bug (documented behaviour). One can argue if this
is a desirable behaviour or not though. And AFAIK there's no workaround
for this

--
Regards
Frank Kabel
Frankfurt, Germany

Allow me to elaborate:

In Windows, I can copy anything to the Clipboard, by pressing CTRL+C.

The ONLY way to remove it, is:

a.) Cut or Copy new content to the clipboard (thus it is erased)
b.) Use a 3rd party application or script, to clear it

I'm ANNOYED, because Excel, has broken this rule, such that [Esc] (and other
things*), can ERASE the Clipboard contents.

Since I want to copy multiple cells, the [F2] / Formula bar won't work.

Not pressing [Esc], is also NOT an option. PS If anyone knows how to get
rid of the flashing dashed box after a Cut operation, without pressing [Esc],
please let me know.

Consider this, slightly more involved example.

A worksheet, with 20 Columns, and 40 Rows, full of data/formulas (including
some blank rows)
User decides, to Cut 5 Rows out.... (to be pasted in, elsewhere, later)
User finds the location where s/he wants to "drop" the data, but there isn't
enough room (rows).
So user, right clicks on the row headers, and is about to choose...
"Insert", but that option has been replaced with "Insert Copied Cells" (which
is UNDESIRED).

So, user presses [Esc], to get rid of the highlighted cells (that were
SUPPOSED to be CUT from the worksheet), so s/he can insert rows...

User inserts say... 10 rows, and goes to Paste the data they placed on the
Clipboard.... but its ERASED!

Now, if s/he copies from another Application, via the Clipboard, this issue
doesn't arise, Rows can be inserted, and the data can be Pasted as desired,
and nothing is deleted from the Clipboard.


*Other things that cause this Bug.
2.) Pressing [Esc], in another, unrelated worksheet, or workbook.
3.) Cut data, then goto another cell, go: Menu > Insert (Rows, Columns,
etc.) [This inserts the row, and deletes the clipboard.]
4.) R-Click Row/Column Headers > Clear Contents
5.) R-Click Row/Column Headers > Format Cells...
6.) Saving the document
7.) Changing (or even looking at) Menu > Tools > Options
etc.

The debate, is not over, whether this IS a Bug, or not (as I've had MS
Personel verify that it is), the question is, is there a realistic
workaround?... a Registry Hack?... a Secret Option?... a 3rd party tool?...
or ??? That will put an end to this totally frustrating, unwanted behaviour.

E.g. A Sniffer, that checks for calls, to Clipboard.clear() that interupts,
and prompts the user.
"A Script or Application is attempting to Clear the Windows Clipboard.
Allow?

[Yes] [[No]]"

Where No, is the Default.

Sorry for the rant, but again, any help appreciated.
Cheers.

When you hit escape, the cells are no longer selected, so are not on the
clipboard anymore. If you don't hit escape, they should paste fine.
Why are you hitting escape?

If you were to edit a cell (F2), select its content and it Ctrl-C, they
would truly be copied to the clipboard.

K


--
kkknie
--------------------------------------------------------------------- ---
kkknie's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=7543
View this thread: http://www.excelforum.com/showthread.php?threadid=266631

 

[Frank Kabel]

Hi Bonzo
I agree with you that this is not a common Windows behaviour (and not
very intuitive). The reason for this could be that you have special
options for pasting the data this way:
- Transposing
- only copying formats
- etc.
Could be that this wouldn't be possible if the source range is not
selected.

So as said I also would´like to have this kind of toggle

--
Regards
Frank Kabel
Frankfurt, Germany

Frank,

Well, if the documentation, indicates this is how it works, then, well sure,
not a bug.
[That said, I can't find such documentation... If you go into Help > Answer
Wizard > Type: "Cut" [Enter] > Select "Move or Copy cells" > Expand "Move or
copy Cells" > 1., 2., 3.]
PS The very last line... about cancelling the "moving border", DOES NOT,
explain how Excel, will DELETE the contents of the Clipboard, if used.

However, I think it is safe to say (ok, my research is limitted, but of the
50-100 users I have mentioned this too, only 2 (you and kkknie, of this
group), have disagreed.)

Since it so clearly does go against the Standard Windows Application
Behaviour, I think it is fair, to ask that Microsoft implement a Toggle for
this Behaviour. (less than 10 lines of VB by my books)

Tools > Options > Edit (Tab)

[x] Use Excel Cut/Copy/Paste behaviour.
+------------------------------------------------------------+
| Excel can assist users visually with Cut/Copy/Paste |
| operations by managing the Windows Clipboard for |
| you. If you want to use the standard Windows |
| Cut/Copy/Paste behaviour, uncheck this option |
+------------------------------------------------------------+

(or similar)

So? no workaround eh?... Well, guess its time to break out the Visual
Studio... ugh...

Cheers.

Hi
no, this is IMHO nota bug (documented behaviour). One can argue if this
is a desirable behaviour or not though. And AFAIK there's no workaround
for this

--
Regards
Frank Kabel
Frankfurt, Germany

Allow me to elaborate:

In Windows, I can copy anything to the Clipboard, by pressing CTRL+C.

The ONLY way to remove it, is:

a.) Cut or Copy new content to the clipboard (thus it is erased)
b.) Use a 3rd party application or script, to clear it

I'm ANNOYED, because Excel, has broken this rule, such that [Esc] (and other
things*), can ERASE the Clipboard contents.

Since I want to copy multiple cells, the [F2] / Formula bar won't work.

Not pressing [Esc], is also NOT an option. PS If anyone knows

how to
get

rid of the flashing dashed box after a Cut operation, without pressing [Esc],
please let me know.

Consider this, slightly more involved example.

A worksheet, with 20 Columns, and 40 Rows, full of data/formulas (including
some blank rows)
User decides, to Cut 5 Rows out.... (to be pasted in, elsewhere, later)
User finds the location where s/he wants to "drop" the data, but there isn't
enough room (rows).
So user, right clicks on the row headers, and is about to choose...
"Insert", but that option has been replaced with "Insert Copied Cells" (which
is UNDESIRED).

So, user presses [Esc], to get rid of the highlighted cells (that were
SUPPOSED to be CUT from the worksheet), so s/he can insert rows...

User inserts say... 10 rows, and goes to Paste the data they

placed
on the

Clipboard.... but its ERASED!

Now, if s/he copies from another Application, via the Clipboard,

this
issue

doesn't arise, Rows can be inserted, and the data can be Pasted

as
desired,

and nothing is deleted from the Clipboard.


*Other things that cause this Bug.
2.) Pressing [Esc], in another, unrelated worksheet, or workbook.
3.) Cut data, then goto another cell, go: Menu > Insert (Rows, Columns,
etc.) [This inserts the row, and deletes the clipboard.]
4.) R-Click Row/Column Headers > Clear Contents
5.) R-Click Row/Column Headers > Format Cells...
6.) Saving the document
7.) Changing (or even looking at) Menu > Tools > Options
etc.

The debate, is not over, whether this IS a Bug, or not (as I've

had
MS

Personel verify that it is), the question is, is there a realistic
workaround?... a Registry Hack?... a Secret Option?... a 3rd

party
tool?...

or ??? That will put an end to this totally frustrating, unwanted behaviour.

E.g. A Sniffer, that checks for calls, to Clipboard.clear() that interupts,
and prompts the user.
"A Script or Application is attempting to Clear the Windows Clipboard.
Allow?

[Yes] [[No]]"

Where No, is the Default.

Sorry for the rant, but again, any help appreciated.
Cheers.










:


When you hit escape, the cells are no longer selected, so are

not
on the

clipboard anymore. If you don't hit escape, they should paste fine.
Why are you hitting escape?

If you were to edit a cell (F2), select its content and it

Ctrl-C,
they

would truly be copied to the clipboard.

K