Added March 2025
//XL,AddTotals,#
//XL,SplitRow,#
//XL,SplitCol,#
These override the INI file options of the same names, provided they are placed after all SetCol, SetINI, and SetBanner directives. Set # to 0 to disable, > 0 to enable and/or set to a specific value.
Setting AddTotals to 0 disables all totals, overriding the SetCol directives. Setting it to 1 enables totals, but does NOT override the SetCol "total" and "nototal" options, nor the built-in rules for deciding which columns are suitable for totalling—i.e. not text, dates, etc.
The Split options might also be thought of as "freeze" as they control the number of rows and/or columns that remain in position while the others are allowed to scroll vertically and/or horizontally. The default for SplitRow is 1, which freezes the top 1 or 2 rows, depending on whether a banner was defined. Setting it to a larger number freezes the rows less than the specified number (e.g. SplitRow,4 freezes 3 rows.) SplitCol defaults to 0; both 0 and 1 result in no columns frozen. To freeze N columns, set SplitCol to N+1.
History
2025 February, A-Shell 7.0.1769, CSV2XL 2.2(302): Directives added to A-Shell.
