Certain Sprites Not Pulling

[JMLEldridge]

Within the past week a few of the sprites stopped pulling - I tried switching from the gen8 sprites to gen7 to fill in, but neither will work.

dragonair dragonite mewtwo mewtwo-mega-x mewtwo-mega-y mew chikorita bayleef meganium cyndaquil quilava typhlosion totodile croconaw feraligatr sentret furret hoothoot noctowl ledyba ledian spinarak ariados crobat chinchou lanturn pichu pichu-spiky-eared Cleffa igglybuff

Using the formula =IMAGE(CONCATENATE("https://raw.githubusercontent.com/msikma/pokesprite/master/pokemon-gen8/regular/",C216,".png"),3)

[msikma]

Sorry for being a bit late in responding to this. Is this still a problem? Is your spreadsheet something I can see directly?

Not sure what could cause this, as the files appear to be there.

[JMLEldridge]

Yeah, it’s still an issue. It’s happening with cleffa (bred tab) and dragonite (event tab).

https://docs.google.com/spreadsheets/d/1AbojEJLSzLDgDUlbY3DnCYQ29KnjxwFqa_DAD7iSgFA/edit

No worries on the delayed response, just happy you responded at all :).

Sent from my iPhone

On Dec 29, 2020, at 5:50 PM, Michiel Sikma notifications@github.com wrote:

 Sorry for being a bit late in responding to this. Is this still a problem? Is your spreadsheet something I can see directly?

Not sure what could cause this, as the files appear to be there.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or unsubscribe.

[koenigderluegner]

Yeah, it’s still an issue. It’s happening with cleffa (bred tab) and dragonite (event tab). https://docs.google.com/spreadsheets/d/1AbojEJLSzLDgDUlbY3DnCYQ29KnjxwFqa_DAD7iSgFA/edit No worries on the delayed response, just happy you responded at all :).

To fix your problem with Cleffa: in C244 your Cleffa is written with a capital C causing the not found error. you can either fix the name, change the formula to ..., lower(c244), .... or replace the formula for bulbasaur with something like this =arrayformula(IMAGE(("https://raw.githubusercontent.com/msikma/pokesprite/master/pokemon-gen8/regular/"&LOWER(C2:C)&".png"),3)) (for this to work you have to clear all values below this formula so it can be populated by this one).

for Dragonite: I just pulled the formula cell above Dragonite into Dragonites cell and it worked (copying with changing the row numbers accordingly)

sometimes Googles caching/proxy mechainics stop loading new sprites, a simple refresh should do

[JMLEldridge]

I went ahead and switched the formula and it only populated the same pokemon in the resource tab (still the gap from dragonair through igglybuff) - maybe this is something wrong with my sheets that I will play around with some. Like you said, the sprites are there so there's something wrong with how google is pulling.

Thanks again, Jordan M. Eldridge Illinois Wesleyan University class of 2018 Biology/Pre-Med Major Phone: (217)617-6640

On Wed, Dec 30, 2020 at 7:28 AM Alexander notifications@github.com wrote:

Yeah, it’s still an issue. It’s happening with cleffa (bred tab) and dragonite (event tab). https://docs.google.com/spreadsheets/d/1AbojEJLSzLDgDUlbY3DnCYQ29KnjxwFqa_DAD7iSgFA/edit No worries on the delayed response, just happy you responded at all :).

To fix your problem with Cleffa: in C244 your Cleffa is written with a capital C causing the not found error. you can either fix the name, change the formula to ..., lower(c244), .... or replace the formula for bulbasaur with something like this =arrayformula(IMAGE((" https://raw.githubusercontent.com/msikma/pokesprite/master/pokemon-gen8/regular/ "&LOWER(C2:C)&".png"),3)) (for this to work you have to clear all values below this formula so it can be populated by this one).

for Dragonite: I just pulled the formula cell above Dragonite into Dragonites cell and it worked (copying with changing the row numbers accordingly)

sometimes Googles caching/proxy mechainics stop loading new sprites, a simple refresh should do

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/msikma/pokesprite/issues/98#issuecomment-752599295, or unsubscribe https://github.com/notifications/unsubscribe-auth/ASFQLW6N66EV55W626U3VMDSXMTHFANCNFSM4VBLUUOA .

[JMLEldridge]

After copying/pasting my entire tab to a new spreadsheet, everything started to pull. Must be something wrong with my original - thank you all so much!

[msikma]

I'm glad it was resolved. Thanks @koenigderluegner for checking it out! Let me know if any other problem crops up.