Select » Conditional select cells... Added the option to select cells with a certain number format
Import » Insert (delimited) text file... Insert a (delimited) text file at the position of the selected cells. This new import utility has several options you can set but right now the main purpose is that the dates can be imported using your windows regional settings.
Fill » Insert current date and time with seconds Insert the current date and time into the active cell. Unlike Excel's built in shortcut "Control+:" this utility also inserts the seconds. (timestamp) By default this utility can be started with the shortcut Control+Shift+D
Fill » Insert current time with seconds Insert the current time into the active cell. Unlike Excel's built in shortcut "Control+;" this utility also inserts the seconds. (timestamp) By default this utility can be started with the shortcut Control+Shift+T
Export » Export selected chart or range as image (file)... New option to open the exported image in your default image-viewer immediately after the export. The default filename to save the image is now the name of the selected chart or the address of the selected range. The default proposed filename now contains the name of your workbook and the selected sheet. If you have chosen to export a range of cells instead of the entire sheet, the proposed filename also contains the address of your selection:
Sheets » Freeze panes on multiple sheets at once Freeze panes on all or all selected sheets at once, based on your current selection. Normally in Excel you can only do this one sheet at a time. With this utility you can now for example freeze the first row on all sheets at once.
Sheets » Unfreeze panes on multiple sheets at once Unfreeze panes on all or all selected sheets at once.
Bugs fixed
Format » The paper saver (split columns)... Fixed the error on start.
Fill » List filenames in folder... Error fixed when reading files from cd-rom or DVD (Last Accessed date not available).
Export » Export selection as HTML table to clipboard... Fixed 'Runtime error 91: Object variable or With block variable not set.
Numbers » Convert "textnumbers" to numbers Fixed a bug where fractions such as 1/2 were converted to dates. Fractions will now be detected and converted to fractions you can calculate with.
Export » Export selected chart or range as image (file)... Several minor improvements. Fixed the bug in combination with Excel 2007. The image quality however in Excel 2007, especially in combination with Windows Vista still needs some improvement compared to previous Excel version. I'm working on a solution for this.
Numbers » Round numbers (not formatting, but changing)... Fixed a bug that appears in combination with the Norwegian and Czech regional settings. Somehow Excel/ASAP Utilities didn't see the numbers as actual numbers and therefore the utility ignored them. (I could only reproduce this bug with these two regional language settings).
Improved worksheet functions ASAPSumByCellColor() ASAPCountByCellColor() ASAPSumByFontColor() ASAPCountByFontColor() If you work with more than 2 decimals the utility isn't 100% accurate after the fifth decimal of the result. This is corrected in this version. These functions can now use a cell-address to specify the color in stead of only using the colorindex. Furthermore the accuracy of these functions is improved. So for example if you have a range of cells with 10 green cells you want to sum you can use the formula either as =ASAPSumByCellColor(A1:E24;4) or if cell D4 contains the color you can use: =ASAPSumByCellColor(A1:E24;D4)
Improved the progress bar of the utilities
Small improvements in the "Organize your favorite tools..." utility