A-Shell Consolidated Reference

Code

applies to ListX or CellListX columns, causing the code rather than the description to be exported to the CSV.

Descr (default)

export the description rather than the code.

No

Causes the associated column to be excluded from exporting. Applies to real columns only.

Yes

Causes the associated column to be included in the export, regardless of whether the column is hidden in the display view. Note that hidden columns will be output according to their physical position in the coldef. Applies to real columns only.

NoRowIf#

Causes the entire row to be excluded from the export if the value of the corresponding column is not zero—or, in the case of a checkbox or radiobutton cell, is checked / set. This would typically be used with an editable checkbox column to select rows to include or exclude from the export. Applies to real columns only.

NoRowIf!

Opposite of NoRowIf#, i.e. excludes the row from the export if the column value is zero or unchecked.

PhyOrder

Causes the order of the columns in the export to be based on the physical order they are defined in the coldef, rather than the display order, which is otherwise the default. This option affects all columns, regardless of the column that it is specified with. Also note that the option can be abbreviated to ExportOptions=Phy; any additional characters are ignored.

Attr

Include foreground/background color attributes when exporting to Excel using CSV2XL. Automatic if exporting to XLSX, by setting the system option SBR=XTREE_CSV2XCLSX either in the MIAME.INI or via MX_SBRFLG, or via the PopupMenu $EXPCSV2XLSX command.

NoAttr

Disable export of color attributes.