OfficeControl 

You can use the OfficeControl UI element to add an Office document to a view. This means you can display the following Office documents within a Web Dynpro application:

●      Microsoft Word documents with the doc file extension

●      Microsoft-Excel documents with the xls file extension

●      Microsoft Project documents with the mpp file extension

 

When MS Project documents (IF_IOS_PROJECT~EXPORT_XML and IF_IOS_PROJECT~IMPORT_XML) are imported and exported, for security reasons a whitelist is evaluated. A reference is made to the name of the whitelist on the IF_IOS_PROJECT~SET_WHITELIST interface. It is the same whitelist as used for AcfUpDownload. Note that symbols such as $HOME are not supported in MS Project integration for security reasons.

 

The OfficeControl UI element is made available as an Active UI Element (ActiveX control element), so that the UI element can be displayed in browsers that support ActiveX controls.

If Microsoft Office and browsers that do not support ActiveX controls are used, the following runtime exception is raised: Office Integration through Applet is not supported.

The integration of active controls like OfficeControl in Web Dynpro ABAP popups is not supported.

Prerequisites

●      Installation of Microsoft Office
For more information about the Office versions supported by SAP, see SAP Note 892638.

●      ActiveX must be activated in the browser.

Details

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

●      Open

●      Close

●      Backup

●      Create new documents

Note that you can open and close a document by setting the visible property of the OfficeControl UI elements to visible or none.

Also note that the OfficeControl is only active when the visible property is set to visible. Background processing is activated when the visible property is set, and width and height = 0.

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

Examples of the Display

 

Runtime Class

CL_WD_OFFICE_CONTROL

 

Properties in the View Designer

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
showDecoration	WDY_BOOLEAN	true	Yes
tooltip	Translatable text		Yes
type	STRING		No
visible	WDUI_VISIBILITY	visible	Yes
width	STRING	300px	Yes

 

Events in the View Designer

Name

onClose

onError

onSave

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

●        AbstractActiveComponent

●        UIElement

●        ContextMenuProvider

●        ViewElement

Dynamic Programming

For dynamic programming, the same properties, events, and aggregations as in the View Designer are available. Bear in mind the different spellings.

Dynamic Programming of Properties

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
showDecoration	SHOW_DECORATION	WDY_BOOLEAN
tooltip	TOOLTIP	WDY_MD_TRANSLATABLE_TEXT
type	TYPE	STRING
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

 

Dynamic Programming of Events

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 collection sios.