ChemAxon 0e37943a96
02-03-2009 16:09:36
General
Issue: Cross sheet or workbook references do not work by mouse because of drawing mode.
Operating System: All
Office: All
Workaround: The cross sheet or workbook references has to be entered manually or switch on the Structure Drawing Behaviour for Excel Dialogs to true to do it automatically.
Structure Rendering
Issue: Structures are not positioned correctly in Page Layout view
Operating System: All
Office: Office 2007
Steps to reproduce:
1. Import structures with their properties from a file to the A column of an empty worksheet.
2. Change to Page Layout view.
3. It causes problem in placement of the structures.
Workaround: No workaround.
Issue: Structures are drawn over graphical objects (Shapes, Charts..)
Operating System: All
Office: All
Steps to reproduce:
1. Import structures from a file.
2. Create a chart or add a comment (comments needs to be shown continuously).
3. Move the comment or the chart over the structure cells.
4. Structures can be seen on the chart or comment object.
Workaround: No workaround.
Issue: Ball and Stick and Spacefill crops the sides of certain structures
Operating System: All
Office: All
Workaround: No workaround.
Issue: Excel sheet as OLE object pasted into Microsoft Word will not show structure
Operating System: All
Office: All
Steps to reproduce:
1. Add structures to cells
2. Select them and copy
3. Paste them as Excel Sheet Object (Paste Special)
4. Embedded Excel object will be shown without structure if it is launched by double-click
Workaround: Please try to use Marvin OLE as live objects in Word or convert structures to images and afterwards you can copy the whole sheet as OLE object.
Import from Database
Issue: It causes error when the user attempts to execute a query in case of a TNS type connection with “JChem Base” search method.
Operating System: All
Office: All
Steps to reproduce:
1. Specify a TNS type connection for an indexed table.
2. Select the new TNS type connection, select the table and some fields and specify search options.
3. Select the “JChem Base” search method in the property grid.
4. Click on the Search button to execute the search. Exception occurs.
Workaround: Change the connection type to Basic..
Open Workspace
Issue: Opening a saved workspace will not switch on the structure rendering
Operating System: All
Office: All
Steps to reproduce:
1. Start Microsoft Excel
2. Import structures from the Wombat.sdf file to the Sheet1 of the Book1
3. Open a new blank workbook - Book2
4. Import structures from the ShortSDF.sdf file to the Sheet1 of the Book2
5. Save the layout (the two opened workbooks with structures) as a workspace
6. Close Microsoft Excel - both the Book1 and Book2
7. Open the saved workspace by double-clicking on its icon
8. Check if the structures can be seen in both workbooks.
>> The structures become unvisible after scrolling in the opened workspace.
Workaround: No workaround.
Image/OLE Shape conversion back
Issue: The image/OLE shapes cannot be converted back to structures if autofiltering is enabled in case of Excel 2003
Operating System: All
Office: 2003
Steps to reproduce:
1. Start Microsoft Excel
2. Import the structures with adjacent data from the ??.sdf file to the Sheet1
3. Select the Structure and another non-structure columns (column A and B)
4. Turn on the autofiltering on the selected columns (Data|Filter)
5. Select the structure column and convert the structures to image shapes by using the ""Convert structure to Excel image shape) function.
6. Select the structure column again and convert the image shapes back to structures
7. Apply data filtering on the non-structure column to filter out some rows (e.g. filter out the rows where the non-structure value is specific to xx..)
8. Select the structure column again and convert the structures to image shapes
9. Select the structure column again and convert the image shapes back to structures.
>> Current result: Error message is displayed as “Could not convert structure images to chemical structure” when converting the image shapes back to structures in Excel 2003
Workaround: Microsoft handled the issue in Office 2007.
Copy ID or Structure aggregated fields between instances
Issue: Copy ID and structure aggregated field to another instance when the id isa calculated (name or smiles)
Operating System: All
Office: All
Steps to reproduce:
1. Start Microsoft Excel
2. Import structures with IDs but IDs should be calculated ids rather than corporated Ids like smiles, or IUPAC name
3. Start a new Microsoft Excel
4. Open a new blank workbook - Book2 in the Excel instance
5. In the case of some ID or structure fields the IDs have to be shown
6. Copy 'ID or structure' aggregated fields where they are shown as IDs now (not structures)
7. The structures will not be displayed
Workaround:
1. The functionality will be working for non autocalculated IDs
2. If in the fields (autocalculated Ids specified) the structures are shown the functionality works fine
3. Instance-Instance copy can be avoided with using workbooks in the same Excel instance
Structure conversion
Issue: Maximum 4000 structures can be converted to Excel image shapes by using the "Convert Structure to Excel Image Shape" and "Save to Share" functions due to upper limit of GDI handles that can be opened per session.
https://msdn.microsoft.com/en-us/library/windows/desktop/ms724291(v=vs.85).aspx
Operating System: All
Office: All
Steps to reproduce:
1. Start Microsoft Excel
2. Import 5000 or more structures from an SD file onto an empty worksheet
3. Save the workbook with structures and keep it opened
4. Select all structures and press the "To Image" ribbon button OR press the "Save to Share" ribbon button
>> The JChem for Excel starts to convert structures to Excel image shapes but the number of opened GDI objects reaches the upper limit and Excel hangs on.
Unsorted
Issue: Warning on workbook open: 'This workbook contains links to other data sources'.
The formula bar display formulas like this:
='C:\Program Files (x86)\ChemAxon\JChem for Excel\JCFunctions.xla'!JCIUPACName(A1)
Operating System: All
Office: All
Resolution:
1. Choose 'Update', you can click on 'Edit Links...' button.
2. The JCfunction.xla is selected, and its status is 'Error: Source
not found'.
3. Click 'Change Source...'.
4. Now, locate the JCFunctions.xla in the folder where JChemExcel
installed.
5. Click 'Open'.
6. Close this dialog.
Formulas should be resolved now.
Issue: Excel crashes when the workbook is closed.
Operating System: All x64
Office: Excel 2010 x64
Resolution:
1. Open Control Panel, System and Security, Windows Update.
If updates for Microsoft Office hasn't been turned on yet:
1.a Beside 'Get updates for other Microsoft products', Click 'Find out more'.
1.b A browser window opens: 'Get updates for Windows, Office and more'.
1.c Follow the steps (Agree, 'Use recommended settings', Install,...)
1.d Back on the Windows Update window, after a while ('Checking for updates...'), updates for installed Office products should show up in the updates list.
2. Select Office 2010 SP2 update, and all other Office related security, etc. updates and install them.
