This should be doable with a Trigger. Here's how to set it up:

• Open the ClipboardFusion Settings window to the "Triggers" tab
• Click Add > Trigger
• In the Match Conditions section, enable "Process Filename" and select Microsoft Excel as the application
• In the Actions section, click Add > Remove Non-Text Formats
• Click OK on all open Settings windows to save and apply your changes

Thanks!

Jul 20, 2020  • #2

Hi Thomas,
I have done exactly as requested but it does not trigger on copy.
Please check attached.

If I run version 5.7 I do not have this problem at all.

Is this only me who encounter this problem?

thank you,
Serghei

• Attachment: 2020-07-20 10_47_27-PO-SERGHEI.xlsx - Excel.jpg [63,849 bytes]

• Attachment: 2020-07-20 10_47_59-PO-SERGHEI.xlsx - Excel.jpg [38,977 bytes]

Jul 20, 2020  • #3

Could you send me a debug log? Here's how to get that to us:

• On the ClipboardFusion Settings > Troubleshooting tab, change the Logging drop-down to "L1: Log Minimal" and click Apply
• Reproduce the issue and note the time so we'll know where to check in the log file
• Click the "Export Info to File" button on the Settings > Troubleshooting tab
• Reply with the file attached
• Disable debug logging after sending the log

Thanks!

Jul 21, 2020  • #4

Please find attached the log file and first attachment (cell copy was at 07:05:03). The possible cause as I see it would be that the program treats the cell of the excel as an object and not as a text (exactly as an image).
If I enable the option "Show Clipboard changes made by ClipboardFusion" then the trigger "Remove Non-Text Formats" gets into the play and in this case the history produces 2 variants of the copied cell - as an object and as a stripped text (second attachment).
I do not think that the solution with the trigger is a right one. You let the program copy and reproduce additional unnecessary information only that afterwords to get rid of this with the trigger.

Thank you.

• Attachment: 2020-07-21 07_08_11-PO-SERGHEI.xlsx - Excel.jpg [21,564 bytes]

• Attachment: 2020-07-21 07_09_28-PO-SERGHEI.xlsx - Excel.jpg [20,820 bytes]

• Attachment: ClipboardFusionDebugInfo.zip [19,445 bytes]

Jul 21, 2020  • #5

Another thing you can try is to make sure the Trigger Command is set. Here's how to check:

• Right-Click the ClipboardFusion Icon
• Enable "Trigger Command Setting" > "Enabled on Copy"

If that's enabled, then your Triggers should work for you. If they still don't, would you be able to send us a debug log? Here's how you can get that to us:

• On the ClipboardFusion Settings > Troubleshooting tab, change the Logging drop-down to "L1: Log Minimal" and click Apply
• Reproduce the issue and note the time so we'll know where to check in the log file
• Click the "Export Info to File" button on the Settings > Troubleshooting tab
• Reply with the file attached
• Disable debug logging after sending the log

Thanks!

Jul 21, 2020  • #6

The Trigger is up and running. "Enabled on Copy" was enabled.
You have a proof of it in my last attachment I sent you before.
They Trigger strips the copied excel cell of any non-text info but a drawback is that the program keeps in the history the non-stripped copy.

• Attachment: TRIGGER.xlsx - Excel.jpg [20,820 bytes]

Jul 21, 2020  • #7

I attach the log file.
Trigger "Remove Non-Text Formats" and Show Clipboard changes made by Fusion are enabled.
An excel cell with number 6044569 is copied on 11:31:57.
As a result I have 2 copies of this cell: "image" like copy and text copy.

• Attachment: 2020-07-21 11_34_58-PO-SERGHEI.xlsx - Excel.jpg [15,196 bytes]

• Attachment [protected]: ClipboardFusionDebugInfo.zip [28,116 bytes]

Jul 21, 2020  • #8

You mentioned earlier that this was working in a way you expected in a previous version. Which version were you using?

We'd love to get to the bottom of this for you!

Jul 22, 2020  • #9

Version 5.7 is behaving OK for me in this regard.
I attach a screenshot and the log file.
The cell with the value GB22DU16 was copied at 07:04:55. No trigger is set up for this version of Fusion.

Thank you for your assistance. I can do with 5.7, no problem but that may be an issue for others with the latest version.
Thank you again.

• Attachment: 2020-07-22 07_05_30-Window.jpg [68,907 bytes]

• Attachment [protected]: ClipboardFusionDebugInfo.zip [28,856 bytes]

Jul 22, 2020 (modified Jul 22, 2020)  • #10

Can you give this newly released beta version a try and let me know if it helps your issue?

https://www.clipboardfusion.com/Download/Beta/

Thanks!

Jul 22, 2020  • #11

Hi Jon,
thank you for your efforts.
v5.8.5, Beta 1 - same outcome persists:
Trigger "Remove Non-Text Formats" is enabled. As a result I have 2 copies of excel cell: "image" like copy and text only copy.
Trigger "Remove Non-Text Formats" is disabled. As a result I have only an image like copy with additional info.

Thank you.

Jul 23, 2020  • #12

I've had a chat with our developers about this, and it looks like this is the expected behaviour, due to a fix for another issue that we fixed in 5.8. Microsoft Office apps actually put image data on the clipboard, we just weren't representing it that way in previous versions. For now, the best way to get just the plain text would be to use that Trigger rule. The image data is left in the history, as a new entry is created for the plain text that was scrubbed by the Trigger rule.

I'll put this feedback on our list as well, as maybe in the future we can add an option to force Microsoft Office apps to only put the plaintext in the history.

Thanks!

Jul 29, 2020  • #13