Author Topic: ** Error: "LispFromPtr failed. The type is not supported:" 10 **  (Read 4058 times)

0 Members and 1 Guest are viewing this topic.

Lee Mac

  • Seagull
  • Posts: 12905
  • London, England
I keep getting the above error when trying to read data from an Excel Spreadsheet, but I do not know what is causing the error, as I have run my program on other spreadsheets and all seems fine.

Have any of you experienced this?

Thanks,

Lee

Patrick_35

  • Guest
Re: ** Error: "LispFromPtr failed. The type is not supported:" 10 **
« Reply #1 on: August 24, 2009, 11:01:59 AM »
   
Hi

The simplest is to provide an example.

@+

Lee Mac

  • Seagull
  • Posts: 12905
  • London, England
Re: ** Error: "LispFromPtr failed. The type is not supported:" 10 **
« Reply #2 on: August 24, 2009, 11:24:54 AM »
   
Hi

The simplest is to provide an example.

@+

Thank you for your response Patrick.

I have recently found that this error occurs when reading a cell that contains an invalid formula, and have resolved the issue.

Thanks,

Lee

ahankhah

  • Mosquito
  • Posts: 19
Re: ** Error: "LispFromPtr failed. The type is not supported:" 10 **
« Reply #3 on: April 20, 2021, 09:35:38 AM »
Hi Lee, Just now (12 years after you sent this post  :2funny:) I found that this error occures when an "Excel" cell is containing a numeric value with a "point" as "period".

AFAIK it is not Excel related problem. It is due to "Windows" settings when "/" is assigned to "Decimal Symbol".

Enclosed Clip shows how I got rid of the error. But I don't know why this incompatibility occures. When using "/" to write a decimal number like1.5 obviously it must be typed as: 1/5, but surprisingly Excel changes that to 0/2 (It divides 1 to 5).

I am sure you can write a Visual LISP code to solve this problem automatically.