A-Shell 6.5 Development Notes

1739.0.6

CSV2XL.SBX 2.1(286): SetBanner now supports the fontname and fontsize attributes, e.g.:

//XL,SetBanner,text="This is a Banner",fontheight=20,fontname=Broadway

1730.0.3

CSV2XL.SBX 2.1(279) adds CSV2XL Directive AddLink to create link from specified cell to footnotes..

1730.0.2

CSV2XL.SBX 2.1(277) adds CSV2XL Footnote Subscripts to enable footnote subscripts.

1731.0.1

CSV2XL.SBX 2.1(275): CSV source files using TAB or pipe (|) delimiters are now supported.

1730.1.9

CSV2XL.SBX 2.1(281) adds several CSV2XL Refinements.

1730.1.10

CSV2XL.SBX 2.1(282) adds additional CSV2XL Refinements.

1725.0.4

CSV2XL.SBX 2.1(269): Extend limit on individual //XL parameters from 256 to 512 characters. This was mainly an issue for footnotes and possibly banners, which can get quite lengthy.

1724.2.2

CSV2XL.SBX 2.1(268): A literal "^m" inside a data field now makes the expected adjustments to the spreadsheet configuration (activating the wrap option and increasing the row height). Note that this was previously supported in the column headers only.

1702.2.3

CSV2XL.SBX 2.1(263) supports two minor enhancements to existing INI file options:

•   SendToPC=2 forces the file transfer to use the ATE-specific non-FTP transfer protocol. This is useful in environments where (S)FTP is not supported. Option 1 continues to use (S)FTP if the server is not Windows and the file is larger than about 10K.

•   SaveToDir now supports AMOS-style directories, including ersatz. Previously it only supported native directory notation. If the directory does not exist and cannot be created, it will be ignored.

1682.0.5

CSV2XL 2.1(250) adds new directive to control output format:

//XL,SetOutputFormat,<format>

This directive overrides the OutputFormat directive in the INI file. The two format options are XLS and XLSX. As with the SetINI directive, it has to appear in the CSV source file prior to any lines that do not start with //XL.

1682.0.4

CSV2XL 2.1(249) adds CSV2XL Directive SetRGBmode to support RGB colors.

1682.0.3

CSV2XL 2.1(248) adds support for Cell-Level Attributes.

1672.0.2

CSV2XL.SBX 2.1(244) enhancement to the SetBanner directive: you may now embed an explicit line break by inserting "^M" into the text, in which case the height of the banner will be increased accordingly. Unlike the column headers, the banner does not typically wrap and increase in height automatically, at least under most versions of Excel, apparently due to complications with the cell merging used to spread the banner across all the columns.

1682.0.2

CSV2XL 2.1(247) The SetRow directive now supports setting attributes (such as colors) for the next row or a specified set of rows yet to be output. Also, fix an apparently intermittent issue with the total and nototal parameters on the SetCol directive.

1682.0.1

XTREE enhancement: export to XLSX via CSV2XL now supports colors.

1671.4.2

CSV2XL.2.1(243) adds CSV2XL Directive SetGroup.

1671.0.2

CSV2XL adds CSV2XL Directive AddFootnote.

1668.0.9

CSV2XL 2.1(238) adds CSV2XL Directive SetBanner.

1668.0.7

CSV2XL 2.1(236) refinement to the AddSheet directive: extension may now be eliminated from the directive in order to allow the current output format to set the standard extension. Previously you had to specify either xls or xlsx which would then cause problems if the actual format didn't match.

1668.0.5

CSV2XL 2.1(234) adds new parameters to the //XL,SetCol directive:

total: forces column to be totaled

nototal: disables totals for the column

These override the ColTitleTextRegex directive in the CSV2XL.INI file, as well as the default rules, which are to total numeric columns.

1668.0.4

CSV2XL 2.1(233) adds directive:

//XL,AddComment,row=##,col=##,text=text{,width=pixels}{,height=pixels}

Note that as of LIBXL 3.8.5, this directive is ignored for XLSX format, i.e. is only supported for XLS format.

1661.3.4

CSV2XL.SBX 2.1(232): add hcenter and vcenter options to the //SetPrint directive, e.g. //SetPrint, vcenter{=1},hcenter{=1}. Note that the =1 is optional (1 for on, 0 for off), but since there is little reason to ever specify the attribute except when turning it on, it isn't really necessary to specify the attribute value.

1661.0.4

CSV2XL.SBX 2.1(230) enhancements:  //XL,AddSheet now supports an optional parameter COLOR=COLOR_xxx to set the tab color; set wrap attribute for column headers.

1660.6.2

CSV2XL.SBX 2.1(227) adds CSV2XL Print Directive SETPRINT to set print features.

1655.1.1

Refinements/enhancements to the //XL, AddSheet directive.