ClipBoardChange - Excel issues

[Jenny100]

Hello AH Community.
Hoping to get some advice on a problem.

I am using the OnClipboardChange label and modified the example provided in the help just to save the clipboard contents if anything is copied into the clipboard:

Code: Select all

OnClipboardChange:
	FileAppend, %ClipboardAll%, c:\temp\data.bin
	

The script is running all the time in the background of course, but problem is Excel. If more than 64 rows are selected and COPIED, it shows the error:
"picture is too large and will be truncated"
and thus nothing is copied into the clipboard (or nothing that be saved for reproducing at a later date).

I found some info here: https://blog.techinline.com/2019/02/21/picture-is-too-large-and-will-be-truncated/
which states:

If your application interacts with the Windows clipboard using OLE technology, this indicates that somewhere your source code calls of the IDataObject interface. This interface contains the GetData method, which can result in the described Excel error when it tries to receive clipboard content in CF_METAFILEPICT format.
How to fix:
Skip the GetData call if the requested format is CF_METAFILEPICT."

Would anyone have any idea how the above info can be incorporated into the script to allow copying of excel data?
Grateful for your expertise.
Jen.

[BoBo]

Probably of interest regarding AHK v.2 too. So maybe @lexikos might be willing to shed some light on this. Good luck

[JnLlnd]

This "The Picture Is Too Large and Will Be Truncated" issue has been discussed in the following thread and a solution is proposed:
viewtopic.php?style=19&f=81&t=125745