This button allows end-users to export the contents of the grid or reference set selector to an excel file. Please note that constraints by use of search fields and sorting will also be exported.
Maximum number of rows
Indicates the maximum number of rows that can be present in the datagrid when exporting. Useful to prevent users from exporting large quantities of data, potentially placing a heavy load on the server.
Date export format
Since: Mendix 4.8
Defines how dates will be exported. When Date value is selected, date values will be exported as real dates, so that it is possible to use Excel date functions like sorting. When Text is selected, date values will be exported exactly as shown in the data grid.
Default value: Date value
When choosing Date value, dates will be shown only in the time zone of your Windows account, because Excel does not support defining specific time zones.
See Button Properties.