Start a new topic

EPM Add-In: Cannot use EPMSaveComment function with "Show as Excel Comments"

Symptom:

When the sheet option "Show as Microsoft excel comment" is checked, you input comments in a cell and use EPMSaveComment function to save data; however, the message "There is no data to save" occurs and the comments cannot be saved.


0428.PNG



Reproducing the Issue:

- Launch EPM add-in and click Sheet Options.
- Check Show as Excel Comments.
- Create a report and use EPMSaveComment function to retrieve comment from a cell.
- Input the comments in the cell and click Save Data.
- Message "There is no data to save" occurs and the comments cannot be saved.


Cause:

This is a designed behavior.


Resolution:

The "Show as Excel Comments" option enables you to display comments as standard Microsoft Office and the comments are displayed in a tooltip.

If you want to use EPMSaveComment to save comments with "Show as Excel Comments" checked, please input the comments in the tooltip.

If you want to input comments in a cell to save, please uncheck "Show as Excel Comments" option.

 
Login or Signup to post a comment