Manipulating a Data Grid in a Websheet Application

Open your websheet application.

To view the data grids you have created in a websheet application, click View and select Data Grids.

Click the Tasks data grid icon.

You can hide a column in your data grid. Select the ASSIGNED_TO column header and select the Hide Column icon.

The ASSIGNED_TO column is now hidden.

You can create a filter on a particular value in a column. Select the STATUS column header. Select closed (with the lowercase 'c') from the list of STATUS values.

A filter is created. Click in the closed value and you will be placed in edit mode.

Change the value so that the first letter is upper case (Closed) and press enter.

Notice that the Status value is now changed. You can remove the filter by clicking the Remove Filter icon.

Select the STATUS column header. Notice that Closed only appears once in the list now because the closed status was changed to match the other values.

You want to change all the On-Hold status values to Pending. Select Manage > Rows > Replace.

Select STATUS from the list of Columns, enter On-Hold in the Find What area and Pending in the Replace With area and click Apply.

Select the STATUS column heading again. Notice that all the On-Hold values were changed to Pending and the On-Hold value no longer appears in the list.

You want to change a column so that end users can not change the value, they can only select from a list of values. Select Manage > Columns > Column Properties.

Select STATUS for Column Name, select Select List for Display As, select - New List of Values Based on Current Values - for List of Values and click Apply.

Select one of the values in the Status column and notice now that it is a select list instead of a text field.

Select Manage > Columns > Add.

Specify the following and click Apply.

Notice that the new Priority column is displayed. Select one of the values. Notice that the select list is displayed.

Select Manage > History.

A list of changes you made is displayed. Select the View Single Row icon in front of one of the rows.

The detail is displayed. In the next section, you add some annotations to your data grid. Select the Tasks breadcrumb.

Select Manage > Columns > Validation.

Enter Is Numeric for Name and select Column specified is numeric from the Type drop-down list. Select COST for Column Name and enter Only numeric characters allowed. in the Error Message text field and click Apply.

To check the validation, click the edit pencil icon for a row.

Enter dollars next to the numeric value in the COST field and click Apply Changes.

The validation is run and the error message you specified is displayed. Click the Tasks breadcrumb to return to the Tasks data grid.

Click the Edit icon for one of the rows in your data grid.

You want to add a file to this project. Select the Add File link in the Actions area.

Click Choose File.

Select the hardware.xls file from the directory where your files are located and click Open. Then, click Apply.

Your file was added successfully.

Now you want to add a Note. Select the Add Note link in the Actions area.

Enter Task needs review and click Apply.

Your Note was added successfully.

Now you want to add a link. Select the Add Link link in the Actions area.

Enter APEX OTN Page in the Link Name field and enter http://otn.oracle.com/apex in the URL Target area and click Apply.

Your link was created successfully.

Now you want to add a tag. Select the Add Tags link in the Actions area.

Enter DAVID, MARCIE and click Apply.

Your tag was created successfully.

Now you can return to the Report View and add the annotations you just added to the report. Click Report View.

You need to add the annotation columns to the report. Click Actions and select Select Columns.

Select Files, Notes, Links and Tags from the list of Do Not Display columns and click the Move icon to move the columns to the Display in Report area.

Click Apply.

The columns are displayed. If you place your mouse over the files icon, you see the name of the file. You can click the file icon to download the file.

Place your mouse on the Notes icon and you see the note displayed.

To see the link, you can right-click the link icon and select Open link in a new tab.

Select the Tags column header to see that you can select a tag (which shows the people separated) from the list which will show you all the projects that have that tag as an annotation.

Click Actions and select Save Report.

Select As Default Reports Settings from the Save drop down list.

An alternative report is a report that all users will see. It is equivalent to a public report. Select the Alternative Default Report Type, enter Tasks with Annotations for the name and click Apply.

You want to return to the Primary Report. Select Primary Reports from the list of reports.

You want to reset this report to its default settings. Note that it will look the same as the My Report Alternative Report until it is reset. Click Actions and select Reset.

Click Apply.

Notice that your report is reset to the default settings. To return to the other report, select Tasks with Annotations from the list of reports.

The report is displayed with the modifications made.