This sheet shows the problem: https://docs.google.com/spreadsheets/d/1G_SXx_poARQ4muv3wxopV-zsSOoRwdNgssrvnfFOCVg/edit?usp=sharing
I have an image that is 41px by 1637px (https://i.sstatic.net/vklJ4.png) and I want to put it in a cell on the sheet that's also 1637px tall. However, when I use =image() to add the image, it's much smaller than that - and if I force it to be 1637px tall again, it looks really blurry, exactly as though I've resized up a much smaller picture.
How can I stop google resizing the image when it first imports it, so that I can make the image appear at its original size without looking blurry?
Edit for clarity:
The original image is 41px by 1637px tall. Using =image("url",3) displays an image in google sheets that is much smaller than this, even though the 3 should display the image at its original size.
Using =image("url",1) to resize the image to fit the size of the cell produces an image that is 1637px tall, but is very blurry because it's stretching the small image instead of displaying the actual original image size I want.
no mode causes the cell to be resized to fit the image.May I suggest you take a blank spreadsheet and reproduce the examples in the documentation for the IMAGE function. I found that the images shown in the "Result" column did not initially resemble my spreadsheet. I had to resize the cells to get them to match. Your IMGUR image is crystal clear when the formula ==image("https://i.imgur.com/dVhtrwT.png", 4, 1637, 41)and row is resized to 1637 pixels and Column to 41 pixels.