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,


Viktor

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