SAP ABAP Class I_OI_SPREADSHEET (Spreadsheet Interface)
Properties
| Class | I_OI_SPREADSHEET | |
| Short Description | Spreadsheet Interface | |
| Super Class | ||
| Instantiability of a Class | 2 | Public |
| Final |
General Data
| Message Class | ||
| Program status | ||
| Category | 0 | |
| Package | ||
| Created | 19990216 | SAP |
| Last change | 19991216 | SAP |
| Shared Memory-enabled | ||
| Fixed point arithmetic | ||
| Unicode checks active |
Forward declarations
| # | Type group / Object type | Type | Type Description |
|---|---|---|---|
| 1 |  SOI |
Type group use (TYPE-POOLS tp) | Type group use (TYPE-POOLS tp) |
Interfaces
Class I_OI_SPREADSHEET has no interface implemented.
Friends
Class I_OI_SPREADSHEET has no friend class.
Attributes
| # | Attribute | Level | Visibility | Read only | Typing | Associated Type | Initial Value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SPREADSHEET_CLEAR |
Constant | Public | Type reference (TYPE) | SOI_BOOLEAN | '2' | Delete | 19990301 | |
| 2 | SPREADSHEET_COLUMNSHIDE |
Constant | Public | Type reference (TYPE) | SOI_BOOLEAN | '5' | Hide Columns | 19990301 | |
| 3 | SPREADSHEET_COLUMNSHOW |
Constant | Public | Type reference (TYPE) | SOI_BOOLEAN | '8' | Display Columns | 19990301 | |
| 4 | SPREADSHEET_INSERTALL |
Constant | Public | Type reference (TYPE) | SOI_BOOLEAN | '3' | Insert all Data | 19990310 | |
| 5 | SPREADSHEET_NEWRANGE |
Constant | Public | Type reference (TYPE) | SOI_BOOLEAN | '4' | Insert a New Range | 19990310 | |
| 6 | SPREADSHEET_PROTECT |
Constant | Public | Type reference (TYPE) | SOI_BOOLEAN | '1' | Protect a Range | 19990301 | |
| 7 | SPREADSHEET_ROWSHIDE |
Constant | Public | Type reference (TYPE) | SOI_BOOLEAN | '6' | Hide Rows | 19990301 | |
| 8 | SPREADSHEET_ROWSSHOW |
Constant | Public | Type reference (TYPE) | SOI_BOOLEAN | '9' | Hide Lines | 19990301 | |
| 9 | SPREADSHEET_UNPROTECT |
Constant | Public | Type reference (TYPE) | SOI_BOOLEAN | '7' | Remove Protection From a Range | 19990301 |
Methods
| # | Method | Level | Visibility | Method type | Description | Created on |
|---|---|---|---|---|---|---|
| 1 | ADD_SHEET |
Instance method | Public | Method | Inserts a Worksheet | 19990729 |
| 2 | ADD_STYLE |
Instance method | Public | Method | Add Styles | 20000313 |
| 3 | CELL_FORMAT |
Instance method | Public | Method | Sets Individual Cell Attributes | 19990729 |
| 4 | CHANGE_RANGE |
Instance method | Public | Method | Change Size or Name of an Area | 19990216 |
| 5 | CHANGE_STYLE |
Instance method | Public | Method | Change Styles | 20000222 |
| 6 | CLEAR_ALL_RANGES |
Instance method | Public | Method | Deletes the Contents and Formatting of the Ranges | 19990729 |
| 7 | CLEAR_CONTENT_RANGE |
Instance method | Public | Method | Delete Content of a Range | 20030415 |
| 8 | CLEAR_HIERARCHY |
Instance method | Public | Method | Delete Hierarchy | 19991012 |
| 9 | CLEAR_RANGE |
Instance method | Public | Method | Delete Content and Formatting of a Range | 19990310 |
| 10 | DELETE_CONTENT_RANGES |
Instance method | Public | Method | Deletes Ranges | 19990729 |
| 11 | DELETE_RANGES |
Instance method | Public | Method | Deletes Entire Ranges | 19990729 |
| 12 | DELETE_SHEET |
Instance method | Public | Method | Deletes a Worksheet | 19990729 |
| 13 | FIT_WIDEST |
Instance method | Public | Method | Adapt to Widest Column | 19990311 |
| 14 | GET_ACTIVE_SHEET |
Instance method | Public | Method | Get Active Worsheet | 19990310 |
| 15 | GET_CELL_FORMAT |
Instance method | Public | Method | Get Format of a Line | 19990217 |
| 16 | GET_CELL_FORMATS_TABLE |
Instance method | Public | Method | Gets Information about Cells | 19991012 |
| 17 | GET_DIMENSION |
Instance method | Public | Method | Get Dimensions of a Range | 19990310 |
| 18 | GET_DIMENSION_TABLE |
Instance method | Public | Method | Returns a Table Containing Ranges | 19991019 |
| 19 | GET_PROTECTION |
Instance method | Public | Method | Get Protected Attribute of a Worksheet | 19990310 |
| 20 | GET_RANGES_DATA |
Instance method | Public | Method | Get Name and Data for Range | 19990216 |
| 21 | GET_RANGES_NAMES |
Instance method | Public | Method | Get Name of a Range | 19990216 |
| 22 | GET_SELECTED_AREAS |
Instance method | Public | Method | Returns a Collection of Selected Ranges | 19990928 |
| 23 | GET_SELECTION |
Instance method | Public | Method | Get a Selection | 19990217 |
| 24 | GET_SHEETS |
Instance method | Public | Method | Get the Names of Worksheets | 19990223 |
| 25 | GET_STYLE |
Instance method | Public | Method | Read Style of an Area | 20000222 |
| 26 | GET_STYLE_FORMATS |
Instance method | Public | Method | Read All Style Names | 20000222 |
| 27 | HIDE_COLUMNS |
Instance method | Public | Method | Hide Columns | 19990310 |
| 28 | HIDE_ROWS |
Instance method | Public | Method | Hide Rows | 19990310 |
| 29 | INSERT_FULL |
Instance method | Public | Method | Inserst Values | 19990520 |
| 30 | INSERT_ONE_TABLE |
Instance method | Public | Method | Insert a Table | 19990216 |
| 31 | INSERT_RANGE |
Instance method | Public | Method | Insert a New Range | 19990216 |
| 32 | INSERT_RANGES |
Instance method | Public | Method | Inserts Several Ranges | 19990803 |
| 33 | INSERT_RANGE_DIM |
Instance method | Public | Method | Get a Range Based on its Dimensions | 19990310 |
| 34 | LOAD_LIB |
Instance method | Public | Method | Load DLL | 19991103 |
| 35 | PRINT |
Instance method | Public | Method | Print a Worksheet | 19990223 |
| 36 | PROTECT |
Instance method | Public | Method | Protect the Active Sheet | 19990219 |
| 37 | PROTECT_RANGE |
Instance method | Public | Method | Sets the Protected Attribute for a Range | 19990310 |
| 38 | SCREEN_UPDATE |
Instance method | Public | Method | Controls the Screen Update | 19990727 |
| 39 | SELECT_RANGE |
Instance method | Public | Method | Select a Range | 19990217 |
| 40 | SELECT_SHEET |
Instance method | Public | Method | Activate a Sheet | 19990217 |
| 41 | SETLOCALE |
Instance method | Public | Method | Sets the Date and Decimal Format | 19990901 |
| 42 | SET_COLOR |
Instance method | Public | Method | Set the Color of a Range | 19990217 |
| 43 | SET_DATA_TABLE |
Instance method | Public | Method | Sets the Data Table | 19990804 |
| 44 | SET_FIXED_COLS |
Instance method | Public | Method | Sets the Number of Fixed Columns | 19990901 |
| 45 | SET_FIXED_ROWS |
Instance method | Public | Method | Sets the Number of Fixed Rows | 19990901 |
| 46 | SET_FONT |
Instance method | Public | Method | Set the Font for a Range | 19990217 |
| 47 | SET_FORMAT |
Instance method | Public | Method | Set the Format of a Range | 19990217 |
| 48 | SET_FORMAT_STRING |
Instance method | Public | Method | Set the Format of a Range | 19990217 |
| 49 | SET_FRAME |
Instance method | Public | Method | Set a Frame for a Range | 19990217 |
| 50 | SET_HEADER |
Instance method | Public | Method | Sets a Header | 19991022 |
| 51 | SET_HIERARCHY |
Instance method | Public | Method | Sets Hierarchy | 19991012 |
| 52 | SET_HIERARCHY_TABLE |
Instance method | Public | Method | Sets the Hierarchies Using a Table | 19991124 |
| 53 | SET_INFO_TABLE |
Instance method | Public | Method | Sets the Info Table | 19990804 |
| 54 | SET_RANGES_DATA |
Instance method | Public | Method | Set the Data for a Range | 19990216 |
| 55 | SET_RANGES_FORMAT |
Instance method | Public | Method | Set the Format of a Range | 19990217 |
| 56 | SET_SELECTION |
Instance method | Public | Method | Set a Selection | 19990217 |
| 57 | SET_SHEET_NAME |
Instance method | Public | Method | Sets the Name of a Worksheet | 19990729 |
| 58 | SET_STYLE |
Instance method | Public | Method | Set Style | 20000222 |
| 59 | SET_ZOOM |
Instance method | Public | Method | Set the Zoom Factor | 19990315 |
| 60 | SHOW_COLUMNS |
Instance method | Public | Method | Display Columns | 19990310 |
| 61 | SHOW_ROWS |
Instance method | Public | Method | Display Rows | 19990310 |
| 62 | UPDATE_FRONTEND |
Instance method | Public | Method | Change the Excel View Based on Data and Info Table | 19990804 |
| 63 | VERSION |
Instance method | Public | Method | Returns the Version of the Spreadsheet Interface | 19991019 |
Events
Class I_OI_SPREADSHEET has no event.
Types
Class I_OI_SPREADSHEET has no local type.
Method Signatures
Method ADD_SHEET Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990729 | ||
| 2 |  Importing |
NAME | Call by reference | Type reference (TYPE) | C | Name des Arbeitsblattes | 19990729 | ||
| 3 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 19990729 | |
| 4 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19990729 |
Method ADD_SHEET on class I_OI_SPREADSHEET has no exception.
Method ADD_STYLE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 20000313 | ||
| 2 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 20000313 | |
| 3 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error? | 20000313 | ||
| 4 | Importing |
STYLES | Call by reference | Type reference (TYPE) | SOI_FORMAT_TABLE | Neue Formatvorlagen | 20000313 |
Method ADD_STYLE on class I_OI_SPREADSHEET has no exception.
Method CELL_FORMAT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
CELLS | Call by reference | Type reference (TYPE) | SOI_CELL_TABLE | Tabelle der Zellinformationen | 19990729 | ||
| 2 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990729 | ||
| 3 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 19990729 | |
| 4 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19990729 |
Method CELL_FORMAT on class I_OI_SPREADSHEET has no exception.
Method CHANGE_RANGE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
COLUMNS | Call by reference | Type reference (TYPE) | I | Columns of the range | 19990216 | ||
| 2 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | errors | 19990216 | ||
| 3 | Importing |
NEWNAME | Call by reference | Type reference (TYPE) | C | New name of the range | 19990216 | ||
| 4 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990216 | |
| 5 | Importing |
RANGENAME | Call by reference | Type reference (TYPE) | C | Name of the range | 19990216 | ||
| 6 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of the error | 19990216 | ||
| 7 | Importing |
ROWS | Call by reference | Type reference (TYPE) | I | Rows of the range | 19990216 | ||
| 8 | Importing |
UPDATING | Call by reference | Type reference (TYPE) | I | -1 | Screen updating | 19990726 |
Method CHANGE_RANGE on class I_OI_SPREADSHEET has no exception.
Method CHANGE_STYLE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 20000222 | ||
| 2 | Importing |
FORMAT | Call by reference | Type reference (TYPE) | SOI_FORMAT_TABLE | Formatierung der Styles | 20000222 | ||
| 3 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 20000222 | |
| 4 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 20000222 |
Method CHANGE_STYLE on class I_OI_SPREADSHEET has no exception.
Method CLEAR_ALL_RANGES Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990729 | ||
| 2 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 19990729 | |
| 3 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19990729 |
Method CLEAR_ALL_RANGES on class I_OI_SPREADSHEET has no exception.
Method CLEAR_CONTENT_RANGE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 20030415 | ||
| 2 | Importing |
NAME | Call by reference | Type reference (TYPE) | C | Name des Bereiches | 20030415 | ||
| 3 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 20030415 | |
| 4 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text | 20030415 |
Method CLEAR_CONTENT_RANGE on class I_OI_SPREADSHEET has no exception.
Method CLEAR_HIERARCHY Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19991012 | ||
| 2 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 19991012 | |
| 3 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19991012 |
Method CLEAR_HIERARCHY on class I_OI_SPREADSHEET has no exception.
Method CLEAR_RANGE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990310 | ||
| 2 | Importing |
NAME | Call by reference | Type reference (TYPE) | C | Name des Bereiches | 19990310 | ||
| 3 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990310 | |
| 4 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text | 19990310 |
Method CLEAR_RANGE on class I_OI_SPREADSHEET has no exception.
Method DELETE_CONTENT_RANGES Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990729 | ||
| 2 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 19990729 | |
| 3 | Importing |
RANGES | Call by reference | Type reference (TYPE) | SOI_RANGE_LIST | Liste der Bereiche | 19990729 | ||
| 4 | Importing |
RANGESDEF | Call by reference | Type reference (TYPE) | SOI_DIMENSION_TABLE | Definition von Bereichen | 19991025 | ||
| 5 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19990729 |
Method DELETE_CONTENT_RANGES on class I_OI_SPREADSHEET has no exception.
Method DELETE_RANGES Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990729 | ||
| 2 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush | 19990729 | |
| 3 | Importing |
RANGES | Call by reference | Type reference (TYPE) | SOI_RANGE_LIST | Liste der Bereiche | 19990729 | ||
| 4 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19990729 |
Method DELETE_RANGES on class I_OI_SPREADSHEET has no exception.
Method DELETE_SHEET Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990729 | ||
| 2 | Importing |
NAME | Call by reference | Type reference (TYPE) | C | Name des Arbeitsblattes | 19990729 | ||
| 3 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 19990729 | |
| 4 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text_of_error | 19990729 |
Method DELETE_SHEET on class I_OI_SPREADSHEET has no exception.
Method FIT_WIDEST Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990311 | ||
| 2 | Importing |
NAME | Call by reference | Type reference (TYPE) | C | Name des Bereichs | 19990311 | ||
| 3 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990311 | |
| 4 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text | 19990311 |
Method FIT_WIDEST on class I_OI_SPREADSHEET has no exception.
Method GET_ACTIVE_SHEET Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990310 | ||
| 2 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990310 | |
| 3 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text | 19990310 | ||
| 4 | Exporting |
SHEETNAME | Call by reference | Type reference (TYPE) | C | Name des Arbeitsblattes | 19990310 |
Method GET_ACTIVE_SHEET on class I_OI_SPREADSHEET has no exception.
Method GET_CELL_FORMAT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
COLUMN | Call by reference | Type reference (TYPE) | I | Spalte | 19990217 | ||
| 2 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990217 | ||
| 3 | Exporting |
FORMAT | Call by reference | Type reference (TYPE) | SOI_FORMAT_ITEM | Format der Zelle | 19990217 | ||
| 4 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990217 | |
| 5 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19990217 | ||
| 6 | Importing |
ROW | Call by reference | Type reference (TYPE) | I | Zeile | 19990217 | ||
| 7 | Importing |
UPDATING | Call by reference | Type reference (TYPE) | I | -1 | screen updating | 19990726 |
Method GET_CELL_FORMAT on class I_OI_SPREADSHEET has no exception.
Method GET_CELL_FORMATS_TABLE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19991012 | ||
| 2 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 19991012 | |
| 3 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19991012 | ||
| 4 |  Changing |
TABLE | Call by reference | Type reference (TYPE) | SOI_CELL_TABLE | Formatinformationen einzelner Zellen | 19991012 |
Method GET_CELL_FORMATS_TABLE on class I_OI_SPREADSHEET has no exception.
Method GET_DIMENSION Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
COLUMNS | Call by reference | Type reference (TYPE) | I | Spalten | 19990310 | ||
| 2 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | errors? | 19990310 | ||
| 3 | Exporting |
LEFT | Call by reference | Type reference (TYPE) | I | Linke obere Ecke | 19990310 | ||
| 4 | Importing |
NAME | Call by reference | Type reference (TYPE) | C | Name des Bereiches | 19990310 | ||
| 5 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990310 | |
| 6 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text | 19990310 | ||
| 7 | Exporting |
ROWS | Call by reference | Type reference (TYPE) | I | Zeilen | 19990310 | ||
| 8 | Exporting |
TOP | Call by reference | Type reference (TYPE) | I | Linke obere Ecke | 19990310 |
Method GET_DIMENSION on class I_OI_SPREADSHEET has no exception.
Method GET_DIMENSION_TABLE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error | 19991019 | ||
| 2 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 19991019 | |
| 3 | Changing |
RANGES | Call by reference | Type reference (TYPE) | SOI_FULL_RANGE_TABLE | Dimensionen von Bereichen | 19991019 | ||
| 4 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19991019 |
Method GET_DIMENSION_TABLE on class I_OI_SPREADSHEET has no exception.
Method GET_PROTECTION Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990310 | ||
| 2 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990310 | |
| 3 | Exporting |
PROTECT | Call by reference | Type reference (TYPE) | C | Schutz | 19990310 | ||
| 4 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text | 19990310 | ||
| 5 | Importing |
SHEETNAME | Call by reference | Type reference (TYPE) | C | Name des Arbeitsblattes | 19990310 |
Method GET_PROTECTION on class I_OI_SPREADSHEET has no exception.
Method GET_RANGES_DATA Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
ALL | Call by reference | Type reference (TYPE) | C | '' | Get all ranges? | 19990216 | |
| 2 | Exporting |
CONTENTS | Call by reference | Type reference (TYPE) | SOI_GENERIC_TABLE | Contents of the tables | 19990216 | ||
| 3 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | errors? | 19990216 | ||
| 4 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990216 | |
| 5 | Changing |
RANGES | Call by reference | Type reference (TYPE) | SOI_RANGE_LIST | Specified ranges | 19990216 | ||
| 6 | Importing |
RANGESDEF | Call by reference | Type reference (TYPE) | SOI_DIMENSION_TABLE | Ranges in the sheet | 19991019 | ||
| 7 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of the error | 19990216 | ||
| 8 | Importing |
UPDATING | Call by reference | Type reference (TYPE) | I | -1 | Screen updating | 19990726 |
Method GET_RANGES_DATA on class I_OI_SPREADSHEET has no exception.
Method GET_RANGES_NAMES Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990216 | ||
| 2 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990216 | |
| 3 | Exporting |
RANGES | Call by reference | Type reference (TYPE) | SOI_RANGE_LIST | Names of the ranges | 19990216 | ||
| 4 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of the error | 19990216 | ||
| 5 | Importing |
UPDATING | Call by reference | Type reference (TYPE) | I | -1 | Screen updating | 19990726 |
Method GET_RANGES_NAMES on class I_OI_SPREADSHEET has no exception.
Method GET_SELECTED_AREAS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
AREAS | Call by reference | Type reference (TYPE) | SOI_AREA_TABLE | Tabelle der Bereiche | 19990928 | ||
| 2 | Exporting |
COLUMNSID | Call by reference | Type reference (TYPE) | SOI_MAP_TABLE | IDs zu den Spalten | 19990928 | ||
| 3 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990928 | ||
| 4 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 19990928 | |
| 5 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19990928 | ||
| 6 | Exporting |
ROWSID | Call by reference | Type reference (TYPE) | SOI_MAP_TABLE | IDs zu den Zeilen | 19990928 |
Method GET_SELECTED_AREAS on class I_OI_SPREADSHEET has no exception.
Method GET_SELECTION Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
COLUMNS | Call by reference | Type reference (TYPE) | I | Spalten | 19990217 | ||
| 2 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990217 | ||
| 3 | Exporting |
LEFT | Call by reference | Type reference (TYPE) | I | Spalte der linken oberen Zelle | 19990301 | ||
| 4 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990217 | |
| 5 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19990217 | ||
| 6 | Exporting |
ROWS | Call by reference | Type reference (TYPE) | I | Zeilen | 19990217 | ||
| 7 | Exporting |
TOP | Call by reference | Type reference (TYPE) | I | Zeile der linken oberen Zelle | 19990301 | ||
| 8 | Importing |
UPDATING | Call by reference | Type reference (TYPE) | I | -1 | Screen updating | 19990726 |
Method GET_SELECTION on class I_OI_SPREADSHEET has no exception.
Method GET_SHEETS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990223 | ||
| 2 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990223 | |
| 3 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19990223 | ||
| 4 | Exporting |
SHEETS | Call by reference | Type reference (TYPE) | SOI_SHEETS_TABLE | Namen der Arbeitsblätter | 19990223 | ||
| 5 | Importing |
UPDATING | Call by reference | Type reference (TYPE) | I | -1 | Screen updating | 19990726 |
Method GET_SHEETS on class I_OI_SPREADSHEET has no exception.
Method GET_STYLE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 20000222 | ||
| 2 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 20000222 | |
| 3 | Changing |
RANGES | Call by reference | Type reference (TYPE) | SOI_STYLE_TABLE | Bereichsdefinitionen | 20000222 | ||
| 4 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 20000222 |
Method GET_STYLE on class I_OI_SPREADSHEET has no exception.
Method GET_STYLE_FORMATS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 20000222 | ||
| 2 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 20000222 | |
| 3 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 20000222 | ||
| 4 | Changing |
TABLE | Call by reference | Type reference (TYPE) | SOI_FORMAT_TABLE | Bereiche und Styles | 20000222 |
Method GET_STYLE_FORMATS on class I_OI_SPREADSHEET has no exception.
Method HIDE_COLUMNS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990310 | ||
| 2 | Importing |
FIRST | Call by reference | Type reference (TYPE) | I | Erste Spalte | 19991029 | ||
| 3 | Importing |
LAST | Call by reference | Type reference (TYPE) | I | Zweite Spalte | 19991029 | ||
| 4 | Importing |
NAME | Call by reference | Type reference (TYPE) | C | Name des Bereiches | 19990310 | ||
| 5 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990310 | |
| 6 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text | 19990310 |
Method HIDE_COLUMNS on class I_OI_SPREADSHEET has no exception.
Method HIDE_ROWS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990310 | ||
| 2 | Importing |
NAME | Call by reference | Type reference (TYPE) | C | Name des Bereiches | 19990310 | ||
| 3 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990310 | |
| 4 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text | 19990310 |
Method HIDE_ROWS on class I_OI_SPREADSHEET has no exception.
Method INSERT_FULL Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
DATA | Call by reference | Type reference (TYPE) | TABLE | Daten | 19990520 | ||
| 2 | Importing |
DATA_ENDING_AT | Call by reference | Type reference (TYPE) | I | -1 | Ende der Daten | 19990521 | |
| 3 | Importing |
DATA_STARTING_AT | Call by reference | Type reference (TYPE) | I | 1 | Start der Daten | 19990521 | |
| 4 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990520 | ||
| 5 | Importing |
FILENAME | Call by reference | Type reference (TYPE) | C | Dateiname | 19990611 | ||
| 6 | Importing |
HEADER_1 | Call by reference | Type reference (TYPE) | C | Titelzeile | 19990611 | ||
| 7 | Importing |
HEADER_2 | Call by reference | Type reference (TYPE) | C | Untertitel | 19990611 | ||
| 8 | Importing |
HKEY | Call by reference | Type reference (TYPE) | SOI_HKEY_TABLE | Horizontale Einträge | 19990520 | ||
| 9 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 19990520 | |
| 10 | Importing |
N_ATT_COLS | Call by reference | Type reference (TYPE) | I | Anzahl Datenspalten im Listobjekt | 19990611 | ||
| 11 | Importing |
N_HRZ_KEYS | Call by reference | Type reference (TYPE) | I | Anzahl H-Merkmale | 19990611 | ||
| 12 | Importing |
N_VRT_KEYS | Call by reference | Type reference (TYPE) | I | Anzahl V-Merkmale | 19990611 | ||
| 13 | Importing |
ONLINE_TEXT | Call by reference | Type reference (TYPE) | SOI_ONLINE_TABLE | Onlinetexte | 19990610 | ||
| 14 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error? | 19990520 | ||
| 15 | Importing |
SEMA | Call by reference | Type reference (TYPE) | SOI_SEMA_TABLE | Semantik | 19990520 | ||
| 16 | Importing |
SEMA_TYPE | Call by reference | Type reference (TYPE) | C | '' | Schalter für Stringkonvertierungen | 19990611 | |
| 17 | Importing |
VKEY | Call by reference | Type reference (TYPE) | SOI_VKEY_TABLE | Vertikale Einträge | 19990520 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 |  DIM_MISMATCH_DATA |
nicht vorhandene DATA-Spalte wird referenziert | 19990611 | |
| 2 | DIM_MISMATCH_SEMA |
Anzahl SEMA-Zeilen <> N_VRT_KEYS + N_ATT_COLS | 19990611 | |
| 3 | DIM_MISMATCH_VKEY |
Anzahl VKEY-Zeilen <> N_VRT_KEYS | 19990611 | |
| 4 | ERROR_IN_HKEY |
siehe Dokumentation | 19990611 | |
| 5 | ERROR_IN_SEMA |
Fehler in Semantikbeschreibung | 19990622 | |
| 6 | ERROR_IN_VKEY |
siehe Dokumentation | 19990611 | |
| 7 | INV_DATA_RANGE |
DATEN_VON / DATEN_BIS zu groß / zu klein | 19990611 |
Method INSERT_ONE_TABLE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
DATA_TABLE | Call by reference | Type reference (TYPE) | TABLE | Data | 19990216 | ||
| 2 | Importing |
DDIC_NAME | Call by reference | Type reference (TYPE) | X030L-TABNAME | Name of a table of the data dictionary | 19990216 | ||
| 3 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | errors? | 19990216 | ||
| 4 | Importing |
FIELDS_TABLE | Call by reference | Type reference (TYPE) | SOI_FIELDS_TABLE | The fields of the table | 19990216 | ||
| 5 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990216 | |
| 6 | Importing |
RANGENAME | Call by reference | Type reference (TYPE) | C | The name of the range | 19990216 | ||
| 7 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of the error | 19990216 | ||
| 8 | Importing |
UPDATING | Call by reference | Type reference (TYPE) | I | -1 | Screen updating | 19990726 | |
| 9 | Importing |
WHOLETABLE | Call by reference | Type reference (TYPE) | C | '' | Inserts the whole table? | 19990216 |
Method INSERT_ONE_TABLE on class I_OI_SPREADSHEET has no exception.
Method INSERT_RANGE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
COLUMNS | Call by reference | Type reference (TYPE) | I | number of columns | 19990216 | ||
| 2 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | errors | 19990216 | ||
| 3 | Importing |
NAME | Call by reference | Type reference (TYPE) | C | Name of the range | 19990216 | ||
| 4 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990216 | |
| 5 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of the error | 19990216 | ||
| 6 | Importing |
ROWS | Call by reference | Type reference (TYPE) | I | number of rows | 19990216 | ||
| 7 | Importing |
UPDATING | Call by reference | Type reference (TYPE) | I | -1 | Screen updating | 19990726 |
Method INSERT_RANGE on class I_OI_SPREADSHEET has no exception.
Method INSERT_RANGES Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990803 | ||
| 2 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 19990803 | |
| 3 | Importing |
RANGES | Call by reference | Type reference (TYPE) | SOI_FULL_RANGE_TABLE | Tabelle der einzufügenden Bereiche | 19990803 | ||
| 4 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19990803 |
Method INSERT_RANGES on class I_OI_SPREADSHEET has no exception.
Method INSERT_RANGE_DIM Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
COLUMNS | Call by reference | Type reference (TYPE) | I | Spalten | 19990310 | ||
| 2 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | errors? | 19990310 | ||
| 3 | Importing |
LEFT | Call by reference | Type reference (TYPE) | I | Linke obere Ecke | 19990310 | ||
| 4 | Importing |
NAME | Call by reference | Type reference (TYPE) | C | Name des Bereiches | 19990310 | ||
| 5 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990310 | |
| 6 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text | 19990310 | ||
| 7 | Importing |
ROWS | Call by reference | Type reference (TYPE) | I | Zeilen | 19990310 | ||
| 8 | Importing |
SHEETNAME | Call by reference | Type reference (TYPE) | C | '' | Name des Arbeitsblattes | 19990729 | |
| 9 | Importing |
TOP | Call by reference | Type reference (TYPE) | I | Linke obere Ecke | 19990310 | ||
| 10 | Importing |
UPDATING | Call by reference | Type reference (TYPE) | I | -1 | Screen updating | 19990726 |
Method INSERT_RANGE_DIM on class I_OI_SPREADSHEET has no exception.
Method LOAD_LIB Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19991103 | ||
| 2 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 19991103 | |
| 3 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19991103 |
Method LOAD_LIB on class I_OI_SPREADSHEET has no exception.
Method PRINT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990223 | ||
| 2 | Importing |
NAME | Call by reference | Type reference (TYPE) | C | Name des Arbeitsblattes | 19990223 | ||
| 3 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990223 | |
| 4 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19990223 |
Method PRINT on class I_OI_SPREADSHEET has no exception.
Method PROTECT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990219 | ||
| 2 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush | 19990219 | |
| 3 | Importing |
PROTECT | Call by reference | Type reference (TYPE) | C | Protect? | 19990219 | ||
| 4 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19990219 |
Method PROTECT on class I_OI_SPREADSHEET has no exception.
Method PROTECT_RANGE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990310 | ||
| 2 | Importing |
NAME | Call by reference | Type reference (TYPE) | C | Name des Bereiches | 19990310 | ||
| 3 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush | 19990310 | |
| 4 | Importing |
PROTECT | Call by reference | Type reference (TYPE) | C | Flag, ob Bereich geschützt | 19990310 | ||
| 5 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text | 19990310 |
Method PROTECT_RANGE on class I_OI_SPREADSHEET has no exception.
Method SCREEN_UPDATE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990727 | ||
| 2 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 19990727 | |
| 3 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text | 19990727 | ||
| 4 | Importing |
UPDATING | Call by reference | Type reference (TYPE) | C | Screen update | 19990727 |
Method SCREEN_UPDATE on class I_OI_SPREADSHEET has no exception.
Method SELECT_RANGE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990217 | ||
| 2 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990217 | |
| 3 | Importing |
RANGENAME | Call by reference | Type reference (TYPE) | C | Name des Ranges | 19990217 | ||
| 4 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19990217 |
Method SELECT_RANGE on class I_OI_SPREADSHEET has no exception.
Method SELECT_SHEET Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990217 | ||
| 2 | Importing |
NAME | Call by reference | Type reference (TYPE) | C | Name des Arbeitsblattes | 19990217 | ||
| 3 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990217 | |
| 4 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19990217 |
Method SELECT_SHEET on class I_OI_SPREADSHEET has no exception.
Method SETLOCALE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990901 | ||
| 2 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 19990901 | |
| 3 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19990901 |
Method SETLOCALE on class I_OI_SPREADSHEET has no exception.
Method SET_COLOR Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
BACK | Call by reference | Type reference (TYPE) | I | Hintergrundfarbe | 19990616 | ||
| 2 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990217 | ||
| 3 | Importing |
FRONT | Call by reference | Type reference (TYPE) | I | Vordergrundfarbe | 19990616 | ||
| 4 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990217 | |
| 5 | Importing |
RANGENAME | Call by reference | Type reference (TYPE) | C | Name des Ranges | 19990217 | ||
| 6 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19990217 |
Method SET_COLOR on class I_OI_SPREADSHEET has no exception.
Method SET_DATA_TABLE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
DATA_TABLE | Call by reference | Type reference (TYPE) | LVC_T_DATA | Datentabelle | 19990804 | ||
| 2 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error | 19990804 | ||
| 3 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 19990804 | |
| 4 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19990804 |
Method SET_DATA_TABLE on class I_OI_SPREADSHEET has no exception.
Method SET_FIXED_COLS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
COLUMNS | Call by reference | Type reference (TYPE) | I | Zahl der fixierten Spalten | 19990901 | ||
| 2 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990901 | ||
| 3 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 19990901 | |
| 4 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of the error | 19990901 |
Method SET_FIXED_COLS on class I_OI_SPREADSHEET has no exception.
Method SET_FIXED_ROWS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990901 | ||
| 2 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 19990901 | |
| 3 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19990901 | ||
| 4 | Importing |
ROWS | Call by reference | Type reference (TYPE) | I | Zahl der fixierten Zeilen | 19990901 |
Method SET_FIXED_ROWS on class I_OI_SPREADSHEET has no exception.
Method SET_FONT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
ALIGN | Call by reference | Type reference (TYPE) | I | Ausrichtung | 19990217 | ||
| 2 | Importing |
BOLD | Call by reference | Type reference (TYPE) | I | Fett? | 19990217 | ||
| 3 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990217 | ||
| 4 | Importing |
FAMILY | Call by reference | Type reference (TYPE) | C | Schriftfamilie | 19990217 | ||
| 5 | Importing |
ITALIC | Call by reference | Type reference (TYPE) | I | Kursiv? | 19990217 | ||
| 6 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990217 | |
| 7 | Importing |
RANGENAME | Call by reference | Type reference (TYPE) | C | Name des Ranges | 19990217 | ||
| 8 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19990217 | ||
| 9 | Importing |
SIZE | Call by reference | Type reference (TYPE) | I | Schriftgröße | 19990217 |
Method SET_FONT on class I_OI_SPREADSHEET has no exception.
Method SET_FORMAT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
CURRENCY | Call by reference | Type reference (TYPE) | C | Wert des Formats | 19990222 | ||
| 2 | Importing |
DECIMALS | Call by reference | Type reference (TYPE) | I | -1 | Dezimalstellen | 19990525 | |
| 3 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990217 | ||
| 4 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush | 19990217 | |
| 5 | Importing |
RANGENAME | Call by reference | Type reference (TYPE) | C | Name des Ranges | 19990217 | ||
| 6 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19990217 | ||
| 7 | Importing |
TYP | Call by reference | Type reference (TYPE) | I | Art des Formats | 19990217 |
Method SET_FORMAT on class I_OI_SPREADSHEET has no exception.
Method SET_FORMAT_STRING Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990217 | ||
| 2 | Importing |
FORMATSTRING | Call by reference | Type reference (TYPE) | C | formatstring | 19990217 | ||
| 3 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990217 | |
| 4 | Importing |
RANGENAME | Call by reference | Type reference (TYPE) | C | Name des Ranges | 19990217 | ||
| 5 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19990217 |
Method SET_FORMAT_STRING on class I_OI_SPREADSHEET has no exception.
Method SET_FRAME Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
COLOR | Call by reference | Type reference (TYPE) | I | Farbe des Rahmens | 19990217 | ||
| 2 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990217 | ||
| 3 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990217 | |
| 4 | Importing |
RANGENAME | Call by reference | Type reference (TYPE) | C | Name des Ranges | 19990217 | ||
| 5 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19990217 | ||
| 6 | Importing |
TYP | Call by reference | Type reference (TYPE) | I | Art des Rahmens | 19990217 |
Method SET_FRAME on class I_OI_SPREADSHEET has no exception.
Method SET_HEADER Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19991022 | ||
| 2 | Importing |
HEADER | Call by reference | Type reference (TYPE) | SOI_HEAD_TABLE | Header | 19991022 | ||
| 3 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 19991022 | |
| 4 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19991022 |
Method SET_HEADER on class I_OI_SPREADSHEET has no exception.
Method SET_HIERARCHY Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19991012 | ||
| 2 | Importing |
FIRSTLINE | Call by reference | Type reference (TYPE) | I | Erste Zeile | 19991012 | ||
| 3 | Importing |
LENGTH | Call by reference | Type reference (TYPE) | I | Länge des Bereiches | 19991012 | ||
| 4 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 19991012 | |
| 5 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19991012 |
Method SET_HIERARCHY on class I_OI_SPREADSHEET has no exception.
Method SET_HIERARCHY_TABLE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19991124 | ||
| 2 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 19991124 | |
| 3 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19991124 | ||
| 4 | Importing |
TABLE | Call by reference | Type reference (TYPE) | SOI_HIERARCHY_TABLE | Tabelle der Hierarchien | 19991124 |
Method SET_HIERARCHY_TABLE on class I_OI_SPREADSHEET has no exception.
Method SET_INFO_TABLE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error | 19990804 | ||
| 2 | Changing |
INFO_TABLE | Call by reference | Type reference (TYPE) | LVC_T_INFO | Infotabelle | 19990804 | ||
| 3 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 19990804 | |
| 4 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19990804 |
Method SET_INFO_TABLE on class I_OI_SPREADSHEET has no exception.
Method SET_RANGES_DATA Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
CONTENTS | Call by reference | Type reference (TYPE) | SOI_GENERIC_TABLE | Contents of the ranges | 19990216 | ||
| 2 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | errors? | 19990216 | ||
| 3 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990216 | |
| 4 | Importing |
RANGES | Call by reference | Type reference (TYPE) | SOI_RANGE_LIST | Ranges in the sheet | 19990216 | ||
| 5 | Importing |
RANGESDEF | Call by reference | Type reference (TYPE) | SOI_DIMENSION_TABLE | Ranges in the sheet | 19991019 | ||
| 6 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of the error | 19990216 | ||
| 7 | Importing |
UPDATING | Call by reference | Type reference (TYPE) | I | -1 | Screen updating | 19990726 |
Method SET_RANGES_DATA on class I_OI_SPREADSHEET has no exception.
Method SET_RANGES_FORMAT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990217 | ||
| 2 | Importing |
FORMATTABLE | Call by reference | Type reference (TYPE) | SOI_FORMAT_TABLE | Formatierungen der Bereiche | 19990217 | ||
| 3 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990217 | |
| 4 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19990217 | ||
| 5 | Importing |
UPDATING | Call by reference | Type reference (TYPE) | I | -1 | Screen updating | 19990726 |
Method SET_RANGES_FORMAT on class I_OI_SPREADSHEET has no exception.
Method SET_SELECTION Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
COLUMNS | Call by reference | Type reference (TYPE) | I | Spalten | 19990217 | ||
| 2 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990217 | ||
| 3 | Importing |
LEFT | Call by reference | Type reference (TYPE) | I | Zeile der linken oberen Zelle | 19990217 | ||
| 4 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990217 | |
| 5 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19990217 | ||
| 6 | Importing |
ROWS | Call by reference | Type reference (TYPE) | I | Zeilen | 19990217 | ||
| 7 | Importing |
TOP | Call by reference | Type reference (TYPE) | I | Spalte der linken oberen Zelle | 19990301 | ||
| 8 | Importing |
UPDATING | Call by reference | Type reference (TYPE) | I | -1 | Screen updating | 19990726 |
Method SET_SELECTION on class I_OI_SPREADSHEET has no exception.
Method SET_SHEET_NAME Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990729 | ||
| 2 | Importing |
NEWNAME | Call by reference | Type reference (TYPE) | C | Neuer Name des Arbeitsblattes | 19990729 | ||
| 3 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 19990729 | |
| 4 | Importing |
OLDNAME | Call by reference | Type reference (TYPE) | C | '' | Alter Name des Arbeitsblattes | 19990729 | |
| 5 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19990729 |
Method SET_SHEET_NAME on class I_OI_SPREADSHEET has no exception.
Method SET_STYLE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 20000222 | ||
| 2 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 20000222 | |
| 3 | Importing |
RANGES | Call by reference | Type reference (TYPE) | SOI_STYLE_TABLE | Bereichsnamen | 20000222 | ||
| 4 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 20000222 |
Method SET_STYLE on class I_OI_SPREADSHEET has no exception.
Method SET_ZOOM Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990315 | ||
| 2 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990315 | |
| 3 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text | 19990315 | ||
| 4 | Importing |
ZOOM | Call by reference | Type reference (TYPE) | I | Zoomfaktor | 19990315 |
Method SET_ZOOM on class I_OI_SPREADSHEET has no exception.
Method SHOW_COLUMNS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990310 | ||
| 2 | Importing |
FIRST | Call by reference | Type reference (TYPE) | I | Erste Zeile | 19991029 | ||
| 3 | Importing |
LAST | Call by reference | Type reference (TYPE) | I | Zweite Zeile | 19991029 | ||
| 4 | Importing |
NAME | Call by reference | Type reference (TYPE) | C | Name des Bereiches | 19990310 | ||
| 5 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990310 | |
| 6 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text | 19990310 |
Method SHOW_COLUMNS on class I_OI_SPREADSHEET has no exception.
Method SHOW_ROWS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19990310 | ||
| 2 | Importing |
NAME | Call by reference | Type reference (TYPE) | C | Name des Bereiches | 19990310 | ||
| 3 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | ' ' | flush? | 19990310 | |
| 4 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text | 19990310 |
Method SHOW_ROWS on class I_OI_SPREADSHEET has no exception.
Method UPDATE_FRONTEND Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error | 19990804 | ||
| 2 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 19990804 | |
| 3 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19990804 |
Method UPDATE_FRONTEND on class I_OI_SPREADSHEET has no exception.
Method VERSION Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ERROR | Call by reference | Object reference (TYPE REF TO) | I_OI_ERROR | error? | 19991019 | ||
| 2 | Importing |
NO_FLUSH | Call by reference | Type reference (TYPE) | C | '' | flush? | 19991019 | |
| 3 | Exporting |
RETCODE | Call by reference | Type reference (TYPE) | SOI_RET_STRING | text of error | 19991019 | ||
| 4 | Exporting |
VERSION | Call by reference | Type reference (TYPE) | C | Version | 19991019 |
Method VERSION on class I_OI_SPREADSHEET has no exception.
History
| Last changed by/on | SAP | 19991216 |
| SAP Release Created in |
