Processing Ajax...

Title
Close Dialog

Message

Confirm
Close Dialog

Confirm
Close Dialog

Confirm
Close Dialog

User Image
Matt Dralle
21 discussion posts
Hi Jon,

I really like your ClipboardFusion app. However, it seems to have a problem scrubbing text copied from an Excel spreadsheet cell. It often wants to add an extra set of double quotes around a body of text and/or add extra double quotes to existing double quotes in a string. This is when I single click on a cell, then copy it. If I double click on the cell and drag-n-copy the text, it works okay. I can email you a sample spreadsheet offline that I have the most trouble with, if you'd like.

You know, it would be really nice to have a user-configurable hot-key that would allow the user to enable/disable the Clipboard scrubbing feature....

Thanks!

Matt Dralle
Oct 20, 2009  • #1
User Image
Andrew McTeer (Bitporters)
93 discussion posts
Please check your personal forum messages I've sent you instructions to send this excel sheet to me.
Oct 22, 2009  • #2
Jon Tackabury (BFS)'s profile on WallpaperFusion.com
This has been fixed in the current 1.5 release. Thanks! :)
Feb 5, 2010  • #3
User Image
Matt Dralle
21 discussion posts
Quote:
This has been fixed in the current 1.5 release. Thanks! :)


Ah, nope. I've got version 1.5 and I'm still getting double sets of double quotes when scrubbing formatted text from an Excel spreadsheet.

For example, the following text in a Excel spreadsheet cell:

Now is the time for all "good" men to come to the aid of their country.

After scrubbing, shows up like this:

Now is the time for all ""good"" men to come to the aid of their country.

Matt
Feb 20, 2010  • #4
Jon Tackabury (BFS)'s profile on WallpaperFusion.com
What version of Excel are you using?
Feb 21, 2010  • #5
User Image
Matt Dralle
21 discussion posts
Office 2007

Matt
Feb 21, 2010  • #6
Jon Tackabury (BFS)'s profile on WallpaperFusion.com
Which scrubbing options are you using, and do you have anything entered on the "Text Replace" tab?
Feb 21, 2010  • #7
User Image
Matt Dralle
21 discussion posts
Quote:
Which scrubbing options are you using, and do you have anything entered on the "Text Replace" tab?


Well, I did some experimentation. If I close CF completely, and cut and paste formatted text from a cell into Eudora, it comes out fine. No double quotes, no color, just the text.

If I enable CF, and select "Scrub Clipboard text automatically", "Show message", "Scrub HTML", and just cut and paste formatted text from Excel into Eudora, the text looks fine - No double quotes, no color, just the text.

But, if I enable a Hot Key (Control 4) to Scrub Text and copy text from Excel, Hit the Hot Key, and then paste into Eudora, I end up with double quotes.

Interestingly, I get the same behavior with the Hot Key even when I have added Excel to the "Igonore Programs" tab in the CF options.

Matt
Feb 22, 2010  • #8
Jon Tackabury (BFS)'s profile on WallpaperFusion.com
Do you get the double-quotes when pasting into any other applications, or just Eudora? I have been testing this and I can't seem to reproduce the problem. :(

As for the ignored programs option, that really only applies to auto-scrubbing. If you use the HotKey to scrub the text you are forcing ClipboardFusion to scrub the text regardless of which application put the text there.
Mar 8, 2010  • #9
Subscribe to this discussion topic using RSS
Was this helpful?  Login to Vote(-)  Login to Vote(-)