Advertisement
anaraxor

ASAP Utilities v5.0 Business Edition cracked full download

Apr 18th, 2013
4,348
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
ASP 5.09 KB | None | 0 0
  1.                                    ASAP Utilities v5.0 Business Edition
  2.  
  3.  
  4.  
  5.  
  6.  
  7.  
  8.  
  9.  
  10.            This is the full cracked version of the software. Download, extract, install, enjoy.
  11.     Inside the archive there is "crack" folder wich contains everything you need to crack the software.
  12.                                                 Download link:
  13.                                   https://safelinking.net/p/6f4a686e00
  14.  
  15.  
  16.  
  17.  
  18.  
  19.  
  20.  
  21.  
  22. Vision Control...
  23. Quickly navigate through your worksheets and change the way they are displayed.
  24. This tool shows the immediate result or your changes, for example if you uncheck the grid, you will see the effect immediately.
  25.  
  26. Worksheet settings:
  27. Gridlines
  28. Page breaks
  29. Row & column headers
  30. Zero values
  31. Formulas
  32. Outline symbols
  33. Zoom, you can use a slider to set the zoom percentage. As you slide you will immediately see the result.
  34. You can quickly apply the settings of the selected worksheets to all worksheets in your workbook.
  35.  
  36. Workbook settings:
  37. Sheet tabs
  38. Horizontal scroll bar
  39. Vertical scroll bar
  40. Reference style: A1 or R1C1
  41. Show objects: show all, show placeholders or hide all
  42.  
  43. Display settings for Excel on the application level:
  44. Formula bar
  45. Status bar
  46. Toolbars
  47. Full screen
  48. Comments: none, comment indicator only or comment & indicator
  49.  
  50. With this tool you can also:
  51. Browse through all open workbooks.
  52. Browse through the worksheets in your workbook and quickly see the settings per worksheet.
  53. Quickly change the way your worksheet, workbook or Excel is displayed.
  54. Remove the selection restrictions in all worksheets.
  55. Set the default folder to the path of the selected workbook. This causes the dialogs for opening and saving files to start in this folder the next time you use them.
  56. Reset the statusbar. Useful when the status bar is locked, for example with a certain message due to a macro that was not properly finished.
  57. Reset everything to default application settings. This will reset the statusbar, set the calculation to automatic, enable the display of alerts (Application.DisplayAlerts = True), set the cursor to default and enable all toolbars.
  58.  
  59. Formulas » Insert function from the ASAP Utilities library...
  60. With this utility you can insert a formula from the ASAP Utilities functions library into the active cell.
  61.  
  62. The ASAP Utilities functions library includes the following functions:
  63.  
  64. =ASAPCELLCOLORINDEX(cell)
  65. Returns the color index number of the cell.
  66. If you afterwards change the color in the cell, you have to press Control+Alt+F9 to have the formula recalculated.
  67. This function does not recognize formatting if it is applied via conditional formatting.
  68.  
  69. Parameters:
  70.  
  71.     cell = The cell to get Excel's number for the fill color from.
  72.  
  73.  
  74.  
  75. =ASAPCOUNTBYCELLCOLOR(reference, color_index_nr)
  76. Counts the number of cells in the given range that have a certain fill color.
  77. If you afterwards change the fill color in any of the referenced cells, you have to press Control+Alt+F9 to have the formulas recalculated.
  78. This function does not recognize formatting if it is applied via conditional formatting.
  79.  
  80. Parameters:
  81.  
  82.     reference = The range of cells to search in.
  83.  
  84.     color_index_nr = The cell that has the fill color to count, or the color index number (1-56) from Excel.
  85.  
  86.  
  87.  
  88. =ASAPCOUNTBYFONTCOLOR(reference, color_index_nr)
  89. Counts the number of cells in the given range that have a certain font color.
  90. If you afterwards change the font color in any of the referenced cells, you have to press Control+Alt+F9 to have the formulas recalculated.
  91. This function does not recognize formatting if it is applied via conditional formatting.
  92.  
  93. Parameters:
  94.  
  95.     reference = The range of cells to search in.
  96.  
  97.     color_index_nr = The cell that has the font color to count, or the color index number (1-56) from Excel.
  98.  
  99.  
  100.  
  101. =ASAPCOUNTCHAR(within_text, find_text)
  102. Counts the number of times a character occurs in a text
  103. This way you can for example count the number of commas in a cell. This function is case sensitive.
  104.  
  105. Parameters:
  106.  
  107.     within_text = The text containing the character you want to count.
  108.  
  109.     find_text = The character to count the occurences of. This has to be a single character.
  110.  
  111.  
  112.  
  113. =ASAPCOUNTSHADES(reference)
  114. Counts the number of colored cells in your range.
  115. If you afterwards change the fill color in any of the referenced cells, you have to press Control+Alt+F9 to have the formulas recalculated.
  116. This function does not recognize formatting if it is applied via conditional formatting.
  117.  
  118. Parameters:
  119.  
  120.     reference = The range of cells to count the number of cells that have a fill color.
  121.  
  122.  
  123.  
  124. =ASAPEXTRACTFILENAME(text, optional path_separator)
  125. Returns the file name from a full path and filename. By default the formula uses a backslash (\) as separator, but optionally you can specify another separator.
  126. For example =ASAPEXTRACTFILENAME("D:\Projects\Archive\Client 1\Balance.xls") returns "Balance.xls".
  127.  
  128. Parameters:
  129.  
  130.     text = The value or cell address from which you want to extract only the file name
  131.  
  132.     path_separator = The path separator. Optional, if omitted a backslash (\) is used.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement