ASAP Utilities

Now available: ASAP Utilities 4.2.8

by Bastien 12 Comment

Yesterday the new version of ASAP Utilities was officially released.
You can read the details in the newsletter or you can immediately proceed to the download page.

Besides several bugfixes, these are two new things:

Related Posts

12 comments

Kanwaljit

Hi Bastien,

May the couple live 1000 years !
Haven't you added the Insert->Function->Help option ?
Is it possible to embed the Asap in the file like Morefunc.xll

Regards
CA Kanwaljit Singh Dhunna
India

Kanwaljit

Hi Bastien,

May the couple live 1000 years !
Are you planning to make ASAP compatible with Open Office / Star Office

Regards
CA Kanwaljit Singh Dhunna
India

Bastien

Hello Kanwaljit,

May you live a 1000 years!

First thing, hasn't been done yet. For reasons I'll explain later.
You cannot embed ASAP Utilities into your file. If you use the worksheet functions from ASAP Utilities in your worksheet you will need ASAP Utilities in order to (re)calculate them.
//www.asap-utilities.com/asap-utilities-worksheet-functions.php#remarks-on-calculation

We do not have plans to make ASAP Utilities compatible with OpenOffice. At this moment Calc and the Open Office programming language differ to much from Excel to create a ASAP Utilities for Calc.
//www.asap-utilities.com/asap-utilities-worksheet-functions.php

Kind regards,
Bastien

Kanwaljit

Hi Bastien,

May the couple live 1000 years !
Thanks for the wish first of all. I wish you because I really want you to live. You are certainly donating some part of yours life to save time of others (which they must be spending on other useful tasks or with their family members like me). So I feel you must be compensated for that. So I wish May the couple Live 1000 years !

Ist thing. I will wait for it to happen. If morefunc.xll can do it, it must be donable with ASAP too.
You said "If we use the worksheet functions from ASAP Utilities in your worksheet you will need ASAP Utilities in order to (re)calculate them." Ditto ! That's for what I wish it to be embedded / embeddable in the Excel File. Because we embed Morefunc.xll in the excel file it helps to share the file without fearing about the #NAME error as the source of formulas is there. Have you Checked the Morefunc.xll

Regards
CA Kanwaljit Singh Dhunna
India

Kanwaljit

Hi Bastien,

May the couple Live 1000 years !

One more wish. Check out the "Watch Other Cells" Utility by Jan Karl. It is quite unique and useful. If something of this type can be accommodated in ASAP

Regards
CA Kanwaljit Singh Dhunna

Kanwaljit

Hi Bastien,

May the couple Live 1000 years !

Suggestions for enhancement.

1. "Delete leading, trailing and excessive spaces"
Should be amended to delete any character and not only the spaces. For example when we download bank statements from Net Banking, it usually contains a series of ********* or a series of ————— or ____________, but which are not required more than once or are not required at all. So here is my wish.
—A box for character / words to be deleted (User entry based)
—4 Check boxes for the user to select.
1 .Delete "Leading" and / or
2. Delete "Trailing" and / or
3. Delete "Excessive" (with an input box for what specified excessive with default value of more than 1 being treated as excessive
4. Delete "All" (Off course it will swich off all the above 3 optons)

Regards
CA Kanwaljit Singh Dhunna

Kanwaljit

Hi Bastien,

May the couple Live 1000 years !

Here again, one more wish !
(Oops ! I am wishing too much :)

Refers to "Delete all characters after nth character"
Some tweaks may enhance its usage.
1. "Delete all characters before the nth character from the last".
(Particularily useful when we have downloaded some data from net regarding banking transactions and the Instrument No column contains cheque nos like this.

1124588 / 0254688
122668 / 0254689
0307068845 / 0254690

Here the last "n" digits are same i.e., 7, whereas the succeeding digits are not uniform because they are other party's account number. So deleting all character before 7 last characters will do the job.

2. "Delete all characters before / after a particular character like "/" in the above example. That would help a lot

Regards
CA Kanwaljit Singh Dhunna

Bastien

Hello Kanwaljit,

Thank you for your ideas.
I have added them to the wishlist.

Kind regards,
Bastien

srimal47

hi…
does any one have ASAP utilities which can support for
openoffice.org Calc v2.4 or 3….?

else let me know Alternative solutions…….
many thanks..
:)

Derek

Thanks for this great add-in! I would like to see a continuous page numbering tool. I believe you mentioned that you were working on this previously.

Thanks again for a wonderful tool.

Derek

Bastien

Hello srimal47,

ASAP Utilities does not work with OpenOffice. I do not know of any add-ins for Calc at all.
More information:
//www.asap-utilities.com/faq-questions-answers-detail.php?m=106

Kind regards,
Bastien

Bastien

Hello Derek,

Continuous page numbering will be added to the batch sheet printing utility in version 4.3
//www.asap-utilities.com/asap-utilities-excel-tools-tip.php?tip=27&utilities=Sheets

If you want to have continuous numbering you can also select multiple sheets and then print it at once. Excel will then continue the page numbering throughout the sheets.

Kind regards,
Bastien