Changes in version 4.2.8 - September 23, 2008
Date: September 9, 2008 (last updated on Januari 21, 2009)
reference id: QA0193
On September 23, 2008 the new version 4.2.8 is released. Download
- Range » Move selected range (only values)...
Didn't work in Excel 2000. This is now fixed
(Error 438: Object doesn't support this property or method)
- Objects & Comments » Delete all objects on current worksheet
This utility also removed the comments on your sheet. However the "comment-indicators", the triangles, were still shown by Excel. It could happen then when you click on a cell to view the comment that Excel would crash.
The utility has now been updated so that al objects, except the comments, are removed.
- Fill » Insert before current value...
Didn't always work on very long cells. In such a case it could produce an error and ASAP Utilities stopped working and you had to restart Excel to get ASAP Utilities working again. This is now fixed.
- Web » Convert hyperlinks to =HYPERLINK() formulas
Fixed the error that occurred when a cell in your selection contained a double quote ("). A few small improvements were made too.
- Range » Find / Replace in all sheets...
Fixed a bug when you could get an error with certain cell with long contents.
Furthermore the formulas in the results will now be displayed using your Excel's country settings instead of in the US/English notation.
- Text » Advanced character removal/replace...
Fixed a bug when nothing was removed/replaced in certain cells with long contents.
- Columns & Rows » Conditional row and column select, hide or delete...
The option 'every n'th row/column number' disappeared when you changed the option to handle 'rows' to 'columns'. This is now fixed.
- Range » Advanced sorting...
Fix the bug that sometimes occurred during the startup of the utility and produced an error such as "Error 424: Object Required" or "Method '~' of object '~' failed, Error -2147221080: Automation error"
This error could happen if you used the utility on a workbook, then closed that workbook and then used this sorting utility again.
A few spelling errors were corrected.
Follow ASAP Utilities on Facebook