Rules for Exporting from a Table to a Spreadsheet

When you export the table data to a spreadsheet file, Monarch Classic uses the following rules to create the export file:

Records (rows)

The active filter, if any, determines which records will be exported. Only those records that satisfy the filter are exported. This creates an export file that matches the records you see on screen in the Table window.

Fields (columns)

Hidden fields are excluded from the export file. All other fields, including calculated fields, are exported.

Spreadsheet file formats support character fields of up to 240 or 254 characters, but do not support memo fields. To export a memo field, Monarch Classic trims the trailing spaces from each line, replaces the CR/LF at the end of each line with a single space, then truncates all lines to form a string. The string is truncated at the maximum length for the target file type, either 240 or 254 characters, then exported as a character field.

Date fields are always exported in serial date format to support their use in spreadsheet formulas that act on data values. When you import the data into your spreadsheet application, you can assign a date format to the cells to display them as dates.

Numeric fields are always exported in their most compact form, without currency symbols or thousands separators.

Field names

Monarch Classic can optionally export the column titles as the first worksheet row. To export the column titles, select the Column Titles radio button in the Field Names subtab of Export Options.





© 2024 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support