v7.4 [Sep 29, 2017]
- Several small improvements.
- Export to CSV Unicode, newline character added at the end of the file.
- Better preserving of the Pivot Table formatting when exporting as values.
- Improved speed.
- Now handles large Tables better.
- Cells with logical values (TRUE/FALSE) are now ignored, and cells with a date value are now included too, so that you can also sum dates based on the cell's interior or font color.
- Improved startup speed.
- German language: fixed the spelling in the spell number functions (füftausendzwölf / f~nftausendzwxlf).
- Workaround/fixed the small xlb file size increase caused by a bug in Excel when then right-click menu in ASAP Utilities was enabled.
v5.6 [Feb 10, 2015]
May include unspecified updates, enhancements, or bug fixes.
v5.5 [Nov 3, 2014]
Improved:
Export:
- Export selection as HTML table to clipboard.
- The option 'Character encoding' now encodes more characters into their HTML character entities.
General:
- Better detection if Excel is started in 'embedded' mode.
Bug fixes:
Information:
- Count duplicates and give each set of duplicates its own color.
- Now works on cells with (very) long cell contents too. (Previously you could get an error stating 'type mismatch' on code line 850).
Formulas:
- Change formula reference style (e.g. A1 to $A1 etc.).
- Fixed the bug that caused array formula in your selection to change to regular formulas.
General:
- A few small improvements and bug fixes.
v5.2 [Feb 11, 2014]
- Sheets: Split the selected range into multiple worksheets.
- Fixed a bug that was introduced in version 5.2 and caused the following option
to not work correct: 'For every new value/group in column'.
v4.7 [Jan 22, 2011]
- Sheets » Split the selected range into multiple worksheets...
By request, the utility now also copies the row height.
- Web » Activate hyperlinks (create from cell values)...
Now automatically adds http:// in front of the hyperlinks if needed.
- ASAP Utilities Options » New tools in development (English only)
By request, the following tools are added:
- Delete range names with bad cell references (#REF!)
Removes all range names with invalid addresses. The utility creates a report that shows which names have been removed.
- Ungroup all grouped columns in the selected worksheets
- Ungroup all grouped rows in the selected worksheets
- Bulk replace: replace multiple values at once
