Skip to main content

​
Configuration Topics

Columns — Column definitions mapping property paths to display settings including title, width, formatters, focus, and visibility. Column Groups — Visual grouping of related columns under shared headers with styling and collapse behavior. Views — Named column visibility presets that let users switch between different column sets for the same data. Styles — Named style definitions (colors and formatting) applied via formatters or column headers. Formatters — Conditional formatting rules that apply styles based on data values or expressions. Sources — Data source definitions specifying which entity types to query and which expansion paths to load. Sort By — Default sort order configuration for sheet rows. Column Properties — Detailed reference for all available column-level properties. Header Styles — Predefined and custom styling for column and group headers. Display Property — Controls which property of a referenced entity is displayed in a column. Render Property — Server-side rendering configuration for custom column output. Binding Syntax — Dot-separated path syntax for mapping columns to domain model properties and navigation paths. Conditional Formatting — Expression-based styling rules for dynamic cell appearance. Multi-Item Columns — Configuration for columns displaying one-to-many or many-to-many relationships.
For a step-by-step introduction to sheet configuration, see Creating Your First Sheet Configuration. For the YAML file structure reference, see Sheet Configuration YAML Structure.

​
Configuration Structure

A sheet configuration YAML file contains these top-level sections: 
columnGroups:    # Visual column grouping
sortBy:          # Default sort order
columns:         # Column definitions (required)
views:           # Named view presets
formatters:      # Conditional formatting rules
styles:          # Custom style definitions
sources:         # Data source queries and expansion paths
See the Sheet Configuration YAML Structure for the complete file format.
Related pages: Reference | Data Model Reference | Configuration Files Reference
KB ArticlesSupport TicketsSource Code
  • prod-powersheet-src/com.nextedy.powersheet.client/cypress/fixtures/configurations/constraints_composing.template.yaml
  • prod-powersheet-src/com.nextedy.powersheet/src/com/nextedy/powersheet/enumProvider/SheetConfigEnumProvider.java
  • prod-powersheet-src/com.nextedy.powersheet/src/com/nextedy/powersheet/PowersheetProduct.java
  • prod-powersheet-src/com.nextedy.powersheet/src/com/nextedy/powersheet/PowersheetService.java
  • prod-powersheet-src/com.nextedy.powersheet/src/META-INF/hivemodule.xml