Changes in version 4.1.0 - March 19, 2007

New

• General
  Improved setup. Better approach for making ASAP Utilities installed as add-in in Excel and better removal upon uninstall.
• Sheets » Summarize rows or columns from several sheets...
  has been renamed to:
  Sheets » Put together rows or columns from several sheets...
  This utility has been renamed because some people associated it with the use of the SUM() formula in stead of creating a summary (combination).
• Select » Select cell with maximum value
  has been renamed to
  Select » Select cell with largest number
• Export » Export selection as HTML table to clipboard...
  Added the option to specify an class for the TR-tag. You can also specify alternate use of the class.
• Range » Advanced sorting...
  Two sort-options were added:
  - Day of the week (start on Sunday)
  - Day of the week (start on Monday)
• New worksheet function: =ASAPExtractFilename(FullFilename, optional separator)
  Extracts the file name from a full path & filename
  Example
  Cell B23 contains: D:\User Guide\screenshots\Sort random (shuffle).xls
  =ASAPExtractFilename(B23) will return "Sort random(shuffle).xls"
• New worksheet function: =ASAPExtractFolderName(FullFilename, optional separator)
  Extracts the folder name from a full path & filename
  Example
  Cell B23 contains: D:\User Guide\screenshots\Sort random (shuffle).xls
  =ASAPExtractFolderName(B23) will return "D:\User Guide\screenshots"
  
• New worksheet function: =ASAPGetFormula(FormulaCell)
  Returns the formula in a cell in local Excel language. Example: =GEMIDDELDE("A1:B12")
  Returns empty if the cell does not contain a formula
  
• New worksheet function: =ASAPGetFormulaInt(FormulaCell)
  Returns the formula in a cell in international notation. Example: =AVERAGE("A1:B12")
  Returns empty if the cell does not contain a formula
  
• New worksheet function: =ASAPMergeCells(inputrange, delimiter, skipemptycells)
  An easy alterative for the Excel =CONCATENATE() fuction. However the benefit
  of this ASAP Utilities function:
  - you can specify a range, for example A1:G1
  - you only have to specify a delimiter once
  - by default empty cells will be ignored
  
• New worksheet function: =ASAPCountByCellColor(Lookin_Range, Color_Index_Nr)
  Counts the amount of cells in the selected range that have a certain cell color.
  
• New worksheet function: =ASAPCountByFontColor(Lookin_Range, Color_Index_Nr)
  Counts the amount of cells in the selected range that have a certain font color.
  
• New worksheet function: =ASAPGetDomain(vFullURL, Optional bIncludeProtocol)
  Return the domainname from a given url.
  
• Import » Merge files together in a new file...
  Option added for text files whether or not to treat consecutive delimiters as one
  
• Select » Select cell with smallest number
  Select the cell with the smallest number in your selected range. It uses the =MIN() function to determine the smallest value and then selects that particular cell. If there are more cells that have the same minimum value, only the first cell is selected.
• Formula » Apply formula to selected cells...
  Added an option to only apply the formula to non-hidden cells. This is useful in case you have a range with the autofilter used.
• Fill » List filenames in folder...
  Improved. More information is given about the specified files and it the display of various folders and subfolders is more clear now. By default the autofilter is turned on on the list so you can easily make a selection, for example on certain file types.
• Fill » Add leading zeros...
  Added the possibility to add 0 (zero) leading zeros. This changes the number to be displayed without the leading zeros. (The same result can be achieved by using the "Numbers » Convert "textnumbers" to numbers" utility.)
• Select » Conditional select cells...
  Added the options to select unique values.
• Vision Control
  Now always opens expanded, showing the extra options available
• a few small improvements

Bugs fixed

• Import » Insert Textfile separated by space...
  Didn't import correctly in Excel 2000. It separated the data on each space, in stead of treating multiple spaces (consecutive delimiters) as one.
• Import » Merge multiple files in a new file.
  Fixed: Sometimes produced a runtime error 5 in Excel 2000.
  Fixed: It separated the data on each space in Excel 2000, in stead of treating multiple spaces (consecutive delimiters) as one.
• Select » Conditional select cells...
  Fixed a bug where in some cases the utility didn't find all cells because the option "Expand current selection" was checked but invisible and therefore couldn't be changed. Selecting duplicate values actually selected the unique values in stead of the duplicate once. This is now corrected.
• Range » Custom formula error message...
  Fixed: When you entered a non-numeric value quotes were saved and then doubled.
• Range » Empty duplicates in selection
  Fixed: Didn't properly remove all duplicate values if you range contained cells with errors too. The utility will now skip the cells that contain an error.
• Information » Get active cell's page number
  Fixed: could produce an error on some workbooks wich were created in Excel 97.
  Also changed the spelling of pagenumber to page number
• Sheets » Add sheets (with the names defined in selected cells)...
  Sometimes it produced an incorrect warning that a sheet already existed.
  This is now fixed. Furthermore I have expanded the way the program handles exisiting sheets. If one is found you can choose to continue with the rest of the cells or cancel the operation.
• Formula » Change reference style (e.g. A1 to $A,1 etc.)...
  Fixed a small bug. Your selected range wasn't properly renewed in the form when you started the utility, in stead it displayed the range you last used before.
• Fill » List filenames in folder...
  Fixed some bugs. In some occasions it didn't list all the files and it gave wrong file size information for files larget then 1.5 GB. The utility didn't work in Excel 2007, now it does.
• Fill » Add leading zeros...
  Fixed a bug that caused extra zeros if you ran the utility on the same numbers again.
• Object/comments » Select all objects
  Fixed a bug that sometime prevented it from selecting all objects/shapes
• Export » Export selection or active sheet as new file...
  Fixed a bug that prevented this utility from starting in Excel 2007
• Range » Paste special (with combinations)...
  Fixed some problems with the arethmetic operations in certain combinations.
• General
  Some minor bugfixes and spelling errors.