Customization of the Ribbon

Back to index page

The JChem ribbon is available in case of Microsoft Office Excel 2007.

 

Personal customization of the ribbon

 

Open the JChemExcelRibbon.xml file for edition.

 

Windows Vista: C:\Users\CurrentUser\AppData\Roaming\ChemAxon\JChem for Excel\JChemExcelRibbon.xml

Windows XP: C:\Documents and Settings\CurrentUser\Application Data\ChemAxon\JChem for Excel\JChemExcelRibbon.xml

 

Select some buttons which you want to hide from the ribbon (e.g.: From SMILES and To SMILES buttons) and set their visibility to FALSE.

 

<button image="ConvertFromSmiles.png" onAction="ConvertFromSMILESToStructureAction" id="ConvertFromSMILESToStructureAction" label="From SMILES" getImage="GetImage" screentip="Convert SMILES string to structure." size="normal" visible="false" getEnabled="OnIsEnabled" />

<button image="ConvertToSMILES.png" onAction="ConvertToSMILESAction" id="ConvertToSMILESAction" label="To SMILES" getImage="GetImage" screentip="Convert structure to SMILES string." size="normal" visible="false" getEnabled="OnIsEnabled" />

 

Add some new actions (e.g.: ConvertToIUPACNameAction and ConvertFromIUPACNameToStructureAction) to the ribbon. Add the new actions as new rows to a selected section of the JChemExcelRibbon.xml file.

 

<button image="IUPAC.png" onAction="ConvertToIUPACNameAction" id="ConvertToIUPACNameAction" label="To IUPAC" getImage="GetImage" screentip="Convert structure to IUPAC." size="normal" visible="true" getEnabled="OnIsEnabled" />

<button image="IUPAC.png" onAction="ConvertFromIUPACNameToStructureAction" id="ConvertFromIUPACNameToStructureAction" label="From IUPAC" getImage="GetImage" screentip="Convert IUPAC to structure." size="normal" visible="true" getEnabled="OnIsEnabled" />

 

Save the modified xml file as JChemExcelRibbon_Custom.xml.

 

Windows Vista: C:\Users\CurrentUser\AppData\Roaming\ChemAxon\JChem for Excel\JChemExcelRibbon_Custom.xml

Windows XP: C:\Documents and Settings\CurrentUser\Application Data\ChemAxon\JChem for Excel\JChemExcelRibbon_Custom.xml

 

Paste a IUPAC.png file into the Images folder to provide an icon for the new buttons.

 

Windows Vista: C:\Users\CurrentUser\AppData\Roaming\ChemAxon\JChem for Excel\Images\IUPAC.png

Windows XP: C:\Documents and Settings\CurrentUser\Application Data\ChemAxon\JChem for Excel\Images\IUPAC.png

 

The customized xml file (JChemExcelRibbon_Custom.xml) is loaded automatically instead of the original xml file at starting Microsoft Excel if the customization is correct. The customized JChem for Excel ribbon is displayed in Microsoft Excel. The "To SMILES" and "From SMILES" buttons are hidden from the ribbon but the "To IUPAC" and "From IUPAC" buttons are displayed on the ribbon.

 

 

The original JChemExcelRibbon.xml file is loaded automatically instead of the customized file at starting Microsoft Excel if there is any problem with the customization. Please check the log file for information in this case.

 

Corporate level customization of the ribbon

 

The above described modifications has to done in the original JChemExcelRibbon.xml file and it has to be re-packed in installer.

Back to index page