JChem for Office 15.1.1900 has been released

Marvin/JChem 15.1.19 used.

Improvements

The Stereochemistry option in the Basic Search Options on the
Filtering dialog is changed from True/False values to
Stereospecific/Exact/Ignore/Diastereomer/Enantiomer values to better
reflect the options available in JChemBase. At the same time, the Exact
Stereo Matching option has been removed from the Chemistry Search
Options, because it is not needed anymore; the Stereochemistry=Exact
option has to be used instead (e.g. in case of Duplicate search).

Bug Fixes

Characters that were available on a specific language keyboard only
by combination with the AltGr key (e.g. backslash on the German or
Hungarian keyboard) could not be typed in dialogs opened from
MarvinSketch.NET (the default editor in JChem for Office).

JChem for Office 15.1.2600 has been released

Marvin/JChem 15.1.26 used.

Improvements

The Stereochemistry option on the Filter and Import from Database
dialogs is changed automatically to "Exact" if the Search Type is set to
"Duplicate", and to "Stereospecific" in any other Search Type (but can
be changed manually to any other option).

Bug Fixes

If an Excel sheet had no header row, the structure in the first row was not exported.

JChem for Office 15.2.900 has been released

New feature

Marvin OLE objects in Word/PowerPoint/Outlook documents can be set
to be replaced with a normal JChem for Office object upon editing (by
double-click or using the Edit button).

Improvements

The Fixed Scale parameter in the JChem for PowerPoint and Word
Structure Display options (Preferences - Display) now overwrites the
picture size settings, so if it is set to different from 0, a single
structure will be created according to that (even in case of editing),
ensuring that the bond length will be the same in all parts of the
document. In addition, the aspect ratio of the image is the same as of
the structure.

The default setting in JChem for PowerPoint/Word/Outlook is now changed to have no border when adding a new structure.

Bug Fixes

Importing from databases by ID did not import the structures if in a
previous import process from the same table a non-structure field was
set to be used as structure.

If an excel sheet had only one column, containing structures
defined by the JCIDSYSStructure formula (including ID info as well), the
'Structures only' checkbox was selected automatically, and it was not
possible to unselect, so there was no way to set the ID info to be
exported.

JChem for Office 15.2.2300 has been released

Marvin/JChem 15.2.23 used.

Improvements

The Clear Structure Filter action has been significantly sped up.

The pictures created from structures in Excel (e.g. by To Image or
Save To Share) are linked to the excel cells using the ""Move and Size
with cells"" option from now on (this option was "Move but don't size
with cells" before), which caused issues in case of excel data
filtering.

Deprecated option

The Copy Rows option has been removed from the Filter Actions,
since the Clone Rows functionality completely covers the related use
case.

Bug Fixes

Hit count information was not removed when pressing Clear Filter or when starting a new filtering process.

The characters at the end of longer descriptions on the JChem for Office Options dialog were sometimes compressed.

JChem for Office 15.3.900 has been released

Marvin/JChem 15.3.9 used.

Improvements

The size of edited Marvin OLE objects has been reduced to less than half.

Bug Fixes

Structure filtering did not work on excel files containing JC
STRUCTURE functions including a different argument separator than that
of the current regional setting. E.g., structure filtering failed on a
computer having English regional settings if the JCIDSYSSTRUCTURE
functions used in the file were created on a Hungarian computer (and
therefore included semicolon separators instead of commas).

JChem for Office 15.3.3000 has been released

New features

The SAR table generation can be run on Markush structures
containing more than 2 R-groups; the R-group pair used in the SAR table
is selected from dropdown lists during the process.

Improvements

Structure filtering speed has been improved significantly: about 5
time faster in case of the first filtering action in an open Excel
workbook, and about 10 times faster at any further filtering on the same
open workbook (regardless the query structure).

Bug Fixes

The query structure was not retained when initiating a filter
action after opening a JChem for Excel file that was saved with a
filtered sheet.

JChem for Office 15.6.1500 has been released

Improvements

All errors detected during a file import in Excel are now collected
at the end of the import process, and the error report is now
selectable and can be copied to the clipboard.

Structure filtering failed in Excel when one structure contained
features that could not be handled by the JChem substructure search
(e.g. a Markush structure with polymer features). Now the filtering
skips these structures, hides them together with the non-hit structures,
the hit count is properly displayed at the status bar, and the
problematic structures are reported in an error message at the end of
the filtering process.

Bug Fixes

Copying a SMILES from Word and pasting it into the canvas of a
MarvinSketch.NET window opened from Excel/PowerPoint crashed
Excel/PowerPoint.

It was not possible to run License Manager in
Word/Outlook/PowerPoint, and if it was the first action in Excel, the
loading of the License Manager crashed Excel.

If additional text was selected together with a single structure
object in Word, Ctrl+C recognized it as a single JChem for Office
object, and therefore Ctrl+V pasted only the structure (the extra text
was lost).

JChem for Office 15.6.2200 has been released

JChem for Office 15.6.2900 has been released

Marvin/JChem 15.6.29 used.

New features

JChem Web Services can be used in Import from Database.

Postgre SQL databases are supported in Import from Database.

Improvements

If an Oracle Cartridge view contains cd_structure, structure,
cd_smiles or smiles column, it is selected automatically (in the above
order) as target column for structure search on the Query tab and as
structure column on the Columns tab.

Bug Fixes

Database import didn't work on Oracle (non cartridge) Views unless
the Search option was set to "No Structure Search" on the query tab. Now
the structure search is automatically disabled on non-cartridge Oracle
Views.

The Import from Database process displayed "Fetching.." on the Rows
tab even if there was nothing to import (e.g. there was no any hit
resulted by the query). Now it properly displays if there is no result.

JChem for Office 15.7.1300 has been released

Marvin/JChem 15.7.13 used.

Bug Fixes

MarvinSketch.NET did not put the structure format titles to the
clipboard during Copy and Copy As, therefore JChem for Office could not
automatically recognize it and convert it to structure object during
Paste.

JChem for Office 15.8.300 has been released

Marvin/JChem 15.8.3 used.

New features

One-click "Scale" action has been introduced in Word/PowerPoint/Outlook as a new ribbon button functionality, which reflects the Fixed Scale settings specified in Options. The action works on a selected single structure.

One-click "Display" action has been introduced in Word/PowerPoint/Outlook as a new ribbon button functionality, which reflects the Structure Display settings specified in Options. The action works on a selected single structure.

One-click solution is introduced for combined "Display and Scale" ribbon functionality in Word/PowerPoint/Outlook, which reflects both changes at the same time, working the same way on a single selected structure.

Improvements

The molecule object in a Word/PowerPoint/Outlook document keeps the structure display settings after modifying the structure in MSketch.

When editing a structure object in Excel/Word/PowerPoint/Outlook the structure is displayed with the same display settings in MSketch as it is displayed in MS Office.

JChem for Office 15.8.1700 has been released

Marvin/JChem 15.8.17 used.

Improvements

The JChem for Office object in Word/PowerPoint/Outlook keeps the
image size or scale after editing the structure: If the FixedScale
parameter is different from 0, then the scale is kept, otherwise the
image size.

Import from File/DB results in a single table in Word/Outlook by
default, with repeating the first row of the table as header at each
page in Word.

Bug Fixes

Rendering of structures in Excel slowed down in version 15.6.8, but has been sped up again.

If there was no JChem for Office action initiated during an MS Word session, the closing of MS Word took too much time.

JChem for Office 15.9.2100 has been released

Marvin/JChem 15.9.21 used.

New features

The scale of the pasted structure in Word/PowerPoint/Outlook will
now reflect the zoom factor used in MarvinSketch during the Copy action.

Improvements

The Structure Display settings stored in the Word/PPT/Outlook/Excel
Options is passed to MarvinSketch when adding a new molecule (so the
structure looks the same during the creation as it will be displayed
after drawing it).

JChem for Office 15.10.1200 has been released

Marvin/JChem 15.10.12 used.

Improvements

The Implicit Hydrogen and the R/S Stereo Labels display options are
now loaded into MarvinSketch both from the structure objects (in case
of Editing a structure in Word/PowerPoint/Outlook) and from the local
JChem options (when Adding a new structure in
Excel/Word/PowerPoint/Outlook).

Closing a MarvinSketch window opened by any of the actions of JChem
for Office (e.g. Add, Edit, Filter, etc.) will not update the
marvin.properties files anymore, so changing the Display Settings in a
such a MarvinSketch window will not affect the desktop MarvinSketch or
other MarvinSketch windows in 3rd party applications.

Bug Fixes

If a structure was selected at the time of pasting another
structure in Word, PowerPoint, or Outlook copied from another
application (e.g. MarvinSketch or Excel), the original structure was
deleted.

If a structure object was resized in PowerPoint by selecting only
the internal image, after editing the structure it was resized to its
original size or scale.

It was not possible to insert a structure into a Word table using the Add feature.

Trying to apply the Display and/or Scale settings on an image
(containing no structure info) copied from Windows Explorer to
PowerPoint displayed an incorrect warning message.

The Import IJC function in PowerPoint imported only the first 10 structures.

JChem for Office 15.10.2600 has been released

Marvin/JChem 15.10.26 used.

Improvements

Import from File by ID can handle duplications, so it returns the data for all instances of an ID in an Excel column.

The current sheet is set to be the default for Import from File
even if there is data on that sheet, positioning the import to start at
the first empty line. Another sheet or a new sheet can still be selected
during the import of course.

Bug Fixes

When only the CD_ID and CD_STRUCTURE columns were selected during
an import from an Oracle DB using JChem Cartridge search, then nothing
was imported.

Designed for SMEs ChemAxon’s MiniReg offers a straightforward solution to create and explore chemical databases containing biochemical assay results. Embedded in our Instant JChem it provides versatile solutions for chemical informatics related tasks such as substructure, similarity and complex query building, property calculations and basic mathematical functions. The clean custom interface that can be designed within the form view builder, provides improved user experience and a clearer way of data representation.

In order to make the transition from a cheminformatics platform to more general office tasks we are introducing you the revitalised JChem for Office application. Extending spreadsheets, documents and powerpoint presentations with chemical intelligence contributes to solving regular work-flows with higher efficiency and precision within the MS Office environment.

The goal of the webinar is to propose light-weight and end-to-end solutions from registration through analysis and reporting.

JChem for Office 15.11.1600 has been released

Bug Fixes

Double-click on a structure object in Word did not open the structure editor in German language installation of MS Office.

Using the Apply Scale function or editing an object without
structural change in PowerPoint doubled the size of the structure object
if the Fixed Scale parameter was set to zero in the options.

Using the Apply Scale function in PowerPoint on a structure
copy/pasted from Excel drastically increased the size of the image
border if the FixedScale parameter was set to greater than zero in the
options.

In versions higher then 15.10.12 it was not possible to edit the
structures in tables copy/pasted from Excel to PowerPoint/Word/Outlook.

Structures defined by JCStructure functions referring to other cells remained as image above the cell after printing.

Using the "Create No Structure" option during SD file export saved the header row as the first record.

JChem for Office 15.11.3000 has been released

Marvin/JChem 15.11.30 used.

New feature

The name import web service specified in the marvin.properties file
(e.g. by entering its URL on the Save/Load tab of the Preferences
dialog opened from a standalone MarvinSketch window) is loaded into
JChem for Excel/Word/PowerPoint/Outlook as well, so e.g. IDs recognized
by that service can be converted to structure using the From Text button
on the JChem ribbon.

JChem for Office 16.1.1800 has been released

Marvin/JChem 16.1.18 used.

Bug Fixes

The bracket character caused error when it was used in adding
JCFunctions to an Excel cell from a user defined macro code (e.g. when
trying to set a SMILES containing bracket in the argument of the
JCStructure function).

JChem for Office 16.2.2900 has been released

Marvin/JChem 16.2.29 used.

Improvements

Database and table names are readable in full length by mouse hover over on the Import by ID from Database dialog.

Bug Fixes

The cd_structure column had been automatically added to the columns
during Import from DB using Web Service, even if the selected table was
a non-jchem table, and if it was selected, it resulted in a null
pointer exception.

When a field having null value was selected among the other fields
during Import from Database through Web Service, the values slipped.

Clicking on the Operator field on the Query tab of the Import from
Database dialog automatically selected '=', but that disappeared when
the Value was entered.

Using special operators, like 'Starts with' or 'End with', on the Query tab of the Database Import caused an error.

Technical columns of jchem tables (like fingerprint, timestap, etc.) were not hidden during Import from Database.

JChem for Office 16.3.1400 has been released

New feature

Synonyms are listed among the tables and views on Import from DB by
ID form (if the appropriate JChem for Excel option is active).

Improvements

The single structure objects in Word and Outlook are not included in a 1x1 table anymore.

Windows 10 with the 32-bit version of MS Office 2010, 2013 and 2016 is now fully supported.

The 32-bit version of MS Office 2016 on Windows7, Windows 8.1 and Windows 10 is now fully supported.

The Actions > Convert To Structure > Placement > Insert
Right option now affects the Import by ID process as well. (Until now it
affected only the convert From SMILES, From 'any' Text and the
Associate ID processes.)

The table and view names are now sorted on the Import by ID from Database dialog.

The status of the "Selection only" checkbox on the Import by ID
dialog can now be controlled using the Options > Convert To Structure
By Key From Database > Conversions > Convert Selection Only
option. (The default value is still False.)

Bug Fixes

Table drop-down list was not refreshed on the Import from Database by IDs form at changing database.

Cancel button crashed the Import process if there were too many
structures listed in the data grid (on the "Rows" window of the import
wizard).

If a CLOB field contained a leading empty line (like sometimes in
case of a MOLFile), and this field was not automatically recognized as
Structure filed based on the fieldname, then the leading empty line was
removed during the Database Import into Excel, and it could not be
converted to structure after.

JChem for Office 16.3.2100 has been released

Marvin/JChem 16.3.21 used.

Improvements

During import into JChem for Excel now all records are selected on
the Rows tab by default. During import into JChem for
Word/Outlook/PowerPoint the first N number of rows are selected, where N
is the number of Maximum Rows set in the Data Mapping Limitations
option.

Bug Fixes

Date type columns imported through JChem Webservice from an
Oracle database was incorrectly formatted (including the timestamp info)
even if the "Treat Date and Currency as Text" option was set to True.

JChem for Office 16.3.2800 has been released

Marvin/JChem 16.3.28 used.

Improvements

The Import by ID from Database process now supports importing
multiple rows for the same ID: it inserts the extra lines into the
worksheet below each ID that has multiple rows in the Database table or
view.

Bug Fixes

CAS Numbers that could be understood as date were imported into Excel as date during the Import by ID processes.

JChem for Office 16.4.1100 has been released

Marvin/JChem 16.4.11 used.

New features

Import by ID from Database now supports Oracle Other user objects.

If there is no structure type content on the clipboard, but there
is a text that can be recognized as MOL or MRV, it will be automatically
converted to Structure in JChem for PowerPoint, Word, Outlook and Excel
(although in the latter case only if the addin is already loaded). This
feature enables the copy/paste from Marvin JS to JChem for Office using
Ctrl+C/Ctrl+V.

Improvements

The Import by ID from Database dialog has been redesigned, and the
tree-based object selector used in the normal DB import process has been
implemented, so it supports displaying only the favorites.

The following field names are added to the already existing
automatically recognized Structure fields during Import from Database
(in this order): MOLECULE, MOL_STRUCTURE, MOLFILE, MOL_FILE, MOLCOLUMN,
MOL_COLUMN, REACTION, RXNFILE, RXN_FILE.

Bug Fixes

If a structure containing an ID was added to a Word document, and
then another structure with ID was added to the same document after
inserting 1-2- empty lines, the ID of the second structure was placed
above the structure.

If an Excel sheet containing structures was converted to protected sheet, the structures were not displayed on that sheet after.

JChem for Office 16.6.2000 has been released

Marvin/JChem 16.6.20 used.

Deprecated feature

Similarity search option was removed from the Filter dialog and the
Rows tab of the Import from Database and the Import from File dialogs.
It is still available on the Query tab of the Import from Database
dialog though.

Improvements

It is now possible to run consecutive filters even on columns that
contain a structure function that refers to the content of another cell
(like JCStructure).

Bug Fixes

There was an error at importing from database by IDs if the worksheet contained an ID with invalid type.

If the Structure Detection Type option was set to No Detect, then
selecting a non-structure column as target on the Filter dialog resulted
in the removal of all rows after the filter.

The selected target column was not retained on the Filter dialog after reopening it.

We plan to remove the option from JChem for Office that enables to insert the chemical structures as OLE objects (instead of the default JChem for Office objects) into documents, and keep them in OLE during the editing. Using OLE objects will still be possible when JChem for Office is not installed.

JChem for Office 16.11.2800 has been released

JChem for Office 16.12.500 has been released

Marvin/JChem 16.12.5 used.

Bug Fixes

The Integrated Authentication check-box remained selected and username/password fields remained disabled on the Manage Connections form at changing to another database type from Oracle where the Integrated Authentication is not supported.

The Import from Database form had to be closed and reopened to apply modifications of an existing connection.

There was an error at Import from Database by IDs function if a data was stored in NUMBER(12) format in Oracle database table.

JChem for Office 17.2.2000 has been released

To watch this topic for replies
Register (enables digests) or give email address

Jump to:

You cannot post new topics in this forumYou cannot reply to topics in this forumYou cannot edit your posts in this forumYou cannot delete your posts in this forumYou cannot vote in polls in this forumYou cannot attach files in this forumYou can download files in this forum