Rules for Exporting from a Summary to a Spreadsheet
When you export a summary to a spreadsheet file, Monarch Classic uses the following rules to create the export file:
Rows
Each row in the summary is used to create a worksheet row in the export file.
Columns
Each column in the summary is used to create a worksheet column in the export file.
Key field columns containing date values 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.
Key field columns and measure columns containing numeric values are always exported in their most compact form, without currency symbols or thousands separators.
Column titles
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 tab of Export Options.
© 2024 Altair Engineering Inc. All Rights Reserved.