by zed » Mon Jun 13, 2011 6:16 am
Hi again,
I use the ImportRange() function in google docs to import certain cells from a larger spreadsheet into a new spreadsheet designed specifically for the import format of flashcards deluxe. The spreadsheet that I import into flashcards deluxe is 200 rows high by 5 columns wide. What happens is that the spreadsheet imports but the first card has the word "Loading..." and the rest of the cards have a "-" character. The only way to get it to download properly is if I log into google docs and view the spreadsheet containing the ImportRange() function. When I do this in google docs I initially see the first cell with the word "Loading..." and the other cells all have a dash, but if I wait a few seconds it updates and I see the values. So in google docs it takes a couple of seconds before you see the real values of the cells. It looks like google have a problem with their API for whatever function you're using to retrieve the spreadsheet (it is not waiting for the retrieval of cell content before passing the answer on to flashcards deluxe), but maybe a workaround could be to just sleep a couple of seconds before actually retrieving the data.
Zed
Hi again,
I use the ImportRange() function in google docs to import certain cells from a larger spreadsheet into a new spreadsheet designed specifically for the import format of flashcards deluxe. The spreadsheet that I import into flashcards deluxe is 200 rows high by 5 columns wide. What happens is that the spreadsheet imports but the first card has the word "Loading..." and the rest of the cards have a "-" character. The only way to get it to download properly is if I log into google docs and view the spreadsheet containing the ImportRange() function. When I do this in google docs I initially see the first cell with the word "Loading..." and the other cells all have a dash, but if I wait a few seconds it updates and I see the values. So in google docs it takes a couple of seconds before you see the real values of the cells. It looks like google have a problem with their API for whatever function you're using to retrieve the spreadsheet (it is not waiting for the retrieval of cell content before passing the answer on to flashcards deluxe), but maybe a workaround could be to just sleep a couple of seconds before actually retrieving the data.
Zed