TM1 Tools add in releases
Posted: Sun Mar 14, 2010 9:56 pm
Below is the latest version of Martin, Steve and my add-in. This release includes the bulk paste tool, which will paste data in the clipboard into a range of DBR, DBRW and DBRA cells. It also includes the Hierarchy Documenter, and the various processes for converting formulas to values as well as the traditional KEY_ERR tracer.
Edit: Known Issues
- The group and outline feature of the Hierarchy Documenter can sometimes miss the last group. This isn't critical as the actual hierarchy data is correct, but will be fixed in a later release.
- The PDF document lacks some of the links found in the .chm help file. It will sometimes refer to things being found "here" where, in the .chm file, "here" would be a hyperlink. The references will be reworded in a later release.
- The Bulk Paste feature Does Not Like It if you've copied a range of blank cells and are trying to paste them into String cells to clear them. This is a fairly easy fix and will be taken care of in the next release. Actually I've identified a couple of issues when there are gaps in the source data, but they should all be fixed next time. Most of you probably won't come across them.
- The Bulk Paste Strings button has been incorrectly assigned the standard Bulk Paste function. That's already fixed in development.
- Ensure that your calculation mode is MANUAL when you use any of the Clear Formulas methods. The next version of the tool will set this temporarily to manual before it clears the formulas, then set it back when it's done. However you should avoid using Automatic calculation mode with TM1 anyway.
- Not so much an issue but a design modification; on some large sheets where you need to do multiple pastes, I've found the sheet recalc function which is done after each paste can be a pain. I'm therefore going to include an option to turn that off, allowing you to manually recalc the sheet / workbook when you're done.
- 14-Apr: The Bulk Copier does not seem to care for formatted numbers. This will be fixed in the next release. In the meantime, ensure that you strip the formatting off before you copy the data.
Bear in mind that the bulk of the Bulk Paste tool was put together in a few hours so yes, it may still have some issues. Feel free to post a modification request if you come across any.
Admin Edit:
This topic is locked for replying and will only be used for new releases. Please discuss problems and general use of the tool here.
Edit: Known Issues
- The group and outline feature of the Hierarchy Documenter can sometimes miss the last group. This isn't critical as the actual hierarchy data is correct, but will be fixed in a later release.
- The PDF document lacks some of the links found in the .chm help file. It will sometimes refer to things being found "here" where, in the .chm file, "here" would be a hyperlink. The references will be reworded in a later release.
- The Bulk Paste feature Does Not Like It if you've copied a range of blank cells and are trying to paste them into String cells to clear them. This is a fairly easy fix and will be taken care of in the next release. Actually I've identified a couple of issues when there are gaps in the source data, but they should all be fixed next time. Most of you probably won't come across them.
- The Bulk Paste Strings button has been incorrectly assigned the standard Bulk Paste function. That's already fixed in development.
- Ensure that your calculation mode is MANUAL when you use any of the Clear Formulas methods. The next version of the tool will set this temporarily to manual before it clears the formulas, then set it back when it's done. However you should avoid using Automatic calculation mode with TM1 anyway.
- Not so much an issue but a design modification; on some large sheets where you need to do multiple pastes, I've found the sheet recalc function which is done after each paste can be a pain. I'm therefore going to include an option to turn that off, allowing you to manually recalc the sheet / workbook when you're done.
- 14-Apr: The Bulk Copier does not seem to care for formatted numbers. This will be fixed in the next release. In the meantime, ensure that you strip the formatting off before you copy the data.
Bear in mind that the bulk of the Bulk Paste tool was put together in a few hours so yes, it may still have some issues. Feel free to post a modification request if you come across any.
Admin Edit:
This topic is locked for replying and will only be used for new releases. Please discuss problems and general use of the tool here.