| Product | Version |
| Signals One/Lead Discovery Premium (ChemCharts) | All Versions |
Keywords:
ChemCharts, Spotfire, Signals One, Inventa, ISA, summary table, renderer, column renderer, structure renderer, SMILES, chemical/x-daylight-smiles, content type, auto-detection, Column Properties, Data Canvas, text renderer, renderer reset
Introduction: This article explains why ChemCharts sets a chemical structure renderer on text columns in a Spotfire summary table, and why the renderer comes back each time the query is changed. It also shows how to stop this by removing the column's content type.
Confirmed Behavior:
Why the renderer changes
- When the query changes, the summary table is rebuilt. Some string values in a column can look like SMILES structures, so the column gets flagged as structure data.
- When that happens, the column's content type is set to chemical/x-daylight-smiles automatically, and ChemCharts shows the column with a structure renderer instead of as text.
- Changing the renderer back to text by hand doesn't last. The next time the query changes, the content type is detected again and the structure renderer comes back.
- Exporting the visualization settings doesn't save the renderer choice.
- You can't turn off this automatic SMILES detection.
- Removing the content type from the affected columns fixes the problem. After you remove it, running the query again doesn't reset the renderer.
Example:
A user runs a query in an Inventa analysis that builds a summary table. Several columns hold plain text (strings) but show up with a structure renderer in ChemCharts. The user changes these columns back to text. When the query is changed and run again, the summary table is rebuilt and the same columns switch back to the structure renderer.
Text columns in the summary table are shown with a structure renderer because their content type was set to chemical/x-daylight-smiles automatically.
Before changing the content type
- Remove the content type only from columns that hold text, not real chemical structures. If you remove it from a real structure column, ChemCharts won't draw those structures anymore.
- Changing only the renderer isn't enough. You have to remove the content type for the fix to last after the query runs again.
Process Steps:
- Identify the Affected Columns
- In the summary table, find the text columns that ChemCharts shows with a structure renderer.
- Open the Column Properties
- In Spotfire, go to Data Canvas → select the table → Column Properties → Edit Properties.
- Remove the Content Type
- Select the affected column and open its Content Type.
- Remove the chemical/x-daylight-smiles content type.
- Note: Do this for each affected column.
- Check the Fix
- Change the query and run it again. Check that the columns still show as text and the structure renderer doesn't come back.
- Contact Revvity Signals Support
- If the renderer still resets after you remove the content type, contact Support. Include the analysis name, the names of the affected columns and a sample of the data.
Key Findings:
- Some Text Gets Mistaken for SMILES:
- String values that look like SMILES cause the column's content type to be set to chemical/x-daylight-smiles automatically.
- Changing the Renderer Doesn't Last:
- Changing a column to text by hand is undone when the summary table is rebuilt, and exported visualization settings don't keep the renderer.
- Auto-Detection Can't Be Turned Off:
- There's no setting to turn off SMILES detection.
- Removing the Content Type Fixes It:
- Once the content type is removed, running the query again doesn't reset the column renderer.
Critical Note: Remove the content type in Column Properties to stop the structure renderer coming back. Only changing the renderer is undone each time the summary table is rebuilt. Remove the content type only from columns that don't hold real chemical structures.
Comments
0 comments
Please sign in to leave a comment.