Hello,
I created a spreadsheet A via the Drive API in Java. Inside, I have a cell
with this:
=importRange("KEY_SHEET_C", "Sheet1!A1:A2")
The cell says #ERROR (error: parse error).
The Sheet C is shared "Anyone who has the link can edit"
Then, I created a spreadsheet B manually and then copy paste the same
formula above and it worked !
I then modify the sheet A adding an HYPERLINK function, or IFERROR, or
HLOOKUP it doesn't work. But the AVERAGE or SUM works...
Please look by yourself here:
- *Sheet A (created via the API - import range doesn't work)* :
https://docs.google.com/spreadsheet/ccc?key=0Ajpu6yLD6f3udFNBVkNoWGZaYUIxQi1wTnB2c3pUM0E&usp=drive_web#gid=0
- *Sheet B (created manually - It works !)* :
https://docs.google.com/spreadsheets/d/1pD46MUcRo9AqCdxsJ-MisGkiLXFKcs5V50NlmukOtYA/edit#gid=0
- *Sheet C (the Data we pull) *:
https://docs.google.com/spreadsheets/d/18FSDU8i9w1P-8DaKBIV8YAd1OJT6CG7mFLqeIayUc9s/edit#gid=0
Anyone has an idea on this ?
Thank you
--
You received this message because you are subscribed to the Google Groups
"Google Spreadsheets API" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
