result - not defined

result - not defined - I have updated the software today, from then I am getting this error - Сообщения

#1 Опубликовано: 18.05.2021 14:57:04
Giri

Giri

0 сообщений из 4 понравились пользователям.

Группа: 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.

Файл не найден.Файл не найден.
#2 Опубликовано: 18.05.2021 15:13:16
Davide Carpi

Davide Carpi

1417 сообщений из 2873 понравились пользователям.

Группа: 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 Опубликовано: 18.05.2021 15:20:45
Giri

Giri

0 сообщений из 4 понравились пользователям.

Группа: 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 Опубликовано: 18.05.2021 15:36:40
Davide Carpi

Davide Carpi

1417 сообщений из 2873 понравились пользователям.

Группа: 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 Опубликовано: 18.05.2021 16:33:28
Alvaro Diaz Falconi

Alvaro Diaz Falconi

992 сообщений из 1675 понравились пользователям.

Группа: 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 Опубликовано: 19.05.2021 01:57:38
Giri

Giri

0 сообщений из 4 понравились пользователям.

Группа: 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 Опубликовано: 19.05.2021 01:59:54
Giri

Giri

0 сообщений из 4 понравились пользователям.

Группа: 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
  • Новые сообщения Новые сообщения
  • Нет новых сообщений Нет новых сообщений