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$
++1 who:
- Finds the time to raise an issue
- Finds the time to say this & that doesn't help/work
- Does not find the time to provide feedback/mark solution when one potentially exists
=> NET RESULT: next time someone else has a similar issue, actual contributors to this forum will re-invent the wheel
(Thank You)
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.