Post date: 21-May-2014 07:29:46
1. Activate Commenting option on View
2. Set AllowCommentsExplorer = True
3. Define CommentRanges
4. Follow settings below for CommentRanges defnition
5. Set up name range on template
NOTE:
KeyItem is the metadata of the comment. Use Excel formula to do this. For example the KeyItem formula for each row should be as follows:
6. Create Workbook Script follow settings below:
- 创建活动 BeforeCommentsSetup
- Under procedure OnBeforeCommentsSetup, add method EssbaseRetrieve