History — Version 21.4

# Version 21.4

December 22, 2021

## New General Features

- Enabled Automatic Updates on the Free version (previously, only the Professional version supported Automatic Updates).

- Enabled the ability to disable Notifications and/or the Notification Balloon tip on the Free version (previously, only the Professional version allowed disabling Notifications and/or the Notification Balloon tip).

- Used Meiryo UI for Japanese, Malgun Gothic for Korean, and Segoe UI for other languages as default dialog box fonts (customizable in the Window page of the Customize dialog box).

- Separated the CSV/Sort toolbar into the CSV toolbar and Sort toolbar. The Sort toolbar is one of basic toolbars and customizable.

- Added the Transpose, Pivot Table and Unpivot buttons to the Sort toolbar.

- The new version allows recording some selections with the mouse to macros.

- Improved the speed of Combine Columns, Split Columns, and Encode/Decode Selection commands while columns are selected in the CSV mode.

### Test results:

| v21.3 | v21.4 | Comparison
--- | --- | --- | ---
Combine Columns*1 | 13.5 seconds | 1.23 seconds | 11.0 times faster
Split Column*2 | 5.56 seconds | 2.66 seconds | 2.09 times faster

*1 Select all 16 columns, Concatenate, String to insert: ";".

*2 Use a file saved after *1, Split all into columns, Separator: ";".

All: 1.99 GB, 15.9 million lines, random CSV data. Default options except Always Discard Lengthy Undo Information to Accelerate on, 16 threads, Windows 11, Core i9-11900K, 64GB RAM, 2TB SSD.

## New Options

- Added the Locale-dependent Uppercase/Lowercase check box to the Edit page of the Customize dialog box.

- Added the Run macros asynchronously by default check box to the Options page of the Customize Macros dialog box.

- Added the Remove empty strings, Remove duplicate strings, and Sort strings check boxes, and How to Sort list box to the Combine Columns dialog box.

- Added the Dialog box font drop-down list box to the Window page of the Customize dialog box.

- The New button in the Toolbars dialog box became a split button. Clicking ▼ allows you to reset a new toolbar as the Basic or Sort toolbar.

- Added the Pivot Table and Unpivot dialog boxes.

## New Commands

- Transpose

- Pivot Table

- Unpivot

## Plug-in New Features

- Added EE_PIVOT_TABLE message, PIVOT_TABLE_INFO structure, and Editor_PivotTable inline function.

- Added EE_UNPIVOT message, UNPIVOT_INFO structure, and Editor_Unpivot inline function.

- Added EI_GET_SPLIT command to the EE_INFO message.

- Added the FLAG_MAKE_LOWER_L, FLAG_MAKE_UPPER_L, and FLAG_CAPITALIZE_L flags to the EE_CONVERT message and Editor_Convert inline function.

- Added the nCombineFlags and pszLocale parameters to the Editor_EditColumn inline function. Added the nCombineFlags and pszLocale fields to the EDIT_COLUMN_INFO structure.

## Macro New Features

- Added the PivotTable method and Unpivot method to the Document object.

- Added the strSortType, nCombineFlags, and strLocale parameters to the CombineColumns method of the Document object.