Changes in version 4.5.9 - May 27, 2010

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.
  
• 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.
  
• General
  The setup is now translated into Dutch, German, Spanish and French too.
  
• 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.
  
• 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: 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.
  
  
• 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: 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.
  
• 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)
  
• 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.
  
• 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..
  
• 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.