Default "empty comment" value for all users (AKA leave empty comments...empty)

[former_member244885]

From the user guide page 184:

The small red triangle does not appear in one of the following cases: the comment is empty; the comment consists in three dots (...); the comment consists in the characters entered in the Empty Comment area in

...and page 432:

optionName parameter	newValue parameter	Option Name and Path on the Interface
DefaultForEmptyComment	character string	User Options > Others > Empty Comment

Is there a way to set this default "Empty Comment" for all users, from the back end?

The system is saving every comment as '...' by default, which is a lot of unnecessary data for us.  I'd like to change this to '', or Don't save empty comments somehow.

Also on page 427

Option	sheetOption	Option	sheetOptionValue
Show as Excel Comment	11		TRUE or FALSE

What does this do exactly?

[former_member244885 · Accepted solution]

Thanks to my colleague Ian for finding this:

To disable the “…” automatically you need to add the following to a MODULE (not the workbook) vba for any workbook you choose

Function AFTER_WORKBOOK_OPEN()

    Dim EPMObj As New FPMXLClient.EPMAddInAutomation

    EPMObj.SetUserOption "DefaultForEmptyComment", ""

End Function

You must also reference the FPMXLClient from Tools>References