1769.0.3
|
New
|
CSV2XL.SBX 2.2(298) new directive:
//XL,SetPageBreak{row=#}{,col=#}
The directive forces a break to occur after the specified row and/or column when the spreadsheet is printed. The default row is the current position. To set a column page break without a row pagebreak, set row=-1. Note that page breaks may be seen in Excel by activating Page Break Preview from the View menu, or by using the Print Preview.
|
1769.0.4
|
New
|
CSV2XL.SBX 2.2(299) new attributes for the existing //XL,SetPrint directive:
vfitpages=#
hfitpages=#
The above two attribute values pairs may be used to set the print scaling to fit the spreadsheet on the specified number of print pages, vertically and horizontally, respectively. For example, to force the output to be scaled so that all the columns fit across a single page width, use:
//XL,SetPrint,hfitpages=1
|
1769.0.5
|
New
|
CSV2XL.SBX 2.2(300) add support for using the following macros as attribute values in //XL statements, referencing the INI attribute value of the same name:
$HEADERSFG
|
$HEADERSBG
|
$TOTALSFG
|
$DEFAULTFONT
|
$DEFAUULTFONTSIZE
|
$DATEFORMAT
|
$TIMEFORMAT
|
$DATETIMEFORMAT
|
For example, to the INI-defined headers background color as the background for a particular column ...
//XL,SetCol,colfirst=7,width=2,bgc=$HEADERSBG
|
1769.0.6
|
New
|
CSV2XL.SBX 2.2(301) new directives:
//XL,SetLaunch,#
//XL,SetAppendSeqno,#
These override the Launch and AppendSeqno options from the INI file. Replace # with 0 to disable, 1 to enable. Directives must be placed after any SetINI directive.
|
1769.0.7
|
New
|
CSV2XL.SBX 2.2(302) new directives:
//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.
|
1769.0.8
|
New
|
CSV2XL.SBX 2.2(303) refinements to the //XL,AddSheet directive
| • | The sheetname attribute is now optional, defaulting to "Data". Previously, the operation may have failed entirely. |
| • | The target directory (extracted from the dstbook attribute) will now be created if it doesn't already exist. Note that this only works at the bottom level, i.e. the parent directory must exist. If the directory creation fails, the spreadsheet will be saved in the current directory. |
|
