AHK Clipboard & Excel returns "The picture is too large and will be truncated" Topic is solved

[Guest1234]

Following situation:
- starting the below .ahk
- start MS Excel
- COPY from Excel a complete column (e.g.: column A:A) or at least 62 cells of a column

With this situation I get this error from Excel:
“The picture is too large and will be truncated”

Without running .ahk script it works without error.

I tried to increase memory with #MaxMem and VarSetCapacity but without success. Also added the ClipWait line in the code without success.

Does anyone have a hint?

Code: Select all

#Persistent 

OnClipboardChange("ClipChanged")

ClipChanged(Type)
{
   ClipSaved =   
   ClipSaved := ClipboardAll    
   ClipWait,5,1
}

[kon]

It's Excel, not AHK, that is displaying the error. #MaxMem and VarSetCapacity are not applicable.

ClipWait waits for the clipboard to contain any data. It already contains data. If you want to use clipwait, you need to clear the clipboard first (but then you are changing the clipboard contents, which would trigger OnClipboardChange, so you need to account for that). Correction:

If the clipboard changes while an OnClipboardChange label or function is already running, that notification event is lost. If this is undesirable, specify Critical as the label's first line. However, this will also buffer/defer other threads (such as the press of a hotkey) that occur while the OnClipboardChange thread is running.

/Correction

This post seems to suggest that Excel does not like it when other programs touch the clipboard:
https://answers.microsoft.com/en-us/mso ... 6f1f559438

This post suggests that increasing virtual memory may help (I'm skeptical). It also suggests removing Clip Organizer.
https://social.technet.microsoft.com/Fo ... orum=excel

Is there more to your script? Is that just an example? I don't see how that script could be useful because the ClipSaved variable is cleared as soon as the function returns.

Maybe your function could check if Excel is active and ignore those ones?

Edit: Corrected some of the OnClipboardChange comments above.

[foxhunter]

OFC this script itsself would make no sense. The script is only a "cleared" example, which is reduced to/showing the core problem. I have this problem with Win7 + Excel 2010 and 2013 (no other Excel/OS tested).
Also I though of an check if Excel is activce, but the reason for use that script is to save the clipboarddata because a "special" other program does overwrite clipboard with it's own data. So this would be the last option for me.

[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