I End User Actions

This appendix describes the infrequent actions your end user would be performing while using your application and integrated Excel workbook.

The actions described here assume that you have developed a functioning Fusion web application similar to Master Price List module. However, your application may not support all actions provided by Master Price List module.

I.1 Importing Data From a Non-Integrated Excel Worksheet

End users who use the ADF Table component in an integrated Excel workbook to upload large batches of data rows to the Fusion web application can prepare these rows of data in a non-integrated Excel worksheet. They can then insert the data into the ADF Table component prior to invoking the ADF Table component's Upload action.

To prepare data in a non-integrated Excel workbook:

End users arrange the layout of data in a non-integrated Excel worksheet to match the layout of the ADF Table component in the integrated Excel workbook.

For example, if an ADF Table component contains columns such as Product, Price, and Description, reproduce this layout in the non-integrated Excel worksheet.

Tip:
Copy the column headers from the ADF Table component to the non-integrated Excel worksheet.
End users use Excel's functionality to import the rows of data into the non-integrated Excel worksheet in rows under the columns arranged in Step 1.

Row values that will be inserted into ADF Table component columns that use the TreeNodeList subcomponent must match a choice from the list of values.

Tip:

Copy an ADF Table component row from the integrated Excel workbook to another worksheet of the same workbook, as the proper constraints will be defined for such a row and can be reproduced.

To insert data into the ADF Table component from a non-integrated Excel workbook:

In the ADF Table component, end users highlight N existing downloaded rows or new rows at the end of the ADF Table component where N is the number of rows to insert.
End users right-click and select Insert from Excel's context menu.
In the non-integrated Excel worksheet, end users select the cells that they want to insert into the rows of the ADF Table component created in Step 2.

WARNING:

Select the cells in the non-integrated Excel worksheet and not the rows or columns.
In Excel's menu, click Home > Copy.
In the ADF Table component, select the upper left corner cell of the rows inserted in Step 2.
In Excel's menu, click Home > Paste.

Note:
Integrated Excel worksheets that contain an ADF Table component hide column A.
End users can now invoke the ADF Table component's Upload action using whatever functionality you configured for them as described in Section 7.8, "Configuring an Oracle ADF Component to Upload Changes from an ADF Table Component".

I.2 Removing Personal Information

If the Fusion web application that you integrate an Excel workbook with uses a security mechanism, such as single sign-on, personally identifying information may be stored in cookies on the machine where an end user accesses the integrated Excel workbook. End users can remove this information using Microsoft Internet Explorer. End users must log out from and close all integrated Excel workbooks to invalidate all active cookie-based web session IDs.

For information about removing personal information, see Microsoft Internet Explorer's documentation.

I.3 Limitations of Integrated Excel Workbook at Runtime

There are some known limitations on changing ADF Desktop Integration components at runtime.

Moving a column in an ADF Read-only Table component – If an end user moves a column of an ADF Read-only Table component to be the left-most column of the table, ADF Desktop Integration generates an exception when the end user tries to download data.

To resolve the problem, the end user must close and reopen the workbook without saving changes.
Deleting an Integrated Excel Worksheet – If an end user deletes an integrated Excel worksheet, ADF Desktop Integration generates an exception when the end user tries to save the integrated Excel workbook.

To resolve the problem, the end user must close and reopen the workbook without saving changes.
Switching modes when Excel filtering is active in an ADF Table component – If the end user has applied Excel filtering to an ADF Table component at runtime and tries to switch to design mode without removing filtering, ADF Desktop Integration generates an exception.

To resolve the problem, the end user must remove the filter before switching to design mode.

The following Excel features have no impact and are not supported by Oracle ADF Desktop Integration module:

Excel's Conditional Formatting of cells at runtime have no impact on the selected cells or on the integration of workbook.
The ADF Button components are disabled when end user zooms in or out on an integrated Excel worksheet. The ADF Button components are active at 100% zoom only.
Excel's Protect Sheet feature has no impact on integrated Excel workbook. It is not equivalent to authentication password which end user provides while logging in.
Editing the label text of ADF Button and value of ADF Output Text components is not supported at runtime.