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

Date: July 19, 2007 (last updated on May 29, 2008)
reference id: QA0155

Finished

On September 24, 2007 the new version 4.2.0 is released. Download

I have changed the version number from 4.1 to 4.2 because the new version of ASAP Utilities is now nicely integrated into the Excel 2007 menu (ribbon).

Update information

At this moment there are a few known bugs in version 4.1.2
These have been fixed in version 4.2.0 which I'm currently developing and of which you can download a pre-release:
ASAPUtilities_setup_4-1-3-RC6.exe 1.8 MB (September 19, 2007)

Bugs fixed

  • Format » The paper saver (split columns)...
    Fixed the error on start.
    Error 401: Application-defined or object-defined error
    Error 401 Paper saver / split columns utility
  • 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 fuctions
    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-addres 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)
    Count or sum cells based on their color
  • Several minor bugfixes

New in this version

  • General
    ASAP Utilities ribbon tab in Excel 2007
    ASAP Utilities in the ribbon of Excel 2007, with black theme
  • Select » Conditional select cells...
    Added the option to select cells with a certain number format
    Added the options 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.
    new403_insert_delimited_text_file_menu.png
    new403_insert_delimited_text_file.png
  • 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
    Screenshot - Insert current date and time with seconds
  • 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
    Screenshot - Insert current time with seconds
  • 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.
    Screenshot - 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.
    Screenshot - 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: Export selection or active sheet as new file: default filename
  • 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.





« 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