This appendix describes the actions the end user would be performing while using your application and integrated Excel workbook, such as installing runtime edition of ADF Desktop Integration, importing data from non-integrated Excel workbook, making changes in the workbook at runtime, and handling time zone converion of date-time values in the workbook.
The actions described in this appendix assume that you have developed a functioning Fusion web application similar to Master Price List module. However, your application might not support all actions provided by Master Price List module.
This appendix includes the following sections:
To enable end users to use ADF Desktop Integration and integrated Excel workbooks, you must install the Runtime edition of ADF Desktop Integration.
When you run the ADF Desktop Integration setup tool, it verifies whether required software is installed on the system. For more information about the required software, see the following:
Note:JDeveloper is not required to install the runtime edition of ADF Desktop Integration.
Navigate to the
\oracle_common\modules\oracle.adf.desktopintegration_11.1.1 directory, where
MW_HOME is the Middleware Home directory.
Extract the contents of
adfdi-excel-runtime-client-installer.zip to a temporary directory.
setup.exe file located in the extracted directory of the
Follow the instructions that appear in the dialog boxes launched by
setup.exe to successfully install the required components.
If prompted, click Yes to restart the system and complete the setup of ADF Desktop Integration.
Note:You cannot install the Runtime edition of ADF Desktop Integration from JDeveloper.
Note that you cannot install both the Designer and the Runtime editions of ADF Desktop Integration on a system. You must uninstall one before installing the other edition.
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
For example, if an ADF Table component contains columns such as
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 functionality of Excel 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.
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.
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.
Select the cells in the non-integrated Excel worksheet and not the rows or columns.
In the Excel menu, choose Home > Copy.
In the ADF Table component, select the upper left corner cell of the rows inserted in Step 2.
In the Excel menu, choose Home > Paste. Ensure that you do not paste any value in the Key column.
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."
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 system where the end user accesses the integrated Excel workbook. End users can remove this information using Microsoft Internet Explorer. End users must log out and close all integrated Excel workbooks to invalidate all active cookie-based web sessions.
For information about removing personal information, see Microsoft Internet Explorer documentation.
Once you publish and deploy a finalized integrated Excel workbook, as described in Chapter 14, " Deploying Your Integrated Excel Workbook." end users can make the following changes to a workbook at runtime:
Delete a column from an ADF Table or ADF Read-only Table component
Drag and drop cells to move ADF components other than an ADF Button component
Insert new rows into an ADF Table component
Change the order of columns in an ADF Table or ADF Read-only Table component
Insert non-integrated columns between the columns of an ADF Table or ADF Read-only Table component
However, some changes to a workbook at runtime can corrupt the integration and are not supported. For example, you must not delete or move the first column of the ADF Table or ADF Read-only Table component at runtime. For more information about what changes are not allowed at runtime, see Section I.5, "Limitations of Integrated Excel Workbook at Runtime."
Moving a column in an ADF Read-only Table component – If the end user moves a column of an ADF Read-only Table component to be the leftmost 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 the 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.
Excel's conditional formatting of cells at runtime has no impact on the selected cells or on the integration of workbook.
The ADF Button components are disabled when the 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 is incompatible with integrated Excel workbooks.
End users who are new to the ADF Desktop Integration technology and integrated Excel workbook must be made aware of the following common actions:
To insert a row in an ADF Table component, insert a full row in the worksheet, and add data in all mandatory columns. Do not insert partial rows, as partial rows corrupts the ADF Table component.
For more information, see Section 7.5, "Configuring an ADF Table Component to Insert Data."
To delete a row from the web application, flag the row by double-clicking the respective cell of the Flagged column, and click the respective delete button. Clearing the cell values of a row, or removing the row from the worksheet, does not remove the row from the web application. Also, deleting the row from Excel does not delete the row from the web application.
For more information about row flagging, see Section 7.10.2, "Row Flagging in an ADF Table Component."
To download all rows after uploading the changed data, ensure that Download all rows after successful upload checkbox is selected in Upload Options dialog box.
To sort table data based on a particular column, select any cell of the column or the column header. Click Sort and Filter on the Home tab, and choose your desired option.
To sort table data based on multiple columns, do not select data rows or columns partially. Select any cell of the table, click Sort and Filter on the Home tab, and choose Custom Sort to specify desired columns. You will notice that all columns of the table are automatically selected. Before you proceed, ensure that the Key column is also selected. In the Sort dialog box, add the columns, their order preference, and then click OK. Ensure that the My data has headers checkbox is enabled before you click OK.
Before uploading the changes, ensure that the Changed column of all modified rows is marked with an upward pointing triangle. A double-click on the upward pointing triangle character removes it, and the data of the relevant row is not uploaded.
While uploading, if you want to have Excel retain the format of a numeric or date value in a cell formatted with a text style, add an apostrophe symbol (') before entering the value. The apostrophe symbol acts as an escape character and is not displayed with the value.
Do not delete, edit, or clear any cells in the Key column of the table. Any change to these values can lead to upload failures and even data corruption.
Do not change Excel's settings for Protect Sheet or Protect Workbook. These settings are available in the Changes group of Review tab.
You can configure integrated Excel workbooks to retrieve, edit, and submit data values that represent dates and times. As Excel does not provide native support for managing date or time data when the system time zone changes, ADF Desktop Integration tracks and detects the time zone changes for a workbook. It informs the end user about the time zone update when the workbook is opened, and then converts the date-time data of the workbook to the current time zone setting of the system.
For example, an end user in Arizona (GMT -07:00) downloads the data from the server to the integrated Excel workbook, edits the date-time data in the workbook, saves the data, but does not upload it. Later, the end user travels to Seoul and changes the time zone preference of the computer to GMT +09:00. When the end user opens the workbook after changing to the Seoul time zone, they receive a message, and then all date-time data values in the ADF components are converted from GMT -07:00 (Arizona) to GMT +09:00 (Seoul).