[]
DEMOS DOC DESIGNER API
DOWNLOAD
(Showing Draft Content)

Application Settings

SpreadJS Designer provides application-level settings that control designer behavior.

To open the App Settings dialog, click the Settings (gear) icon in the upper-left corner of the Designer window.

image

The dialog contains configuration options organized by category.

Data

PivotTable

Enable PivotTable Date Auto Group

image

When this option is enabled, date-type fields added through the PivotTable Panel are automatically grouped by date hierarchy (for example, Years, Quarters, and Months).

By default, this option is disabled.

Behavior notes:

  • The setting applies at the application level.

  • It affects only date-type fields added after the option is enabled.

  • Existing PivotTables are not automatically refreshed or regrouped when this option is turned on.

  • The behavior applies only when fields are added through the PivotTable Panel.

For detailed information about automatic date grouping behavior and grouping rules, see the Auto Date Group feature documentation.

After changing the setting, click OK to apply the configuration.