result - not defined

result - not defined - I have updated the software today, from then I am getting this error - Messaggi

#1 Pubblicato: 18/05/2021 14:57:04
Giri

Giri

0 apprezzamenti in 4 post.

Gruppo: User

Dear Team,
Error.png

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 non trovato.File non trovato.
#2 Pubblicato: 18/05/2021 15:13:16
Davide Carpi

Davide Carpi

1.443 apprezzamenti in 2.936 post.

Gruppo: Moderator

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)
If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects
#3 Pubblicato: 18/05/2021 15:20:45
Giri

Giri

0 apprezzamenti in 4 post.

Gruppo: User

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,
Error With Explanation.png
#4 Pubblicato: 18/05/2021 15:36:40
Davide Carpi

Davide Carpi

1.443 apprezzamenti in 2.936 post.

Gruppo: Moderator

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.
If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects
#5 Pubblicato: 18/05/2021 16:33:28
Alvaro

Alvaro

1.139 apprezzamenti in 1.805 post.

Gruppo: User

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.

Clipboard01.jpg

Best regards.
Alvaro.
#6 Pubblicato: 19/05/2021 01:57:38
Giri

Giri

0 apprezzamenti in 4 post.

Gruppo: User

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
database sheet.png

Loading sheet
Loading Sheet.png
#7 Pubblicato: 19/05/2021 01:59:54
Giri

Giri

0 apprezzamenti in 4 post.

Gruppo: User

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.

Clipboard01.jpg

Best regards.
Alvaro.



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

Error_2.png
  • Nuovi post
  • Nessun nuovo post