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
**********************************************************************
