Skip to main content
diagram

Column Type Syntax

The <enumId> portion must match an enumeration ID defined in Polarion Administration. The Risksheet server loads the enum values from Polarion at runtime — there is no enum definition in the sheet configuration.
Setting type: enum:<enumId> on a multi-select Polarion field renders a single-select dropdown. You must use type: multiEnum:<enumId> to enable multi-value selection, even if the underlying Polarion field supports multiple values. This is the most common multi-enum configuration error.

Column Properties

Multi-enum cell text wrapping is controlled through CSS rules defined in the sheet configuration’s styles section (and applied via cellCss), not through a column-level property.

Enumeration Source

Enumerations referenced by multiEnum:<enumId> columns are defined in Polarion Administration > Enumerations — not in the sheet configuration file. The Risksheet server loads enum values (option ID, display name, optional description, optional icon) from Polarion when the document opens. To make values available in a multi-enum column:
  1. Create or edit the enumeration in Polarion Administration. Each option has an id (stored value) and a display name.
  2. Bind a Polarion custom field (or work item field) to that enumeration. The custom field must be configured to accept multiple values for native multi-enum storage.
  3. In the sheet configuration, reference the field via bindings and set type: multiEnum:<enumId> using the enumeration ID from step 1.
Cell decorators, formulas, and filter comparisons always work with enum IDs, not display names. For example, if an option displays as “High” but has id: high, use 'high' in your decorator or formula logic.

Enum Option Fields (loaded from Polarion)

Data Storage

Multi-enum columns support two Polarion storage formats: Blank options are automatically filtered out from the stored values during data processing. Risksheet handles bidirectional conversion between the grid display format (array of enum IDs) and the Polarion storage format transparently — all data continues to live in Polarion work items, not in a separate Risksheet store.

Rendering Behavior

Multi-enum values render as a list of styled tags within the cell:
  • Each selected value appears as an individual span.multi-enum-item element
  • All items are wrapped in a span.multi-enum-list container
  • Tags display the name property from the Polarion enumeration
  • If an enum option ID is not found in the loaded enumeration, the raw ID value is displayed as a fallback
  • Values stored as arrays are processed during cell rendering to resolve IDs to display labels

Filtering Behavior

Multi-enum columns support two filter modes with significantly different behavior:
Use Filter by Condition with the Contains option to find all rows that include a specific enum value. Filter by Value requires selecting all exact combinations containing that value, which is impractical for fields with many options. This is the most common filtering question from users working with multi-enum columns.

Cell Merging

Multi-enum values participate in the hierarchical merging system. Cells with identical selections merge vertically when they are in the same visual level group:
  • Multi-enum values are converted to string representations for merge comparison
  • Cells with identical value arrays (same selected options in the same order) merge properly
  • Empty brackets [] or invalid JSON prevent merging
  • The values must be in identical order for cells to merge

Export Behavior

Excel Export

When exporting to Excel, multi-enum columns are converted to a comma-separated list of human-readable option names:
  • Internal enum IDs are resolved to display names from the Polarion enumeration
  • Values are separated by comma and newline characters
  • Unknown enum IDs (not found in the loaded enumeration) are preserved as-is in the export

PDF Export

PDF export renders multi-enum values as comma-separated text of resolved enum labels, consistent with the Excel export format.

WorkItem Enum Fields

For custom fields that are enumerations of WorkItem type, the type value must match the XML custom field configuration exactly:
WorkItem enum fields require specific type syntax matching the XML custom field definition in Polarion. The exact format depends on your project’s custom field configuration. Check .polarion/documents/fields/custom-fields.xml for the correct type string. Upstream and downstream WorkItem enum fields have more limited support compared to row item properties.

Dependent Multi-Enum Options

Multi-enum columns support dependent option filtering based on a parent enum value. Dependent enumerations are a column-level feature (v25.3.1+ for single-value, v25.4.0+ for multi-value) — they are configured through column properties and the underlying Polarion enumeration relationships, not through a top-level configuration section. When the parent column value changes, the multi-enum dropdown dynamically refreshes its available options based on the relationships defined between the parent and child enumerations in Polarion.
Dependent enumeration support for multi-value enums was added in version 25.4.0. Single-value dependent enums were introduced in version 25.3.1. Ensure your Risksheet version supports the dependent enum feature before configuring dependent enum columns.

Undo/Redo Support

Multi-enum fields have specialized undo logic. When you undo changes to a multi-enum column, the system restores visible options from stored enum item IDs. Dependent column values are also automatically restored to maintain data consistency.

Version History

Error Messages

Complete Example

An FMEA sheet configuration with multi-enum columns for impact categories and affected systems. The referenced enumerations (impactCategoryEnum, affectedSystemEnum, and the rating scales) are defined in Polarion Administration:
The enumeration IDs (impactCategoryEnum, affectedSystemEnum, severityRating, occurrenceRating, detectionRating) must exist in Polarion Administration > Enumerations, and the custom fields (customField_impactCategories, customField_affectedSystems, etc.) must be bound to those enumerations on the work item type.
Last modified on July 10, 2026