Table 7. Spreadsheet Settings and Descriptions
Setting | Description |
|---|---|
| excel.contextmenu.editMembers.enabled | Enables or disables editing in the Excel context menu |
| error.dir=${interlace.home}/errors | Logs the errors in an errors directory |
| spreadsheet.display.options.max.formula.length=120 | Maximum characters to show a formula in a cell comment |
| spreadsheet.max.rows=10000 | Maximum rows that a zoom or search can display |
| spreadsheet.max.columns=256 | Maximum columns that a zoom or search can display |
| grid.max.exceptions=50 | Maximum rows to show introduced exceptions on scenario impact window |
| grid.max.exceptions.fixed=50 | Maximum rows to show fixed exceptions on scenario impact window |
| grid.max.data.changes=50 | Maximum rows on data change displays on impact window |