A-Shell 7.0 Release Notes

1766.0.1

XTREE enhancement: support property sheets combining H, HH and editable.

1766.0.2

XTREE refinement: combining cformat codes  t  (display-only checkbox) and  E  (editable) is now equivalent to  T  (editable checkbox). Previously it would have acted like a string during editing. This makes it easier to toggle the editable option without requiring custom code for each column.

1765.9.1

XTREE refinement: non-editable property sheets now support H and HH cformat codes.

1765.5

Vertical scroll mechanism now supports the mouse wheel.

1765.3

Scroll syncing is now automatically bidirectional. The first scrolling operation on the 'master' tree automatically links the 'slave' tree back to the 'master', unless it was already linked to a third tree.

1765.0.1

XTREE enhancement: image columns can now be 'sorted'. Since there's no natural order to images, this operation only serves to group the same images together.

1765.0.2

XTREE enhancement: the PopupMenu $SRCHxxx functions now include searching the label column in a Property Sheet.

1765.0.3

XTREE enhancement: Add ability to sync vertical scrolling.

1763.0.1

New XTREE RGB Header options add support for overriding row/column header color attributes.

1758.0

XTREE: new cformat code "HH" acts like "H" (hide column) but only if the column is empty (if string) or zero (if numeric).

Note that the logic supporting this is tied to the data (rather than answer) array load operation.  So adding data to the answer array for a previously hidden HH column and and re-entering with XTROP_RESELECT will not cause cause the column to become visible. But adding it to the data array and re-entering with XTROP_REPLACE should reevaluate the column to determine if it should become visible.

1742.0.1

XTREE enhancement: tree data array argument may now be supplied in the form of a gridmap.

1739.0.5

Web / Image: XTREE and AUI_IMAGE now support loading loading images from a web server using an http:// or https:// specification, either directly, or via WEBCACHE (with OPENI and LOOKUP enabled). In the non-WEBCACHE XTREE case, most likely you would want to set ImgDir to the http:// or https:// directory location where the images are, and then just pass the image name.ext in th individual cells.

Note that even when WEBCACHE is not enabled, images pulled down from the web will be cached in the local %MIAME%\webcache directory.

1738.0.2

XTREE: all exitcodes now take precedence over -48, validation.

1737.0.1

XTREE: new flag XTF2_NOAUTOFILTER (&h02000000) allows applications to disable the AutoFilter feature no matter how it was enabled. Since it can be enabled via global settings in the MIAME.INI—see OPTIONS=XTAUTOFILTER—this allows applications to disable the feature for a single tree at a time. Some reasons you might want to disable it is to avoid end user confusion in places where filtering doesn't make sense, such as in multi-level trees (where filtering only affects the top level), or in extremely large trees (to reduce overhead), or simply for testing purposes.

1737.0.2

XTREE: increase the maximum XTR.EXPANDLEVEL from nine to 63 to match the maximum level number supported in a '@' column.

1737.0.3

XTREE context menu: the context menu is now enabled whenever a cell is being edited (with at least copy and paste). Previously it required one of the global context menu flags or an explicit PopupMenu definition.

1736.1.3

When a editable cell with validation has been edited but then the user clicks on a button that translates to ESC before otherwise exiting from the cell, the exitcode 1 is now appended to the XINFO parameter.

1734.2.1

XTREE/INFLD: set matching (e.g. SETDEF, ListX, CellListX) now treats the double-quote character (") as any other character, hopefully making it easier to support descriptions with matched or unmatched embedded quotes, e.g. ...,RUL,6" ruler,...

1734.2.2

The ctitle field in the coldef parameter now recognizes HTML-style escaped characters, i.e. %xx where xx is value from 00-ff (hex). This is mainly a convenience for specifying hard breaks within a header or footer without having to resort to concatenating a chr(13) into the coldef string. For example, "1~20~Happy%0d~Hour~S~..." may be more convenient to code than "1~20~Happy"+chr(13)+"Hour~S~...". Note that a % not followed by two hex digits is treated as is; you can also use %% to indicate a literal %.

1733.0.2

Coldef "D" (date) now recognizes SQL DATE and DATETIME formats CCYY-MM-DD {HH:MM{:SS}}. Previously they didn't sort properly. Note that if all the cells in the column are in that format, sorting will work with coldef "S" (string), but date filtering would not.

1729.0.1

Add new filter variation CBX. It is similar to the old Filter=CB but instead of grouping the items by the first one or two characters, it lists them all. CBX replaces CB as the default filter type (when applicable), so most trees will change to the new filter without any program change or recompilation. The exception is when Filter=CB is explicitly specified, in which case it continues invoke the old filter.

1726.0.1

Add member FILTERED to the XTRCTL parameter structure.

1724.2.3

When exporting to XLSX, embedded CRLF's (ASCII 13 plus ASCII 10) are now exported as "^m". Requires CSV2XL 2.1(268) to be effective.

1724.0.6

Add various XTREE Auto-Filter Refinements and minor fixes.

1722.0.1

Advanced Coldef Option ImgDflt allows you to specify a default image that will be displayed if and when the specified image is not found.

1720.0.2

The ImgDir Advanced Coldef Directive can now be used to specify the name of a DLL containing icons, allowing just the icon name to be specified in each cell. Note that to indicate that the ImgDir value is a DLL name, it must be preceded with "::", for example:

ImgDir=::ASHICO1

1720.0.10

As an alternative or workaround to the splitter position optimization logic built in to the control for split-pane configurations, which does not always work properly, you can now set XTR.LEFTPANEWIDTH = -2 to force A-Shell to use it's own manual width calculation. The manual method is less precise and slower than the logic built in to the control, but less likely to be completely wrong.

1715.4.2

XTREE local validation refinement.

1715.0

Add support for local (or client-side) validation of editable cells via an internal call from XTREE to a specified XTREE Local Validation SBX.

1713.3

cformat code A (ASCII sort) now takes precedence over code # (numeric).

1713.0.4

New PopupMenu Command $SORT triggers an internal multi-level sort.

1711.0.9

Exporting to a spreadsheet now supports the footers if XTR.SHOWFOOTER=1. Also, when exporting in the full XLSX mode (see SBR=XTREE_EXPCSV2XLSX), if the Advanced Coldef Parameter Title is defined, it will be used as a banner. The special macro tokens (e.g. %date%) are supported but %page% and %total% (which don't make any sense in the banner of a spreadsheet) are just converted to blanks, as are the justification separators (|).

1711.0.12

Increase the threshhold for switching to the larger "+" and "-" MLVL buttons (see 6.5.1706) for standard 96 dpi (non -dpm) mode.

1709.0.2

Specifying Filter=NONE on a zero-width column now sets the default for subsequent real columns.

1706.0.3

Increase the size of the expand/collapse buttons, checkboxes and radiobuttons for higher resolution screens, as the original sizes were getting to be too small.

1705.3

File drag-drop refinement: extend support to XTREE via the new flag XTF2_FILEDROP (&h01000000). Note that as with all other variations of the new file drag-drop feature, the drop event stores the dragged filename(s) and triggers exitcode -75, but it is up to the application to actually do something useful with the dropped files. In the XTREE case, the application would presumably something like add the filename(s) to the tree and redisplay it.

1701.2.3

Refinements to the filter dialogs:

1699.0.1

XTREE enhancement: Add a "Toggle All Filter Buttons" option automatically to the context menu when XTF2_AUTOFILTER is enabled. The option toggles the visibility of the filter button in the column headers of any column not actively being filtered. (The point is mainly to free up header space when the columns are tight.) Note that even without the filter buttons, you can still use the context menu to filter a column to the clicked on cell value.

1694.0.1

New XTREE Advanced Coldef Option ExportFpec allows setting of exported file name.

1693.0.3

Enhance XTR'SHOWBUTTONS options, which now allows single or double-click (or ENTER) to toggle the expanded/collapsed state of multi-level items.

1691

Add and revise INFLD Type Code ||1.

1691.0.3

Enhancement: increase the maximum number of columns from 100 to 200.

1690.4.4

Auto-Filter: the CB and Pattern filter types now treat blank cells as normal. Previously, there was no way to filter out the non-blank cells using the CB filter because it didn't present a checkbox option for blank. And in the case of the pattern filter, a blank pattern was matching everything.

1689.0.1

Enhancement: XTREE Column ID.

1685.0.2

Enhancement: Checkbox columns may now contain text as long as the first data position (i.e. the checkbox value character) is blank.

1675.0.1

Add Advanced Coldef option XTREE AutoNumber.

1668.2.3

Refinement: CTRL_SHFT_+/- (expand/contract all) is now sensitive to the level of the current item. When expanding, it only expands items at that level that are visible , along with all of their dependents. When contracting, it only contracts from the current level down. For example: to make the top 2 levels visible but none below that, start with CTRLSHFT+ on a top level item to expand all, then CTRLSHFT- on a 2nd level item to contract the levels below that.

1666.0.1

Enhancement: add the ability to limit the Auto-Sum feature, introduced in 6.5.1631.0, to specific levels in a multi-level tree.

1665.3.1

Further extend (see 1665.0) the range of RGB color indices from ASCII 33 (!) to ASCII 125 (}). Note that "=" remains a special value which forces the default color to be used.

1665.0

Extend the limit on the number of defined RGB colors indices, which were previously limited to A-Z and a-z for 52 total, to include 0-9 for 62 total.

1649.6.2

Auto-Filter refinements: • Columns with cformat "s" or "l" now eligible for Auto-Filtering. Previously required S or # as well; • Disable the context menu filter-to-value option for child items. Filtering only applies to the top level; child items are filtered along with their parents.

1649.0.2

Auto-Filter enhancement: the context menu now contains smart options to clear the current column filter or all column filters when applicable. It also contains a new option to filter the column by the value of the clicked-on cell.

1649.0.1

Auto-Filter enhancement: the Range filter type has been split into two variations: Filter=RangeStr and Filter=RangeNum. In the case of Filter=Range, it will decide for itself which kind of range makes the most sense. The string version (RangeStr) uses the ASCII collating sequence for the range selection, while the numeric version (RangeNum) now removes any non-numeric formatting characters from each cell and then uses the value to compare against the from/to range limits.

1647.3.2

Refinement: AutoSum totals now red if negative.

1644.0.4

Refinement: XTRSEL_EDIT_KEEP now works with the other selection bar styles.

1642.0.3

Auto-filtering refinement: when the CB filter dialog would have resulted in only a few single or double-character options, it converts to a set of 20 fixed range options. This is likely to be revised again soon to add a variable-range option.

1640.0.1

Add new function XTREE Auto-Filtering.

1637.0.1

Enhancement: footer text (XTR'SHOWFOOTER) may now include embedded CRLF line breaks in order to show multiple lines (same idea as for headers). For example: coldef += "1~15~Header::> Footer1" + chr(13)+chr(10)+"Footer2#~~"

1636.0.1

Enhancement: new Advanced Coldef Option RGBfgbg provides capability to specify foreground and background colors for individual cells.

1632

Add popup commands $CBSETX, $CBRSTX, $CBUNDOX.

1631.0.1

Add XTREE Auto-Sum Column Footers.

1631.0.2

Add XTREE Lookup-and-Fill.

1627.0

Add New Advanced Coldef Options to XTREE.

1626.0.3

Add PopupMenu Command $EXPCSV2XL

1626.0.1

Add values for the ExportOptions Advanced Coldef Directive.

1622.0

Enhancement: CellList id codes can now include both upper and lower case characters, extending the total range from 26 (a-z) to 52 (a-z, A-Z).

1609.0

Add to Advanced Coldef Options ExportOptions.

1604.0

Enhancement: new control for Radio Button / Check Box Colors.

1602.0.4

XTREE XTF2_ANSEQDATA.

1602.0.3

XTREE Multi-Select.

1602.0.2

XTREE Drag-Drop.