Title

Message

Confirm

<< DiscussionsReply

5.8.4 copy excel cell like image problem

Avatar from Gravatar.com
liovra
10 discussion posts
Hello,
5.8.4. shows in history not only cell value but adds additional unnecessary info, when copied from excel 2013.
How could I get only cell value, as previous versions behaved?

Thank you,
• Attachment: excel.jpg [7,710 bytes]
excel.jpg
excel.jpg
Jul 14, 2020  • #1
Thomas Malloch (BFS)'s profile on WallpaperFusion.com
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
Avatar from Gravatar.com
liovra
10 discussion posts
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]
2020-07-20 10_47_27-PO-SERGHEI.xlsx - Excel.jpg
2020-07-20 10_47_27-PO-SERGHEI.xlsx - Excel.jpg
• Attachment: 2020-07-20 10_47_59-PO-SERGHEI.xlsx - Excel.jpg [38,977 bytes]
2020-07-20 10_47_59-PO-SERGHEI.xlsx - Excel.jpg
2020-07-20 10_47_59-PO-SERGHEI.xlsx - Excel.jpg
Jul 20, 2020  • #3
Thomas Malloch (BFS)'s profile on WallpaperFusion.com
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
Avatar from Gravatar.com
liovra
10 discussion posts
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]
2020-07-21 07_08_11-PO-SERGHEI.xlsx - Excel.jpg
2020-07-21 07_08_11-PO-SERGHEI.xlsx - Excel.jpg
• Attachment: 2020-07-21 07_09_28-PO-SERGHEI.xlsx - Excel.jpg [20,820 bytes]
2020-07-21 07_09_28-PO-SERGHEI.xlsx - Excel.jpg
2020-07-21 07_09_28-PO-SERGHEI.xlsx - Excel.jpg
• Attachment: ClipboardFusionDebugInfo.zip [19,445 bytes]
Jul 21, 2020  • #5
Thomas Malloch (BFS)'s profile on WallpaperFusion.com
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
Avatar from Gravatar.com
liovra
10 discussion posts
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]
TRIGGER.xlsx - Excel.jpg
TRIGGER.xlsx - Excel.jpg
Jul 21, 2020  • #7
Avatar from Gravatar.com
liovra
10 discussion posts
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]
2020-07-21 11_34_58-PO-SERGHEI.xlsx - Excel.jpg
2020-07-21 11_34_58-PO-SERGHEI.xlsx - Excel.jpg
• Attachment [protected]: ClipboardFusionDebugInfo.zip [28,116 bytes]
Jul 21, 2020  • #8
Thomas Malloch (BFS)'s profile on WallpaperFusion.com
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
Avatar from Gravatar.com
liovra
10 discussion posts
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]
2020-07-22 07_05_30-Window.jpg
2020-07-22 07_05_30-Window.jpg
• Attachment [protected]: ClipboardFusionDebugInfo.zip [28,856 bytes]
Jul 22, 2020 (modified Jul 22, 2020)  • #10
Jon Tackabury (BFS)'s profile on WallpaperFusion.com
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
Avatar from Gravatar.com
liovra
10 discussion posts
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
Keith Lammers (BFS)'s profile on WallpaperFusion.com
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
Was this helpful?    
<< DiscussionsReply