Specifies the behavior and options available in the report once published to Anaplan XL Web.
Specifies the behavior and options available in the report once published to Anaplan XL Web.
| Option | Description |
| Display Submit Changes | Controls display of Submit Changes toolbar button on Anaplan XL Web - default is Yes. |
| Allow Printing | Controls display of the Print toolbar button on Anaplan XL Web - default is Yes. |
| Allow save to Excel | Controls display of save to Excel on Anaplan XL Web - default is Yes. |
| Only allow save active sheet to Excel | Controls display of save to Excel on Anaplan XL Web. |
| Allow save to repository | Controls display of save to Repository on Anaplan XL Web - default is Yes. |
| Display Refresh button | Controls display of Refresh button on Anaplan XL Web - default is Yes. |
| Enable Right-Click Menus | Controls availability of right-click menus on Anaplan XL Web - default is Yes. |
| Save Custom View | Controls availability of save custom view on Anaplan XL Web. |
| Drill Formulae | Whether formulas can be drilled on Anaplan XL Web - default is No. |
| Edit Member Formulae | Whether XL3Member formulas can be edited on Anaplan XL Web - default is Yes. |
| Auto Refresh (minutes) | Sets an interval after which the published report will automatically refresh in the user's browser. |
| FluenceXLWeb download filename | Define the filename for the download to Excel/PDF, can also be defined in an Excel range. |
| Auto Reload | Whether the report auto-reloads if IIS has timed out due to inactivity - default is No. |
| Prefer aliased images | Avoid anti-aliasing images when publishing. |
| Auto-hide workbook slicer pane if no slicers available | Auto hide the workbook slicer pane if no slicers are available on current worksheet. |
| Use faster PDF generation | PDF generation will be faster, but some Excel features may not be supported. |
| Auto Reload | Whether the report auto-reloads if IIS has timed out due to inactivity - default is No. |
| Edit XL3LookupRW without unlocking | Enable LookupRW formulas for editing - default is No. |
| Open Links in same Window | Whether any XL3Link formulas to other websites or reports are opened in the same or different windows - default is Yes. |
| Use V5 Chart Rendering | For historical, this option allows charts to be rendered - default is No. |
| Allow save to Excel live | Whether the workbook can be saved as "Live" (for example, remain interactive) when downloading from the web - default is Yes. |
| Handle Excel chart styles | Whether Excel chart formatting is handled in a backwards-compatible way - default is Yes. |
| Hide Sheet Tabs | Option to hide sheet tabs when workbook is published - default is No. |
| Enforce Excel data validation rules | Whether Anaplan XL ensures data input follows data validation rules once published - default is No. |
| Submit when value changes | Automatically submits changes in unlocked cells - default is No. |
| Open WebReportLinks in same DivE | nables this for reports embedded in custom applications - default is No. |
| Convert shapes to images | Excel Shapes (for example, Callouts, Lines, etc.) are converted to images so that they can appear in the workbook when published. - default is No. |
| Use Refresh on Driving Cell Change | Controls whether a published report can ignore that grid property setting. |
| Write a space in blank cells | Writes a space in blank cells when report is published. |
| Use embedded workbook images | When on, the clipboard isn't used during publication. This can impact how some images/shapes appear in the published report. |
