logo ASAP Utilities

Compare versions

Compare version with version   

Version 4.6.4 compared to version 4.5.8

New tools and improvements:

Bugs that are fixed:

  • System Reload all installed add-ins (rebuilds the menu)
    Didn't reload the shortcuts set for ASAP Utilities and gave an error. This bug was unfortunately introduced in 4.6.3, but it is now fixed.
  • Columns & Rows Conditional row and column select, hide or delete...
    Produced an error if there was a cell with an error in your selection and you had chosen the search option "like" and the "case sensitive" option unchecked.
    This is now fixed.
  • Formulas Copy formulas without changing their cell references...
    Fixed the bug in the undo.
  • Objects & Comments Comment tools...
    This tool could sometimes cause an error if a sheet contained a large amount of comments. This is now fixed.
  • A few small bug fixes.
  • Export Export worksheets as separate files...
    Fixed the bug that caused export files, that were in text-format, to be empty.
    This bug was unfortunately introduced with version 4.6.1, our apologies for this.
  • Excel 2010 (32 bit edition)
    Fixed the ASAP Utilities startup error that sometimes occurred.
    We created a workaround for a bug in Excel 2010 which prevented ASAP Utilities from starting correct. Despite all the suggestions in some cases if you were administrator and installed ASAP Utilities, the program kept being unable to connect to the ASAP Utilities library DLL. Somehow in Excel 2010 this DLL is registered not only in the LOCAL MACHINE part of the registry, as we have  specified it to do, but it also included ASAP Utilities in the LOCAL USER part of the registry, which it shouldn't do and which causes ASAP Utilities to sometimes not work correct and give the DLL startup error.
  • Select Select cells based on content, formatting and more...
    The option "Number format contains" didn't work (anymore).
    This is now fixed and it works again.
    You can use it to select cells based on a (part of a) certain number format string.
  • Columns & Rows Remove unused empty ending rows/columns
    Could sometimes produce an error if your sheet contained a table (Excel 2007/2010: Insert > Table). This is now fixed.
  • Export Export worksheets as separate files...
    Produced an error if you had a worksheet which as protected and you were using Excel 2000/2002/XP or 2003. This is now fixed.
    In version 4.5.9 we updated this utility because cells with more than 255 characters were stripped to the first 255 characters in Excel 2000/2002/XP/2003. However, this gave an error on a protected worksheet.
  • Formulas Copy formulas without changing their cell references...
    Now works without errors if the target is in another workbook.
  • Fill Insert before current value...
    Fill Insert after current value...
    Fixed the bug that prevented you from using the same text in another case, such as first in lower case, and then later in upper case.
    For example if you added the text 'text', this setting was remembered. However if you later wanted to add the letter 'TEXT' in uppercase, it didn't work because the autocomplete detected that you already added this text before and due to the fact that this comparison is not case sensitive, you couldn't add the same text in other case. This is now fixed by turning autocomplete off, since we can't make autocomplete case-sensitive. You can still quickly choose a previously entered value by using the arrow keys or dropdown with the mouse.
  • Columns & Rows Autofit row height (also on merged cells)
    The utility didn't work when the combined column width of the merged cells was more than 255. We have created a workaround for this so that it doesn't give the error anymore. However in such as case with long text the row height might not be adjusted correct with long cell values. At this moment we don't have a better solution (for what seems to be a very rare situation anyway).
  • General
    We changed a small thing in the startup of ASAP Utilities which could lead to a problem (an extra empty workbook) when opening a workbook in/via a program called ProSystem fx Engagement.
  • System Find and remove external links...
    Bug fixed. If a formula with a link to another file was on a protected sheet, this utility produced an error and the calculation mode for that sheet was left in manual calculation mode. This is now fixed and the utility will inform you nicely if a link exists (in a formula) on a protected worksheet.
  • Format The paper saver (split columns)...
    If you used this utility on a workbook with one or more pivot tables and were using Excel 2007 or 2010, then Excel could crash. We have no explanation for this, theoretically that is impossible. However, we now created an alternative code to set the page breaks for these Excel versions and that has solved the problem.
    Excel 2000, 2002/XP and 2003 didn't have this problem.
  • Export Export selection or active sheet as new file...
    Improved exporting the formulas in text format. The utility now also uses the A1 or R1C1 referencing based on your current settings in Excel.
  • A few small bugfixes/improvements.
  • Select Select cells based on content, formatting and more...
    Fixed the bug during startup that appeared on computers that had the regional date settings set to use leading zeros for months:
    Sorry, something unexpected went wrong at code line 1520:
    Error 438: Object doesn't support this property or method
    Despite the error on startup, the utily kept functioning correct.
  • Export  Export selection or active sheet as new file...
    If you had the option "Do not export hidden cells" unchecked, then the tool gave an error and didn't do the export. This is now fixed.
    Sorry, something unexpected went wrong at code line 250:
    It isn't sure if the export succeeded.
    Error 91: Object variable or With block variable not set
  • ASAP Utilities Options New tools in development (English only) Report pivot table(s) information
    Fixed the bugs that caused an error when you created a report for pivot tables  that had an external datasource. We also added a few more details to the report.
  • ASAP Utilities Options New tools in development (English only) Split data table into multiple worksheets
    The rowheight and column width is now properly preserved for cells with long contents too.
  • The following tools were updated to better distinguish the large amount of colors that are available starting from Excel version 2007.
    . Format Copy and apply cell's formatting settings...
    . Sheets Insert multiple sheets (uses the cell values as sheet names)...
    . Range Advanced sorting... (left to right)
  • In a non-English version of the pre-release of Excel 2010, the browse-for-folder technique in ASAP Utilities produced an error. This is now fixed.
  • Undo
    Fixed the bug that caused that the undo for the following tools sometimes didn't work. This could happen for example if one of the following tools was the first and only tool used from ASAP Utilities and then the undo was performed:
    . Text Delete all text characters (a-z) in selected cells
    . Import Insert (delimited) text file...
    . Import Insert text file separated by space...
    . Import Insert text file separated by tab...
    . Import Insert text file separated by comma (csv file)...
    . Import Insert text file separated by "|" (pipe/bar)...
    . Import Insert text file separated by "!" (exclamation mark)...
    . Import Insert text file (with options)...
  • Fill Create a list of filenames and properties in a folder...
    Fixed the bug where ASAP Utilities thought incorrect there weren't enough rows available (-2) to report the files.
  • Columns & Rows Autofit row height (also on merged cells)
    If you added this tool to your favorites&shortcuts menu and assigned a shortcut to it, then that shortcut didn't work. When you clicked on it in the menu it worked correct but when you used the shortcut for this to you got an error "the macro cannot be found". This is now fixed.
  • Export Export worksheets as separate files...
    In Excel 2000, 2002/XP and 2003: If you choose to export the sheets as Excel files, cells with more than 255 characters were truncated to 255 characters. This is now fixed. This problem did not occur in Excel 2007 and 2010.
  • Export Export worksheets as separate files...
    In Excel 2000, 2002/XP or 2003: If you choose to export the sheets as Excel files, cells with more than 255 characters were truncated to the first 255 characters.
    This is now fixed. This problem did not occur in Excel 2007 and 2010.
  • A few small bugfixes/improvements.



Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
© 1999-2019 - - - - The Netherlands

Connect with us and receive our tips that show you how to benefit from the tools in ASAP Utilities at:
Follow us on TwitterFollow us on Facebook