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.