Method: Reset for SubSheets
- Updated2024-09-12
- 1 minute(s) read
DIAdem REPORT > Methods > Method: Reset for SubSheets
Method: Reset for SubSheets
Resets the number of table sheets of an automatically increasing 2D table in DIAdem REPORT. DIAdem replots the report or calls the Recalculate for SubSheets method to recalculate the number of table sheets.
Object.Reset()
| Object | SubSheets Object with this method |
The following example creates an automatically increasing table. If the data was changed in the Data Portal, DIAdem specifies the number of table pages:
| VBScript | Python |
Dim oMy2DTable, oMyPosition, oMyIndexSettings, oMyColumn, oMySubSheets Call Report.NewLayout() Set oMy2DTable = Report.ActiveSheet.Objects.Add(eReportObject2DTable,"My2DTable") Set oMyPosition = oMy2DTable.Position.ByBorder oMyPosition.Top = 30 oMyPosition.Bottom = 20 oMyPosition.Left = 20 oMyPosition.Right = 30 Set oMyIndexSettings = oMy2DTable.Settings.IndexSettings oMyIndexSettings.IndexMode = e2DTableIndexModeAutomaticallyIncreasing Set oMyColumn = oMy2DTable.Columns.Add(e2DTableColumnChannel) oMyColumn.Channel.Reference = "[1]/[1]" Set oMyColumn = oMy2DTable.Columns.Add(e2DTableColumnChannel) oMyColumn.Channel.Reference = "[1]/[2]" Set oMySubSheets = Report.ActiveSheet.SubSheets If DataChanged Then oMySubSheets.Reset Call Report.Refresh()