Number of cells

The number of cells that can be exported without warnings or errors.

Shows a warning if there are more than 100,000 cells or up to 500,000 cells, depending on the configuration of the session and ABAP memory.

Shows a warning depending on device used, for 2,000,000 cells on a desktop and 100,000 cells on a mobile device.

The total number of cells is limited only by the physical memory of the client and memory restrictions of the browser.

File compression

Office Open XML spreadsheets are ZIP containers that contain a particular file structure. To reduce the file size, these ZIP containers can be compressed.

Header row

The exported spreadsheet contains a header row with the corresponding column labels.

Also, the exported spreadsheet uses the built-in auto filter for all configured columns. This will allow the user to apply filters directly in the exported file without having to change the file.

Localization

The location of the user exporting a file is taken into account, and the content of the exported spreadsheet will contain translated column headers and the required date, time, and Boolean representation.

Column headers in the exported file can be shown in the user's language as defined in the back-end system and might differ from what the user sees on the UI.

The column headers in the exported file are the same as the ones shown on the UI.

Meta information

Metadata with additional information is shown in the exported spreadsheet.

Provides an appendix to add information to the data sheet.

Provides an optional sheet in the workbook to attach additional information to the exported spreadsheet. This meta information is grouped and thus allows you to add information in different layers without any conflicts. A typical use case would be that, for example, SmartTable adds some basic information, and an application developer could enhance this by adding something on top of it.

In addition to that, the client export allows you to add additional information that is not part of the sheets inside the workbook. This data is built-in information and can be processed by applications like Microsoft Excel.

Hierarchies

The exported file can contain hierarchies that are visualized when opening the file with Microsoft Excel.

Data types

Office Open XML spreadsheets support various types of data that have a different visual and functional behavior. The type representation differs from the raw data and needs to be transformed accordingly.

The types text, number, date, time, and boolean are supported.

The types text, number, currency, date, time, and Boolean are supported. In addition to the mere support for these data types, it is possible to pass additional configuration to create formatted text aggregations, a particular date and time output format, textual Boolean representation (for example, in stock/out of stock instead of true/false), and units of measurement.

Read Access Logging (RAL) support

If configured, Read Access Logging tracks who has access to which data at which point in time.This information might be required for audits.