Author Topic: CHS causing "the picture is too large and will be truncated" error in excel? (Read 23,285 times)

m9833 · « **Reply #25 on:** May 07, 2020, 10:58 AM »

Hmmm! Is there any troubleshooting routine that I can follow, which can give you the most important information about what might be causing this error. At the moment, it seems that I am the only one having this issue.

mouser · « **Reply #26 on:** May 07, 2020, 12:43 PM »

Try this:
1. first make sure the error is still happening
2. Assuming so, post a screenshot of your rules in CHS
3. And then try another rule for excel like the first, but this time reject CF_ENHMETAFILE.
4. Problem persists then show me another screenshot of your rules.

m9833 · « **Reply #27 on:** May 19, 2020, 02:16 AM »

Hi Mouser,

Sorry for the delayed reply. I got caught up in a project and had turned off CHS for a few days.

Today I tried out the different combinations you suggested:

Rejecting CF_METAFILEPICT resulted in the excel error "The picture is too large and will be truncated", every time I copied the entire (even blank) excel worksheet:

Then I tried rejecting CF_ENHMETAFILE. The error remained, every time I copied the entire (even blank) excel worksheet:

After this, I rejected both CF_METAFILEPICT and CF_ENHMETAFILE. Same error, every time I copied the entire (even blank) excel worksheet:

I unintentionally changed the settings to store CF_METAFILEPICTand reject CF_ENHMETAFILE. The same error occured once. But when I tried copying again, there was no error. Interesting this is happening everytime now. The error turns up once and then I am able to copy as usual, with this setting:

Looking for other similar errors or references to the two clipbard formats and excel, I came across these two webpages:

http://www.mschaef.com/what_is_in_your_clipboard (Not related to the error, but interesting as to my untrained eye, this looks similar to the Blob entry in CHS)

https://sourceforge.net/p/ditto-cp/discussion/287511/thread/af8d949a/?limit=25 (Similar error with these two clipboard formats. No resolution posted)

Thanks :-)

m9833 · « **Reply #28 on:** May 19, 2020, 02:23 AM »

Information from https://blog.techinline.com/2019/02/21/picture-is-too-large-and-will-be-truncated/

Code

As soon as you identify the software that’s causing the error, contact its developer and share the below instructions with them:

Information for developers:
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.

m9833 · « **Reply #29 on:** June 25, 2020, 08:27 AM »

Latest Update:

After the changes made in my last post, "The picture is too large and will be truncated" error was occurring once every-time I restarted and copied something from excel. Since a couple of weeks that no longer is the case. I am not receiving any error at all and everything is functioning fine. In case there is any change in this pattern, I will report back here.

Author Topic: CHS causing "the picture is too large and will be truncated" error in excel? (Read 23,285 times)

m9833

Re: CHS causing "the picture is too large and will be truncated" error in excel?

mouser

Re: CHS causing "the picture is too large and will be truncated" error in excel?

m9833

Re: CHS causing "the picture is too large and will be truncated" error in excel?

m9833

Re: CHS causing "the picture is too large and will be truncated" error in excel?

m9833

Re: CHS causing "the picture is too large and will be truncated" error in excel?