New in Version 21.4

December 22, 2021

New General Features

  • EnabledAutomatic Updates on theFree version (previously, only theProfessional version supportedAutomatic Updates).
  • Enabled the ability to disableNotifications and/or the NotificationBalloon tip on theFree version (previously, only theProfessional version allowed disablingNotifications and/or the NotificationBalloon tip).
  • UsedMeiryo UI for Japanese,Malgun Gothic for Korean, andSegoe UI for other languages as default dialog box fonts (customizable in theWindow page of theCustomize dialog box).
  • Separated theCSV/Sort toolbar into theCSV toolbar andSort toolbar. TheSort toolbar is one of basic toolbars and customizable.
  • Added theTranspose,Pivot Table andUnpivot buttons to theSort toolbar.
  • The new version allows recording some selections with the mouse to macros.
  • Improved the speed ofCombine Columns,Split Column(s), andEncode/Decode Selection commands while columns are selected in the CSV mode.

Test results:

v21.3v21.4Comparison
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 theLocale-dependent Uppercase/Lowercase check box to theEdit page of theCustomize dialog box.
  • Added theRun macros asynchronously by default check box to theOptions page of theCustomize Macros dialog box.
  • Added theRemove empty strings,Remove duplicate strings, andSort strings check boxes to theCombine Columns dialog box.
  • Added theDialog box font drop-down list box to theWindow page of theCustomize dialog box.
  • TheNew button in theToolbars dialog box became a split button. Clicking ▼ allows you to reset a new toolbar as the Basic or Sort toolbar.
  • Added thePivot Table andUnpivot dialog boxes.

New Commands

  • Transpose
  • Pivot Table
  • Unpivot

Plug-in New Features

  • AddedEE_PIVOT_TABLE message,PIVOT_TABLE_INFO structure, andEditor_PivotTable inline function.
  • AddedEE_UNPIVOT message,UNPIVOT_INFO structure, andEditor_Unpivot inline function.
  • AddedEI_GET_SPLIT command to theEE_INFO message.
  • Added theFLAG_MAKE_LOWER_L,FLAG_MAKE_UPPER_L, andFLAG_CAPITALIZE_L flags to theEE_CONVERT message andEditor_Convert inline function.
  • Added thenCombineFlags andpszLocale parameters to theEditor_EditColumn inline function. Added thenCombineFlags andpszLocale fields to theEDIT_COLUMN_INFO structure.

Macro New Features

  • Added thePivotTable method andUnpivot method to theDocument object.
  • Added thestrSortType,nCombineFlags, andstrLocale parameters to theCombineColumns method of theDocument object.