Status Update
Comments
ca...@gmail.com <ca...@gmail.com> #2
A short description of the issue:
For more than 10 days already people report frequent cases of getting error "Import Range internal error" while using IMPORTRANGE() function where it previously worked fine.
What steps will reproduce the problem?
Not sure how to reproduce. I've seen this behavior within quite heavy spreadsheets as well as within newly created ones containing just a few cells of data.
What is the expected output? What do you see instead? If you see error messages, please provide them.
Data should be imported as usual, but often it is replaced with the error message "Import Range internal error".
Please provide any additional information below.
There is a SO question on the matter:https://stackoverflow.com/q/69593421/279806
Only dirty workarounds are known now.
One would be to change case of any letter in the second argument (range being imported) of IMPORTRANGE().
Another one is to repeat IMPORTRANGE() one original and another with some letter-case changes) in IFERROR() like so:
IFERROR(IMPORTRANGE("id", "A:A"), IMPORTRANGE("id", "A:a"))
For more than 10 days already people report frequent cases of getting error "Import Range internal error" while using IMPORTRANGE() function where it previously worked fine.
What steps will reproduce the problem?
Not sure how to reproduce. I've seen this behavior within quite heavy spreadsheets as well as within newly created ones containing just a few cells of data.
What is the expected output? What do you see instead? If you see error messages, please provide them.
Data should be imported as usual, but often it is replaced with the error message "Import Range internal error".
Please provide any additional information below.
There is a SO question on the matter:
Only dirty workarounds are known now.
One would be to change case of any letter in the second argument (range being imported) of IMPORTRANGE().
Another one is to repeat IMPORTRANGE() one original and another with some letter-case changes) in IFERROR() like so:
IFERROR(IMPORTRANGE("id", "A:A"), IMPORTRANGE("id", "A:a"))
ca...@gmail.com <ca...@gmail.com> #3
Yes, the issue is still going on for me, not fixed.
sp...@gmail.com <sp...@gmail.com> #4
Same here
Please fix its making us all crazy and frustrated
Please fix its making us all crazy and frustrated
ca...@gmail.com <ca...@gmail.com> #6
Yeah.
Now previous thread reopened
"
Andrew Msslow<cannonproject@gmail.com> #69Jan 31, 2022 11:11PM
Look right.
"Status
Fixed"
We need to open other case
Andrew Msslow<cannonproject@gmail.com> #70Jan 31, 2022 11:13PM
https://issuetracker.google.com/issues/217210967
lo...@google.com<lo...@google.com>Feb 1, 2022 11:52AM
Status: Assigned (reopened)"
Now previous thread reopened
"
Andrew Msslow<cannonproject@gmail.com> #69Jan 31, 2022 11:11PM
Look right.
"Status
Fixed"
We need to open other case
Andrew Msslow<cannonproject@gmail.com> #70Jan 31, 2022 11:13PM
lo...@google.com<lo...@google.com>Feb 1, 2022 11:52AM
Status: Assigned (reopened)"
Description