Title

Message

Confirm

<< DiscussionsReply

MS Excel -- Format Painter Not Working

Avatar from Gravatar.com
Steve Greenbaum342084
13 discussion posts
I purchased ClipboardFusion this week and I've noticed that Excel Format Painter no longer works when CBFusion is running. As soon as a shutdown CBFusion Format Painting works again. I've found the problem when using Excel 2016 and older versions too. Is this a known issue?

The symptom is that when I select the Format Painter button in Excel the cursor no longer turns into a paintbrush, therefore, the format can't be painted onto a different cell.

My operating system is Windows 10 - Fall Creator edition.

Thanks
Nov 11, 2017  • #1
Keith Lammers (BFS)'s profile on WallpaperFusion.com
Excel does some crazy stuff with the clipboard, and doesn't really like it when other apps touch the clipboard while it has control over it. I'd recommend adding Excel to the list on the ClipboardFusion Settings > Ignore Programs tab
Nov 13, 2017  • #2
Avatar from Gravatar.com
Steve Greenbaum342084
13 discussion posts
Yes, that is what I did and now Format Painter is working again. So the downside is that I can't use CBFusion in Excel. That's a manageable situation for me and far better than format painter not working. Thanks
Nov 13, 2017  • #3
Keith Lammers (BFS)'s profile on WallpaperFusion.com
No worries! Another alternative would be to exclude Excel from the Text Scrubbing Trigger rule on Settings > Triggers. You can do this by putting the following into the "Window Text" condition in the Trigger rule:

-Excel

That way, it should still add entries to the history, but the clipboard won't be modified by ClipboardFusion at all.
Nov 14, 2017  • #4
Avatar from Gravatar.com
Steve Greenbaum342084
13 discussion posts
I found that I was able to suppress the trigger for the Scrub Text trigger by using the Process Filename property, not the Window Text property. The Excel window title changes with each workbook that is opened so it didn't seem to work, but switching to Process Filename (just browse to select the Excel application) works well. The trigger approach is better than the ignore program approach since Format Painter and CBFusion still works within Excel, you just don't get to use the trigger functionality.
Nov 17, 2017  • #5
Keith Lammers (BFS)'s profile on WallpaperFusion.com
Excellent, glad to hear that works for you!
Nov 17, 2017  • #6
Was this helpful?  (1)  
<< DiscussionsReply