Category / Section
Understanding Grid Exporting Limitations
Published:
This article details how grid data exports work in different modes (Aggregated and Raw), including row limits, export scope, filter considerations, and format settings.
Export Modes & Behavior
Aggregated Mode (Grid Widget)
Excel and CSV:
- Exports aggregated data when functions like Sum, Count, Min, or Max are applied.
- Exports non-aggregated data when no function is configured.
- Exports raw data if the “Show Raw Data” property is enabled.
PDF, Image:
- Only exports the data visible within the image resolution.
Row Limits
Excel and CSV:
- Maximum 200,000 records in Excel, 1,000,000 in CSV.
- MS Excel has row limitations (1,048,576 visible rows).
PDF, Image:
- Limited to visible data only.
Filter Considerations
- All export types support filtered records.
Format Settings
- Formatting is supported for all export types except raw data exports.
Export Details
| Mode | Export Type | Export Modes | Row Limits | Export Scope | Filter Considerations | Format Settings |
|---|---|---|---|---|---|---|
| Aggregated Mode (Grid Widget) | Excel and CSV | - Exports aggregated data when Sum, Count, Min, Max, Average is configured. - Exports non-aggregated data when None is configured. - Exports Raw data when Show Raw Data property is enabled from Basic Settings. |
- Exports maximum of 200,000 records in Excel and 1,000,000 in CSV (default configuration). - Can be modified through config.json in UMS settings. - MS-Excel Row limitation: Maximum 1,048,576 visible rows in Excel. |
- All data exports from the data table (Excel, CSV). | Exports with filtered records for all export types. | Supports formatting for all export types except CSV. |
| PDF, Image | - Exports only the data visible to the image resolution (Image). - Exports the data visible to the page resolution (PDF default exporting). - Exports all data with multiple pages when page-wise PDF exporting is enabled. |
NA | NA | NA | NA | |
| Raw Mode (View Underlying Data) | Excel and CSV | - Exports raw data from the database for visible columns in the underlying dialog. | - Maximum number of records available in the data table until the MS Excel limit (1,048,576). - No limits for CSV. |
- All data exports from the data table (Excel, CSV). | Exports with filtered records for all export types. | NA |
| PDF, Image | NA | NA | NA | NA | NA |
Summary
- Aggregated mode exports summarized data, while raw mode exports full data.
- Export limits depend on the format (Excel: 200K rows, CSV: 1M rows).
- Filtered records are included in exports.
- PDF & Image exports are restricted to visible data.
- Formatting is supported in all exports except raw data.
Related Links
SR
