Forum Discussion
Image Function adding Implicit intersection At operator Image Function not working
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$
LZ and Sergei,
I apologize for not responding sooner, but unfortunately, we are still unable to resolve the Image formula issue systematically, so we created a manual workaround. We tried your recommendations, we also worked with Microsoft Premier support along with the Vendor who creates the automated spreadsheet. We did learn that the spreadsheet is leveraging Caxlsx, which may be impacting the Image function. Here is our manual work around. See Column H that goes to a video telling users what to do. Any more suggestions would be appreciated.
Quickly read a few things about Caxlsx (unknown until now)
One thing that remains unclear to me: is the xlsx you attached "generated" by Caxlsx?
- https://github.com/caxlsx/caxlsx created the XML that was used to create the XLSX spreadsheet that i attached. Somehow, Excel is not recognizing the Image formula the when the spreadsheet is opening and is requiring the 'check' formula to recognize and process the image function. Is it generating the images for you without the check formula? As it may be a setting on our version of Excel.
Thanks for https://github.com/caxlsx/caxlsx - interesting reading. Not sure this is relevant but there are interesting things in sections Security & Known Software Interoperability Issues
That won't help fixing the issue and I can be wrong but I feel you face an interop. issue between "products". Assuming I'm not wrong, does the problem come from Excel or from the XML, only dev. would be in a position to say so (IMHO)
Given you involved MSFT Premier I guess this was tested but jut in case, what happens (do you get the @ operator in front of the formula?) if Caxlsx fills H2 with:
=IMAGE("https://images.salsify.com/image/upload/s--uF3yfZrg--/t_salsify_thumb/v1422298774/thumb_default.jpg","00021000007301",3,100,100)Also, if it was me I would raise the issue on https://stackoverflow.com/questions/tagged/axlsx
- thanks LZ - we are 99% sure that Excel is adding the "@" sign as follows .=@IMAGE(AE2,A2,3,100,100) thank you for the stackoverflow suggestion