Using Google Sheets I'm trying to populate a list of countries with (among others) names, ISO-alfa2 code, and flags. I use this IMAGE() and ArrayFormula() to get the flags from URL in my private server:
=ARRAYFORMULA( IMAGE(URL/"&P7:P224&".png"))
Where URL is the link hosting the flags, RANGE P7:P222 contains ISO 3166-1 alpha-2 codes (all in upper case). The flags in the URL labeled with the same ISO codes except with lower case.
As shown in the attached picture, some flags randomly don't show up despite that all ISO codes have been entered the same way (all upper case) and all the flags images are lower case.
Things I tried:
When using LOWER(P7:P222), some flags don't show up.
When using UPPER(P7:P222) some different flags don't show up.
I used both Chrome and Firefox to view and edit the sheet.
Is there a way to fix this without changing the range to lower case or the images name to upper case? Is it something wrong with my formula or is it just the browser, HTTP/GET or Google app is misbehaving? Any input is greatly appreciated!
UPDATE: Looks like this has nothing to do with case-sensitivity as I changed range P7:P221 to LOWER case, however, the problem persists and some images randomly don't show up.. Does this mean the IMAGE() formula
is broken?
IMPORTANT UPDATE: Further tested the following:
- Used
image()to get images from Google Driver: no luck. - Inserted images manually: they disappear after a while.
- Used ImageKit addon to insert images from URL (Google Driver and other servers): and via upload from my PC: Yield same results as using
image()formula.
I also changed the title of the question accordingly.
Link to the sheet: https://docs.google.com/spreadsheets/d/1nd1gbRm0eD2lvUa58jHjacdTYd7fqhGP4YpYeMZWRzo/edit?usp=sharing
