Forum Discussion

Jeff_Deutch300's avatar
Jeff_Deutch300
Copper Contributor
Apr 07, 2023
Solved

Image Function adding Implicit intersection At operator Image Function not working

The Image function is not working properly as part of an automated template definition that is adding an At sign when the Excel opens the file.  We believe this is due to the following upgrade in Exc...
excel
Formulas and Functions
  • Jeff_Deutch300's avatar
    Jeff_Deutch300
    Apr 25, 2023

    Jeff_Deutch300  SOLVED - formula should be #=_xlfn.image(x,x,x,x,x) - this works for the Caxlsx XML

    Appreciate everyone's support in helping resolve this issue.

    From Microsoft Support -Test Summary:  Test File https://urldefense.com/v3/__https:/salsify-dandelion.s3-external-1.amazonaws.com/1/6462/user_data_export/1/2023/04/24/19*3A08*3A58-10a33c9c/export.xlsx?response-content-disposition=attachment*3B*20filename*3D*22KHC-*202023*20US*20Retail*20Digital*20Catalog*20Product*20Feed_2023_04_24_19_08_58_UTC.xlsx*22&response-content-type=application*2Fvnd.openxmlformats-officedocument.spreadsheetml.sheet&X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=AKIARRX37GWVL5YUBHGV*2F20230424*2Fus-east-1*2Fs3*2Faws4_request&X-Amz-Date=20230424T190858Z&X-Amz-Expires=604800&X-Amz-SignedHeaders=host&X-Amz-Signature=ea2b3974870e0e990178369cdd6f05da7480b52116cc9e07fe5f05c363418c5b__;JSUlJSUlJSUlJSUlJSUlJSUlJQ!!JtwtF54jn92Iq-I!aCVhjnBQZNjS82lkmMca6Qnv_MxsKLH10bqpZJmih2oGWUXvo8a_KEg45LLkVl_iftNuuP8PfxijSlJM3qQxTp6BzJSVJQ4D$

     

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Apr 08, 2023

Lorenzo 

IMHO, it shall work in any case if only the file is opened in proper Excel version. Using of implicit intersection operand shall not cause #NAME? error.

Lorenzo's avatar
Lorenzo
Silver Contributor
Apr 08, 2023

SergeiBaklan 

 

Agree, this should work in any case (but obviously this doesn't...)

I didn't want to confuse Jeff_Deutch300 with the following that also addresses the issue here (but raises question):

 

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Apr 08, 2023

    Lorenzo 

    I'm not sure if + changes something for that function. And @IMAGE(AE2:AE2,.. shall work the same way as IMAGE(@AE2:AE2,...

    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      Apr 08, 2023

      SergeiBaklan 

      Agree, this should work but for some reason(s) the theory doesn't seem to apply here and for Jeff_Deutch300 

       

      The IMAGE function is currently available in 365, Web, IOS and Android only & nothing - in the formula exposed by Jeff - requires the intersection operator. If it was me I would look at elimating the intersection operator and the following seems to do it:

      =IMAGE(AE2,A2,3,100,100)

      (my view only and not my call) 

Resources