with one click
create-cell-renderer
Create a custom grid cell renderer for Datagrok
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Menu
Create a custom grid cell renderer for Datagrok
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Based on SOC occupation classification
Use whenever you need the Datagrok browser to actually execute JavaScript — adding viewers, filtering, modifying the view, or returning a result widget to the chat. Open this skill before calling the datagrok_exec tool.
Filter rows of a Datagrok DataFrame inside a datagrok-exec block through the Filters panel — by range, equals/contains/in-set, multi-value, boolean, free-text row expressions, or substructure (SMILES / SMARTS / molblock). Also covers clearing, inverting, the show-only-filtered vs destructive-drop split, and the filter event lifecycle (onRowsFiltering / onFilterChanged / onRowsFiltered). Use whenever the user says "filter", "show only", "hide rows where", "narrow to subset", "find rows that", "contains", "substructure search", "categorical filter", "range filter", "invert", "clear the filter", "clear filters", "drop rows", or asks for the filtered subset as a new table. Does NOT cover selection (separate skill) or generic DataFrame cloning (datagrok-df-and-columns).
Add a calculated, formula-based column to a dataframe inside a datagrok-exec block. Use whenever the user asks to compute, derive, add, or create a new column from existing columns — LipE, ratios, log/round, heavy atom count, any expression in the Datagrok formula DSL. Replaces hand-written addNewFloat/addNewInt + for-loop with a single formula-attached column that recomputes when source columns change.
Find, describe, add, remove, rename, clone, or set metadata on columns of a Datagrok DataFrame inside a datagrok-exec block. Use whenever the user asks to locate "the X column", summarize a column, add a typed/empty/values-filled/virtual column, set semantic type / units / format / friendly name, apply linear or categorical or conditional color coding, drop or rename columns, or copy a DataFrame. Covers everything in DataFrame.columns and Column.meta — but not row filtering/selection (datagrok-filtering, datagrok-selection) and not formula-only columns (datagrok-calc-column).
Sort, hide, show, reorder, resize, pin, format, and color-code columns in a Datagrok TableView grid from a datagrok-exec block. Use whenever the user asks to sort by a column (any direction), multi-sort, hide / show / reorder / pin / resize columns, freeze the first N columns, change number-format display, color-code cells (defaults and grid-only tint here; full per-type reference in datagrok-df-and-columns), set row height, or reset the grid back to defaults. Distinct from datagrok-df-and-columns (which owns column-level data metadata like semType, units, friendlyName, and is also where canonical color-coding lives) and from datagrok-viewers (which owns scatter plot / histogram / etc.). Does NOT cover filtering (`datagrok-filtering`), selection (`datagrok-selection`), custom cell renderer authoring (`create-cell-renderer`), saving / restoring layouts, or grid event handlers.
Add a viewer, configure a viewer, change viewer options, find viewer, close viewer, view a scatter plot, bar chart, histogram, line chart, box plot, pie chart, heat map, correlation plot, 3D scatter, trellis, density plot, statistics, on a Datagrok TableView inside a datagrok-exec block. Use whenever the user asks to plot, chart, visualize, show a graph, draw a distribution, color by a column, swap a viewer's axis, toggle a legend / regression line / log scale, replace one viewer with another, close every chart, reset the view to just the grid, or find an existing viewer by type. Plugin viewers like "Chem space", "sequence space", "activity cliffs" are NOT viewer types — they're registered functions — route those to `grok.functions.call`. Does NOT cover filtering (separate skill `datagrok-filtering`), selection (`datagrok-selection`), grid cell rendering (`datagrok-grid-customization`), layout save/restore, or custom-viewer authoring.
| name | create-cell-renderer |
| description | Create a custom grid cell renderer for Datagrok |
| when-to-use | When user asks to create a cell renderer, custom grid rendering, or column visualization |
| effort | medium |
| argument-hint | [cell-type] [package-path] |
Create a custom cell renderer for the Datagrok grid/table viewer.
/create-cell-renderer [cell-type] [package-path]
When this skill is invoked, help the user create a custom cell renderer that extends DG.GridCellRenderer.
Create a new TypeScript file in the package's src/ directory (e.g., src/renderers/my-renderer.ts).
The class must extend DG.GridCellRenderer and implement:
get name() - unique renderer nameget cellType() - the cell type string (e.g., 'piechart', 'barchart')render(g, x, y, w, h, gridCell, cellStyle) - main drawing method using CanvasRenderingContext2DrenderSettings(gridColumn) (optional) - returns an HTMLElement for renderer settings UIexport class MyRenderer extends DG.GridCellRenderer {
get name() { return 'My Renderer'; }
get cellType() { return 'mytype'; }
render(g: CanvasRenderingContext2D, x: number, y: number, w: number, h: number,
gridCell: DG.GridCell, cellStyle: DG.GridCellStyle): void {
// Draw using Canvas 2D API within the bounds (x, y, w, h)
}
renderSettings(gridColumn: DG.GridColumn): HTMLElement | null {
// Optional: return UI element for settings
return null;
}
}
Use the decorator approach (preferred for datagrok-tools >= 4.12.x):
@grok.decorators.cellRenderer({
cellType: 'mytype',
virtual: true,
})
export class MyRenderer extends DG.GridCellRenderer {
/* ... */
}
The virtual: true flag is used for summary/calculated columns.
Or use the function annotation approach in package.ts:
//name: myRenderer
//tags: cellRenderer
//meta.cellType: mytype
//meta.virtual: true
//output: grid_cell_renderer result
export function myRendererFunc() {
return new MyRenderer();
}
The decorator approach auto-generates a package.g.ts file via FuncGeneratorPlugin during build. This file must be committed.
npm run build
grok publish
cellType string links the renderer to summary columns of that typerender method receives a Canvas 2D context; draw within the bounding box (x, y, w, h)public/packages/PowerGrid/src/sparklines/import * as DG from 'datagrok-api/dg', import * as grok from 'datagrok-api/grok')