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.stack.imgur.com/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.
=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.