Dear Team,


I have updated the software today after I am getting this error.

When I insert a file and try to retrieve the data from it shows result - not defined.

I am using the syntax for few years and I havent faced this error. Kindly someone help to solve it.

I have attached the working files also.

File not found.File not found.

The error happens because no match is found (result is not defined before the loop in vlookup).

Probably something wrong about encoding in include() due to recent API changes.

You can check it displaying on the canvas the imported data. If it contains a bunch of \xyzk\ stuff, this is the cause (I can't check it directly currently)

Wrote

The error happens because no match is found (result is not defined before the loop in vlookup).

Probably something wrong about encoding in include() due to recent API changes.

You can check it displaying on the canvas the imported data. If it contains a bunch of \xyzk\ stuff, this is the cause (I can't check it directly currently)

Kindly find the below image,

You have to display the data imported by include().

I'm from mobile, so I can actually open the worksheets but I cannot reproduce anything related to plug-ins.

Hi. Issue is because the new ASCII encoding. I say that not because I understand it, but because this workaround solve the problem. But it's that, just a temporal solution. I don't know which could be the best procedure for "know" what are the values in the strings variables, and reproduce it with the keyboard.



Best regards.
Alvaro.

Wrote

You have to display the data imported by include().

I'm from mobile, so I can actually open the worksheets but I cannot reproduce anything related to plug-ins.

Please find the screenshots from two different files.

database sheet


Loading sheet

Wrote

Hi. Issue is because the new ASCII encoding. I say that not because I understand it, but because this workaround solve the problem. But it's that, just a temporal solution. I don't know which could be the best procedure for "know" what are the values in the strings variables, and reproduce it with the keyboard.



Best regards.
Alvaro.

Hi, I did the same, but still I get this error.