OfficeControl

Use

With the OfficeControl UI element, you can insert an Office document into a view (see also, Office integration). This means you can display the following Office documents within a Web Dynpro application:

  • Microsoft Word

  • Microsoft Excel

  • Microsoft Project

  • Microsoft Powerpoint (*.ppt and *.pptx)

OfficeControl is provided as an Active UI Element (ActiveX control element), which means that the UI element can be displayed by browsers that support ActiveX controls.

When using Microsoft Office and browsers that do not support ActiveX controls, the user receives the runtime exception Office Integration through Applet is not supported.

Implementation Details

The implementation of the OfficeControl UI element supports the following functions for the Office documents mentioned above:

  • Open

  • Close

  • Save

  • Create new documents

In the Expert Mode additional method calls for complex operations are provided.

   

Example of the Visual Display

(See Web Dynpro application IOS_TEST_EXCEL in the system)

Runtime Class

CL_WD_OFFICE_CONTROL

Name

Type

Initial Value

Bindable

id

STRING

(automatic)

No

activateInPlace

WDY_BOOLEAN

true

Yes

additionalArchives

STRING

No

archive

STRING

No

classId

STRING

No

codeBase

STRING

No

contextMenuBehaviour

WDUI_CONTEXT_MENU_BEHAVIOUR

inherit

No

contextMenuId

WDY_MD_UI_ELEMENT_REFERENCE

No

controlId

STRING

No

dataSource

XSTRING

Yes

documentName

STRING

Yes

documentType

WDUI_OFFICE_DOC_TYPE

ms_word

Yes

enabled

WDY_BOOLEAN

true

Yes

enableReadWrite

WDY_BOOLEAN

true

Yes

expertMode

WDY_BOOLEAN

false

Yes

height

STRING

300px

Yes

lifeTime

WDUI_LIFE_TIME

whenVisible

Yes

showDecoration

WDY_BOOLEAN

true

Yes

styleClassName STRING Yes

tooltip

Translatable text

Yes

type

STRING

No

virusScanProfile VSCAN_PROFILE Yes

visible

WDUI_VISIBILITY

visible

Yes

width

STRING

300px

Yes

Other properties that can be inherited are defined in the related higher-level classes. The related UI elements are:

Dynamic Programming

For dynamic programming, the same properties, events, and aggregations as in the View Designer are available. But note that the spelling format and use of upper/lower case is different.

View Designer Name

Runtime Name

Type

activateInPlace

ACTIVATE_IN_PLACE

WDY_BOOLEAN

additionalArchives

ADDITIONAL_ARCHIVES

STRING

archive

ARCHIVE

STRING

classId

CLASS_ID

STRING

codeBase

CODE_BASE

STRING

contextMenuBehaviour

CONTEXT_MENU_BEHAVIOUR

WDUI_CONTEXT_MENU_BEHAVIOUR

 contextMenuBehaviour: inherit

CL_WD_OFFICE_CONTROL=>E_CONTEXT_MENU_BEHAVIOUR-INHERIT

 contextMenuBehaviour: provide

CL_WD_OFFICE_CONTROL=>E_CONTEXT_MENU_BEHAVIOUR-PROVIDE

 contextMenuBehaviour: suppress

CL_WD_OFFICE_CONTROL=>E_CONTEXT_MENU_BEHAVIOUR-SUPPRESS

contextMenuId

CONTEXT_MENU_ID

WDY_MD_UI_ELEMENT_REFERENCE

controlId

CONTROL_ID

STRING

dataSource

DATA_SOURCE

XSTRING

documentName

DOCUMENT_NAME

STRING

documentType

DOCUMENT_TYPE

WDUI_OFFICE_DOC_TYPE

 documentType: ms_excel

CL_WD_OFFICE_CONTROL=>E_DOCUMENT_TYPE-MS_EXCEL

 documentType: ms_word

CL_WD_OFFICE_CONTROL=>E_DOCUMENT_TYPE-MS_WORD

 documentType: ms_project

CL_WD_OFFICE_CONTROL=>E_DOCUMENT_TYPE-MS_PROJECT

enabled

ENABLED

WDY_BOOLEAN

enableReadWrite

ENABLE_READ_WRITE

WDY_BOOLEAN

expertMode

EXPERT_MODE

WDY_BOOLEAN

height

HEIGHT

STRING

lifeTime

LIFE_TIME

WDUI_LIFE_TIME

 lifeTime: whenAlive

CL_WD_OFFICE_CONTROL=>E_LIFE_TIME-WHEN_ALIVE

 lifeTime: whenVisible

CL_WD_OFFICE_CONTROL=>E_LIFE_TIME-WHEN_VISIBLE

showDecoration

SHOW_DECORATION

WDY_BOOLEAN

styleClassName STYLE_CLASS_NAME STRING

tooltip

TOOLTIP

WDY_MD_TRANSLATABLE_TEXT

type

TYPE

STRING

virusScanProfile VIRUS_SCAN_PROFILE VSCAN_PROFILE

visible

VISIBLE

WDUI_VISIBILITY

 visible: none

CL_WD_OFFICE_CONTROL=>E_VISIBLE-NONE

 visible: visible

CL_WD_OFFICE_CONTROL=>E_VISIBLE-VISIBLE

width

WIDTH

STRING

View Designer Name

Runtime Name

onClose

ON_CLOSE

onError

ON_ERROR

onSave

ON_SAVE

Example

You can find examples of this UI element in the system in package SIOS: