I should have said - I've googled it myself and found the suggestions about clearing the Excel/Office clipboard. I've tried clearing the temp folder and the clipboard items from Excel. It did not help.
We've seen this problem with the rdpclip.exe process in remote desktop sessions, and I've heard of it showing up with TeamViewer, Delphi, and third party clipboard managers. If you exit 4D, and keep copying in Excel, it stops happening, so it is definitely related to 4D, if not caused by 4D. The bottom line is that this happens consistently for a customer, and they know that if they exit 4D it stops happening, so they expect us to find a solution. Thanks, Jim On Mon, Dec 17, 2018 at 5:11 AM Epperlein, Lutz (agendo) via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I'm pretty sure the problem hasn't any relation to 4D. A quick search with > the > engine of your choice shows many results: "Excel The picture is too large > and > will be truncated" > e.g. > > https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10/error-the-picture-is-too-large-and-will-be/fc8f6431-13c8-47f2-a4ee-2e8c04e50227 > > In short: The user should delete the temp folder and all clipboard items. > > Regards > Lutz > > > > -----Original Message----- > > We've seen this error over the years, but not so much recently. Now it > > seems to be back. > > This is using Windows 10 build 1803, Office Professional Plus build 1811 > , > > 4D v12.6, _and_ 4D v17hf3 (32 bit). > > > > "The picture is too large and will be truncated" > > > > Select a fairly large Range in Excel and Copy. If 4D is running and not > > minimized, you may get the message. > > Super annoying to accounting types who live in Excel. > > > > It may depend on what is showing in 4D. An window with enterable > objects, a > > plug-in like AreaList, etc. > > It's similar to the old hang when running a Remote Desktop session to a > > server running 4D Server. Killing the rdpclip.exe process fixed that. > > > > Does anyone have any answers to prevent this? Can we tell 4D to not try > to > > interpret the clipboard? > > "On Deactivate 4D" set Focus to a non-enterable form object? > > > > For what its worth, I did some tests with this code, based on the > > documentation. > > Copying a Sheet from Excel could produce a 100MB emf picture format, > along > > with UTF16 and native text. > > > > > > ARRAY TEXT(4Dsignatures;0) > > ARRAY TEXT(nativeTypes;0) > > ARRAY TEXT(formatNames;0) > > > > GET PASTEBOARD DATA TYPE(4Dsignatures;nativeTypes;formatNames) > > $totalSize_r:=0 > > For ($i;1;Size of array(4Dsignatures)) > > If (4Dsignatures{$i}#"") > > $size_r:=Pasteboard data size(4Dsignatures{$i}) > > $totalSize_r:=$totalSize_r+$size_r > > $msg:=4Dsignatures{$i}+": "+String($size_r;"###,###,### bytes") > > ALERT($msg) > > End if > > End for > > > > ALERT("Total Size: "+String($totalSize_r;"###,###,###")) > > > > Thanks, > > > > Jim > > ********************************************************************* > > * > > 4D Internet Users Group (4D iNUG) > > Archive: http://lists.4d.com/archives.html > > Options: https://lists.4d.com/mailman/options/4d_tech > > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > > ********************************************************************* > > * > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************
