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:

Combine Columns*113.5 seconds1.23 seconds11.0 times faster
Split Column*25.56 seconds2.66 seconds2.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.