Technical Support Forum Index
Technical Support Forum
Access ChemAxon scientists and developers here. For registration and login issues contact website support.

Support Ticket System is replacing forum

This forum was converted into a searchable archive. You cannot add posts here any more. For support please use our new Ticket System.

Create your first ticket
#NAME? in Structure
To watch this topic for replies  Register (enables digests) or give email address:
This topic is locked: you cannot edit posts or make replies.
Display posts from previous:   
    View previous topic :: View next topic    
Author Message
jeanne

Joined: 21 Oct 2015
Posts: 2

View user's profile

Back to top
Link to postPosted: Tue Oct 27, 2015 1:33 pmPost subject: #NAME? in Structure Reply with quote

Just did a fresh install of Win 7, Office 2010 and JChem Office in a trial computer.  When I convert a text to structure, I get the #NAME? in all the structure.   I checked and notice there was a JChemExcelFunction in the COM so I removed it.   The attached is what I have for Add ins.  Yet I still see #NAME?  

 

Any idea?  




 Filename: Capture1.JPG    Filesize: 268 KB    Viewed: 24005 Time(s)
 Description:  
Capture1.JPG
Akos
ChemAxon personnel
Joined: 09 Mar 2007
Posts: 864

View user's profile

Back to top
Link to postPosted: Tue Oct 27, 2015 2:56 pmPost subject: Reply with quote

Hi Jeanne,

Having JChemExcelFunctions both as an Excel AddIn and as a COM Addin is OK in most of the cases, but it should not be a problem that you had removed it as a COM Add-in.

On the other hand, I see that the CXNSharedAddin, the JChemExcel Functions (as an Excel add-in) and the Jcfunctions add-ins are not active. For the proper behavior of JChem for Excel and its functions, you should have the following Addins active (after using the first JChem action, e.g. "From 'any' text"):

COM Add-ins:

- CXNSharedAddin

- JChemExcel JChemExcelAddin

Excel Add-ins:

- Jcfunctions

- JChemExcel Functions

Like this:

- To activate the CXNSharedAddin as a COM Add-in:

1. File > Options > Add-Ins > select the COM Add-ins in the manage combo box > Go...

2. Select the checkbox next to CXNSharedAddin > OK

- To activate the JChemExcel Functions as an Excel Add-in:

1. File > Options > Add-Ins > select the Excel Add-ins in the manage combo box > Go...

2a. Select the checkbox next to JChemExcel Functions > OK

2b. If the JChemExcel Functions item does not exists in the list, then click Automation

3b. Select JChemExcel Functions from the list, then click OK

- To activate the Jcfunctions as an Excel Add-in:

1. File > Options > Add-Ins > select the Excel Add-ins in the manage combo box > Go...

2a. Select the checkbox next to Jcfunctions > OK

2b. If the Jcfunctions item does not exists in the list, then click Browse

3b. Browse to C:\Program Files\ChemAxon\JChem for Excel\JCFunctions.xla, select it, then click OK

(3b-b. Browse to C:\Program Files (x86)\ChemAxon\JChem for Excel\JCFunctions.xla, select it, then click OK)

After the above steps please restart Excel.

I hope this will fix all issues you have.

 

Best regards,

Akos

jeanne

Joined: 21 Oct 2015
Posts: 2

View user's profile

Back to top
Link to postPosted: Tue Oct 27, 2015 5:55 pmPost subject: Reply with quote

Thanks!.  It is working now.

mpustelnik

Joined: 02 Jul 2002
Posts: 112

View user's profile

Back to top
Link to postPosted: Tue Nov 24, 2015 6:47 pmPost subject: Reply with quote

The above solution does not solve the problem in Windows 7 Pro, Office 2013 32bit.

Anna
ChemAxon personnel
Joined: 27 Feb 2012
Posts: 116

View user's profile

Back to top
Link to postPosted: Wed Nov 25, 2015 2:45 pmPost subject: Reply with quote

Please, check the following registry settings, if these are set to 3:

-HKEY_LOCAL_MACHINE > Software > Microsoft > Office > Excel > Addins > JChemExcel.JChemExcelAddin > LoadBehavior
-HKEY_LOCAL_MACHINE > Software > Microsoft > Office > Excel > Addins > JChemExcel.Functions > LoadBehavior

-HKEY_CURRENT_USER > Software > Microsoft > Office > Excel > Addins > JChemExcel.JChemExcelAddin > LoadBehavior
-HKEY_CURRENT_USER > Software > Microsoft > Office > Excel > Addins > JChemExcel.Functions > LoadBehavior

Let me know, if you need any assistance in this.

Regards,

Anna

mpustelnik

Joined: 02 Jul 2002
Posts: 112

View user's profile

Back to top
Link to postPosted: Wed Dec 02, 2015 8:42 pmPost subject: Reply with quote

-HKEY_CURRENT_USER > Software > Microsoft > Office >
Excel > Addins > JChemExcel.JChemExcelAddin > LoadBehavior

registry key is missing

mpustelnik

Joined: 02 Jul 2002
Posts: 112

View user's profile

Back to top
Link to postPosted: Wed Dec 02, 2015 8:50 pmPost subject: Reply with quote

Under Excel Add-ins No JChem Add-ins are listed.

Akos
ChemAxon personnel
Joined: 09 Mar 2007
Posts: 864

View user's profile

Back to top
Link to postPosted: Thu Dec 03, 2015 8:51 amPost subject: Reply with quote

Hi Matt,

So you have it under the LOCAL_MACHINE, but not under the CURRENT_USER? Or is it missing from both locations?

Do you have 32-bit or 64-bit Office? If 32-bit, please also check the following folder:

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\Excel\Addins

Thank you!

Akos

This topic is locked: you cannot edit posts or make replies.
Page 1 of 1


To watch this topic for replies   Register (enables digests) or give email address  
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum