Ian's Excel Add-in Ribbon Menu

#NAME Error when importing a WinQS ASCII file

More
23 Feb 2015 17:02 #1 by Ian
Hi everyone,

I am busy updating my addin and one of the items I want to address is the issue of #NAME cell values when importing a WinQS ASCII file. I have not come across this issue personally, but I do know that it exists, and I need your help in finding out what causes it.

The #NAME error occurs when Excel does not recognise text in formula, so my assumption is that something is causing Excel to view imported text as a formula rather than plain text in that cell.

In order to resolve this issue, I need to know what text Excel is trying to import in that particular cell. You can help by either providing a copy of a TXT file, exported from WinQS, that has this problem, or by letting me know what text is contained in the cell.

Please respond in this thread if you are able to assist.

Thank you,
Ian

Please Log in to join the conversation.

More
24 Feb 2015 07:48 #2 by FanieBruwer
Replied by FanieBruwer on topic #NAME Error when importing a WinQS ASCII file
Hi Ian.

We pick it up in the beginning when you have an item like this in WinQS:
"- Aluminium windows, etc, and set up complete."

The "-" does something like this.

But I have just check, and it is working with it fine.

Maybe just check again.

Please Log in to join the conversation.

More
24 Feb 2015 15:59 #3 by Ian
Thank you Fanie. I'll cook up a few descriptions in WinQS on this basis and see how it goes.

Regards,
Ian

Please Log in to join the conversation.

More
13 Mar 2015 08:07 #4 by FanieBruwer
Replied by FanieBruwer on topic #NAME Error when importing a WinQS ASCII file
Ian

What we pickup yesterday is if you have a long description with comma's inside it, it sometimes push the comma to be first in the next line. And then it stop importing.

Fanie

Please Log in to join the conversation.

More
13 Mar 2015 10:06 #5 by Ian
Hi Fanie,

Does this error still occur with the updated version of the addin released last night?

Regards,
Ian

Please Log in to join the conversation.

More
13 Mar 2015 10:16 #6 by FanieBruwer
Replied by FanieBruwer on topic #NAME Error when importing a WinQS ASCII file
Let me check.

Please Log in to join the conversation.

Powered by Kunena Forum
We use cookies

We use cookies on our website. Some of them are essential for the operation of the site, while others help us to improve this site and the user experience (tracking cookies). You can decide for yourself whether you want to allow cookies or not. Please note that if you reject them, you may not be able to use all the functionalities of the site.