Download and open the
datapilot_testdocument.ods
Select Start from Data ->
Datapilot.
Press the Ok Button for the
current Selection.
Drag and Drop Area to Page
Fields, Products to Column Fields, Salesman to Row Fields and
2000, 2001 and 2002 into the Data Fields section of the Datapilot
Window and click on Ok.
The Datapilot has to cover A23
with a filter button, A24 with an Area button, B24 with a
dropdown listbox and A26:F48 with the datapilot data area.
Make sure F48 contains 3899000,
A40 contains Robinson, C26 a Products button and D35 60000
Drag & Drop the Products
button from C26 to A28 The datapilot area must have changed to
cover A26:D80
Make sure you have a button
Salesman in A26, Products in B26 and Data in C26
Drag & Drop the Salesman
button from A26 to D26 The datapilot area must have changed to
cover A26:I39
Make sure you have a button
Salesman in C26, Products in A27 and Data in B27
Check that A28 shows Audio, A31
DVD and A34 Video. The total Result in I37 must show 3184000
Drag and Drop the Data button
from B27 to D22. A warning should appear stating 'The Data range
can not be deleted' Confirm this dialog by clicking on Ok
Drag and Drop the Products
button from A27 to D45. The products data must be removed from
the datapilot and the datapilot area must cover A26:H33
Drag and Drop the Area button from A24 to B40. The filter
button must change its position to A24 and the dropdown listbox
from B24 must have gone too.
A Click on the Filter-Button
must start the Standard filter dialog.
Choose the fieldname Salesman
in the Filter dialog set condition to equal and Value to Brown.
Click on Ok
Only Values for Salesman Brown
must be shown and F32 must show 430000
Click again on Filter and
select - None - as Field name, all Salesman must be shown again,
F48 must show 3899000
Place the cell cursor on D32
and open the context menu.
Check the functionality of the items found as
follows :
- Search (if the Sun Search toolbar is installed)
Contains Search the Web and Create Hyperlink to search Google.
-
Start (opens the DataPilot configuration Editor) Close the dialog
by clicking on Cancel
- Refresh (Rebuilds the DataPilot output
based on New entered Data. To check that it works, change A21
from DVD to HD, Context Menu, Refresh. A new Column HD is
inserted into the DataPilot)
- Filter (Opens the Standard
Filter dialog) Close the dialog by clicking on Cancel
- Delete
(Removes the DataPilot from the Sheet) Select D32 and Delete from
the context menu. The datapilot must have gone. Press CTRL+Z to
undo the deletion of the datapilot.
- Cut (Cuts cell content
into the clipboard) Select D35 and select cut from the context
menu. Select Sheet3.B2 and paste from the context menu. Sheet3.B2
should show 60000. Switch back to Sheet1
- Copy (Copys cell
content into the clipboard) Select D36 and select copy from the
context menu. Select Sheet3.B4 and paste from the context menu.
Sheet3.B4 should show 90000. Switch back to Sheet1
- Paste
(Pastes the clipboard into the selected cell) Select D32 and
paste from the context menu. D32 must show 90000
If any of the conditions above is not met, file an Issue
for the use case.
Double click on C27. A dialog
named Show Detail should be opened. Select Area and click Ok
Next to the Products field in
C25 should have been appeared another field named Area. C27:F27
should contain the citys from the Area section of the underlying
data range (Boston, Chicago, Miami and New York) and the details
regarding the Audio Products must show up in C28:F45. F39 must
show 234000 and A42 must show 180000
Double click G26. The Area
details must also appear for DVD's covering G27:I45 with I45
showing 70000.
Double click G26 again. The details have to be hidden
again with I45 showing 710000.
Select C26 and from the context
menu Delete
Place the cell cursor on A17
and Select Start from Data -> Datapilot.
Press the Ok Button for the
current Selection.
Drag and Drop Area to Page
Fields, Products to Column Fields, Salesman to Row Fields and
2000, 2001 and 2002 into the Data Fields section of the Datapilot
Window
Double click on the Sum - 2002
field
A dialog opens. Click on Cancel
in this dialog. If it doesn't close file an Issue.
Click on the Options Button in
the DataPilot dialog.
The Data Field dialog opens
again. Click on Help. The Help system opens. If not file an
Issue. Close the Help system. Press ESC on the keyboard. The
dialog must have been closed, if not file an Issue.
Press ALT+O. The Data Field
dialog opens again. If not file an Issue.
Click on the More Button. The
Dialog extends to the bottom showing the section Displayed value.
In the Type drop down list box select Runnig total in and set the
Base field drop down list box to Products. Click on Ok. If you
get an Error message, file an Issue.
Double Click on Products in the
Column field section.
The Data Field dialog comes up.
Click on the Radio Button in front of User-defined in the
Subtotals section. Select Count as option, tag the checkbox for
'Show Items without data'. If any of these actions is not
possible, file an Issue.
Press ALT+O on the Keyboard to
open the Data Field Options dialog.
Set the Sort by dropdown list
box to 2000, the Radio Button in front of Descending and the
check box in front of Show in the Show automatically section.
Decrease the spin field to show 5 items, the drop down list box
From to Bottom and the Using Field drop down list box to 2001. In
the Hide Items section set the checkbox in front of DVD to
active. If any of these settings are not possible, file an Issue.
Close all these Dialogs by
pressing ESC as long as all dialogs are closed.
Select C31 and from the context
menu Delete
Click on A45. Click on the
datarange chooser at the left of the f(x) button on the toolbar.
Erase the A45 and type datapilotstestrange followed by RETURN
Select C20 and Select Start
from Data -> Datapilot.
Press the Ok Button for the
current Selection.
Drag and Drop Area to Page
Fields, Products to Column Fields, Salesman to Row Fields and
2000, 2001 and 2002 into the Data Fields section of the Datapilot
Window and click on the More button.
Set the drop down list box for
'Results to' to datapilotstestrange. The inputline next to this
list box must change to $Sheet1.$A$45 . If not file an Issue.
Tag the Checkboxes for 'Ignore
empty rows' and 'Identify categories'
Click on Ok. The DataPilot must
start with the Filter field placed on A45. If not, file an Issue.
Select C53 and choose start
from the context menu
Click on the More Button
Set the drop down list box for
'Results to' to '- new sheet -'
Untag the six checkboxes found
in the result section
Click on the Ok button.
A new sheet must habe been
created named 'DataPilot_Sheet1_1'. If not file an Issue.
The DataPilot must start on the
new Sheet at A1 with the Area field and the associated Drop down
list box in B1. If not, file an Issue.
Is any total or Subtotal Result
for the fields shown, file an Issue.
Double Click on C4. If the cell
does not switch into Edit mode, file an Issue.
Right click on C5 and Choose
Start from the Context menu. Click on the More Button on the
DataPilot dialog.
Click on the Shrink Button next
to the input line in the Result section. The Dialog shrinks to a
single line. If not file an Issue.
Click on F26 and press the
RETURN key on the keyboard. The DataPilot dialog must appear
again. If not file an Issue.
The input line must show
'$DataPilot_Sheet1_1.$F$26'. If not, file an Issue. Click on Ok.
The DatPilot must start now at F26 and remain at A1.
Close the document without saving it.