Office Integration

Enabling and disabling writeback mode

In Excel Integration, you can enable or disable writeback use globally, or for particular users, user groups, and application roles. Three options are available: Enable Writeback with splashing, Enable Writeback without splashing, and Disable Writeback. In the current release, configuration of writeback settings is done in the Custom Settings dashboard for the Excel Integration application by defining a new custom setting with the name WriteBackBehavior and entering the custom setting value in JSON format.

For example, to disable writeback globally, use this custom setting value:

{
   "D":"0"
}

If writeback configuration should be defined differently for certain users or application roles, use this format for the custom setting value definition:

{
   "D":"0",
   "Permissions":[
      {
         "ugo":[
            "UserName1",
            "UserName2",
            "ApplicationRole1",
            "ApplicationRole2"
         ],
         "v":"2"
      },
      {
         "ugo":[
            "UserName3",
            "UserName4",
            "ApplicationRole3"
         ],
         "v":"1"
      }
   ]
}

In the example above, users with the names UserName1, UserName2 or with the ApplicationRole1, ApplicationRole2 application roles can use writeback on base cells or on aggregated cells with splashing values. Users with the names UserName3, UserName4, or with the ApplicationRole3 application role, can use writeback but without the ability to splash values.

These are the values that can be used for the writeback definition:

• 0 – writeback disabled
• 1 – writeback enabled without splashing, writeback works on aggregated cells
• 2 – writeback enabled with splashing

See the "Excel Integration" section.