The XL3SetProperty formula updates the Anaplan XL workbook properties in the workbook.
For workbook-level properties, the object name refers to the area of the product being updated.
| Object Name | Property | Description | Value |
| WebPublication | One of the following option names: See Table below | Sets which options are permitted when published. | TRUE or FALSE |
| Writeback | SpreadMethod | Sets the formula spread method. | Valid values are "USE_EQUAL_ALLOCATION", "USE_EQUAL_INCREMENT", "USE_WEIGHTED_ALLOCATION", "USE_WEIGHTED_INCREMENT" |
| Writeback | Enabled | Sets whether formula writeback is enabled. | TRUE or FALSE |
Below refers to the webpublication properties for a workbook.
| Value | Description |
| SubmitChanges | Display Submit Changes |
| Allow printing | |
| SaveToExcel | Allow save to Excel |
| SaveToExcelActiveSheetOnly | Only allow active sheet to be saved to Excel |
| SaveToRepository | Allow save to repository |
| Refresh | Display Refresh button |
| ContextMenu | Enable Right-Click Menus |
| SaveParameters | Save Custom View |
| DrillMemberFormulae | Drill Formulae |
| EditMemberFormulae | Edit Member Formulae |
| AutoReloadOnExpiry | Auto reload |
| EditLockedXL3LookupRW | Edit XL3LookupRW without unlocking |
| OpenLinksInSameWindow | Open Links In Same Window |
| DundasChartRendering | Use V5 Chart Rendering |
| SaveToExcelLive | Allow save to Excel live |
| DeAutomaticChartSettingsOnPublish | Handle Excel chart styles |
| HideSheetTabsOnPublish | Hide Sheet Tabs |
| UseExcelValidation | Enforce Excel data validation rules |
| SubmitChangesOnCellBlur | Submit when value changes |
| OpenWebReportLinksInSameDiv | Open WebReportLinks in same div |
| ConvertShapesToImagesOnPublish | Convert shapes to images |
| UseRefreshOnDrivingCellChangeOnWeb | Use 'Refresh On Driving Cell Change' |
| WriteNbspInBlankCells | Write a space in blank cells |
