logo ASAP Utilities

Receive our newsletter

Get an email when a new version of ASAP Utilities is released

RSS Feed

The new version will be announced in our news RSS feed.

Changes in version 4.5.9 - May 27, 2010

Date: March 15, 2010 (last updated on June 1, 2010)
reference id: QA0224

Finished

On May 27, 2010 the new version 4.5.9 is released. Download

New features and improvements

  • NEW: Columns & Rows » Drawing paper
    This tool allows you to specify the column width and row height of your cells in centimeters, inches or pixels.
    This is helpful if you use the Excel for drawing purposes, such as creating a flowchart or when you design your garden or need to create a floor plan.
    It can also be handy for quickly creating square cells.
    Create drawing paper
  • NEW: System » Save file as... and use the first cell as the suggested filename
    This tool will launch Excel's "save as…" dialog and uses the value of the first filled cell on your worksheet as the suggested filename.
    Save file as... and use the first cell as the suggested filename
  • General
    The setup is now translated into Dutch, German, Spanish and French too.
    ASAP Utilities setup
  • Objects & Comments » Comment tools...
    Your last used settings will now be remembered.
    If you choose to autofit/resize all comments, the utility used to use a maximum width of 300 so that you could read the contents without horizontal scrolling. You can now specify your own maximum width. This can be useful if you have a wider screen and when the comment contains many line-breaks.
    Set the maximum comment width
  • ASAP Utilities Options » New tools in development (experimental, English only)
    has been renamed to:
    ASAP Utilities Options » New tools in development (English only)
    The design is improved and it now also remembers the last started utility.
    New tools in development
    New tools that are currently in development
  • NEW: Show indented structure of formula in current cell
    via ASAP Utilities Options » New tools in development (experimental, English only)
    This is useful when you have a nested formula. It shows the indented structure of your formula. This way you can more easily see if the brackets are placed properly. You can also edit the formula.
    Formula indenter - Easily see the structure of nested formulas
  • NEW: Copy the path and filename of current workbook to clipboard
    via ASAP Utilities Options » New tools in development (experimental, English only)
    This will put the path and filename of your current workbook to the clipboard. You can then paste it into another application. This can for example be useful if you're working on a file and want to inform a collegue and tell him/her in an email where he/she can find the file.
    NEW: Copy the path and filename of current workbook to clipboard
  • NEW: Show or hide formatting marks in selected cells
    via ASAP Utilities Options » New tools in development (experimental, English only)
    With this tool you can make spaces, tabs and linebreaks visible. This can be useful because sometimes characters such as these mess up your lookup formulas.
    The following characters are used to show these characters:
    • = space
    ¬ = tab         
    ¶ = line breaks
    This tool changes your data when you choose "Show" but you can quickly switch back to the original when you choose "Hide". Basically the method is quite simple. It replaces spaces, tabs and line-breaks with a unique character. Then the "Hide" option changes these special characters back to spaces, tabs or linebreaks again.
    Unfortunately it is not possible to make it work without changing the values like  the hide/show formatting marks in MS Word. However we think that this tool is a useful alternative.
    Show or hide formatting marks in selected cells
  • Columns & Rows » Remove all empty rows
    Improved speed. Furthermore, if you have hidden rows at the end of your data, they now remain hidden.
  • Columns & Rows » Remove all empty columns
    Improved speed. Furthermore, if you have hidden rows at the end of your data, they now remain hidden.
  • Fill » Create a list of filenames and properties in a folder...
    The amount of files listed is now a worksheet formula. This has the benefit that when you use the autofilter to narrow down the list it amount of files listed is updated and it shows only the number of files displayed by the filter.
  • Select » Select cells based on content, formatting and more...
    You can now also select cells based on their date:
    . between
    . not between
    . equal to
    . not equal to
    . greater than
    . less than
    . greater than or equal to
    . less than or equal to
    . Weekday (for example select all Mondays)
    . Month (for example select all dates in December)
    . Year
    . Quarter (1st, 2nd, 3rd or 4th quarter)
    NEW: Select cells by date
  • Text » Convert/recognize dates...
    The utility can now also convert dates where the month is written as text.
    This means that if someone has entered for example "January 3, 2008" in a cell that this tool can convert it to a proper Excel date. You can then use it for example in your calculations or have the dates sorted properly.
    The utility recognizes the months written out in the language you have specified for the dates in Windows (Regional Settings), and it regognizes the languages English, Dutch, German, Spanish and French.
    Make Excel recognize dates where the months are written out
  • Select » Select cells based on content, formatting and more...
    We've added the option to choose between the cell's value, formula or displayed value (formatted text). This way you can for example select all cells with a formula that references to a certain file or sheet, uses a certain range name, etc., etc..
    Search within formulas and select these cells
  • Export » Export worksheets as separate files...
    Improved speed for some files when they are exported in a separated text format.

 

Bug fixes

  • 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.






« back

Follow ASAP Utilities on Facebook



Home Sitemap Search List of all utilities Printer friendly page ^ Back to Top
© 1999-2017 - - - - 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