New in 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 Column(s), 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 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.