I’ve run into an annoying problem with Google Spreadsheets recently: I’m using Fuzzworks’ scripts to inject market data into a sheet, that reads typeids from another sheet. So far, so good.
Now I have my typeids arranged as a list by groups (ores, PI, advanced materials, etc…), where the numbers aren’t in increasing or decreasing order. I had the market data being injected in the same order as my typeids so far, until Google decided that the data would put the typeids in growing order. Now they don’t match the typeids order on the prices sheet, and they don’t read in return the right vallue from the market data sheet.
Long story short: is there a way to restore the typeids to be listed in the correct order? I’ve been looking everywhere but couldn’t find anything relevant. Many, many thanks for your help.