JChem for Excel Error

User b8f31290e7

05-04-2013 15:28:37

We are getting an error when trying to add structures to a spreadsheet using JChem for Excel 5.10.  See the attachment for the error.  We are using Windows XP.  Clicking Details gives this:

Exception: System.Runtime.InteropServices.COMException

Message: Error HRESULT E_FAIL has been returned from a call to a COM component.

StackTrace:    at ChemAxon.JChemExcel.COMShim.ExcelUtilCallbackClass.AddHiddenWorksheet(String WorkbookName, String name)

   at ChemAxon.JChemExcel.Excel.BaseExcelApplicationAdapter.†††

††††‡›(Object , Object , Object )

   at ChemAxon.JChemExcel.Excel.BaseExcelApplicationAdapter.AddHiddenWorksheet(String workbookName, String name)

   at ChemAxon.JChemExcel.Base.StructureSheet.WorkbookStructureSheet.†††

†††Š“(Object , Object , Object )

   at ChemAxon.JChemExcel.Base.StructureSheet.WorkbookStructureSheet.AddStructureSheetIfNotExists(String workbookName)

   at ChemAxon.JChemExcel.Base.StructureSheet.WorkbookStructureSheet.PrepareWorkbookForStructureStorage(String workbookName, String wbGuid)

   at ChemAxon.JChemExcel.Base.StructureSheet.ApplicationStructureSheetStorage.†††

†††Š‘–(Object , Object , Object )

   at ChemAxon.JChemExcel.Base.StructureSheet.ApplicationStructureSheetStorage.PrepareStructureSheet(String workbookName, String wbGuid)

   at ChemAxon.JChemExcel.Base.StructureSheet.ApplicationStructureSheetStorage.AddStructures(String workbookName, Structure[] structures)

   at ChemAxon.JChemExcel.Base.StructureSheet.ApplicationStructureSheetStorage.AddStructure(String workbookName, Structure structure)

   at ChemAxon.JChemExcel.Base.StructureSheet.StructureSheetStrategy.†††

†††ŠŒ(Object , Object , Object )

   at ChemAxon.JChemExcel.Base.StructureSheet.StructureSheetStrategy.MapStructure(Structure structure, String workbookName)

   at ChemAxon.JChemExcel.Base.ExcelMapper.DrawingExcelMapper.†††

†††‡‰š(Object , Object , Object )

   at ChemAxon.JChemExcel.Base.ExcelMapper.DrawingExcelMapper.MapSingleStructureWithUndo(Structure structure, WorkbookRangeIndex workbookRangeIndex)

ChemAxon bd13b5bd77

05-04-2013 17:43:12

Do you have ChemDraw for Excel addin enabled?

If so please disable it.

5.10 of JChem for Excel is pretty old, coudl you please upgrade?

Thank you,


User b8f31290e7

05-04-2013 18:12:02

Thanks, Viktor.  That worked.  We are in the process of upgrading to 5.12.  It takes us a while to do an upgrade so we cannot upgrade everytime a new version comes out.

ChemAxon bd13b5bd77

05-04-2013 18:37:37

Yes, understood. We are sorry for the frequent releases.

However 3-4 months major releases can be good for the customers if they want to get the features, fixes quickly.

User 4502d3c652

22-08-2013 08:55:57

great if this is done