1*b1cdbd2cSJim Jagielski# ************************************************************* 2*b1cdbd2cSJim Jagielski# 3*b1cdbd2cSJim Jagielski# Licensed to the Apache Software Foundation (ASF) under one 4*b1cdbd2cSJim Jagielski# or more contributor license agreements. See the NOTICE file 5*b1cdbd2cSJim Jagielski# distributed with this work for additional information 6*b1cdbd2cSJim Jagielski# regarding copyright ownership. The ASF licenses this file 7*b1cdbd2cSJim Jagielski# to you under the Apache License, Version 2.0 (the 8*b1cdbd2cSJim Jagielski# "License"); you may not use this file except in compliance 9*b1cdbd2cSJim Jagielski# with the License. You may obtain a copy of the License at 10*b1cdbd2cSJim Jagielski# 11*b1cdbd2cSJim Jagielski# http://www.apache.org/licenses/LICENSE-2.0 12*b1cdbd2cSJim Jagielski# 13*b1cdbd2cSJim Jagielski# Unless required by applicable law or agreed to in writing, 14*b1cdbd2cSJim Jagielski# software distributed under the License is distributed on an 15*b1cdbd2cSJim Jagielski# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*b1cdbd2cSJim Jagielski# KIND, either express or implied. See the License for the 17*b1cdbd2cSJim Jagielski# specific language governing permissions and limitations 18*b1cdbd2cSJim Jagielski# under the License. 19*b1cdbd2cSJim Jagielski# 20*b1cdbd2cSJim Jagielski# ************************************************************* 21*b1cdbd2cSJim Jagielski 22*b1cdbd2cSJim JagielskiExampleDataPilotSource 23*b1cdbd2cSJim Jagielski====================== 24*b1cdbd2cSJim Jagielski 25*b1cdbd2cSJim JagielskiThis example shows how you can implement an external DataPilot 26*b1cdbd2cSJim Jagielskicomponent. 27*b1cdbd2cSJim Jagielski 28*b1cdbd2cSJim JagielskiSimple usage scenario: 29*b1cdbd2cSJim Jagielski====================== 30*b1cdbd2cSJim Jagielski1. build and deploay the component 31*b1cdbd2cSJim Jagielski2. open a new spreadsheet document 32*b1cdbd2cSJim Jagielski3. select for example cell B:2 33*b1cdbd2cSJim Jagielski4. start the DataPilot dialog 34*b1cdbd2cSJim Jagielski Data->DataPilot->Start... 35*b1cdbd2cSJim Jagielski5. select "External source/interface -> Ok 36*b1cdbd2cSJim Jagielski6. select the example DataPilot 37*b1cdbd2cSJim Jagielski Use the the drop down list and select the service 38*b1cdbd2cSJim Jagielski "ExampleDataPilotSource" -> Ok 39*b1cdbd2cSJim Jagielski7. Place some number fields in the field areas 40*b1cdbd2cSJim Jagielski For example: 41*b1cdbd2cSJim Jagielski - select the "ones" field and drop it in the "Row Fields" area 42*b1cdbd2cSJim Jagielski - repeat this step with the "tens" and "hundreds" field 43*b1cdbd2cSJim Jagielski - select the "thousands" field and drop it in the "Column Fields" 44*b1cdbd2cSJim Jagielski area. 45*b1cdbd2cSJim Jagielski -> press Ok 46*b1cdbd2cSJim Jagielski8. you see a matrix with rows and colums for the selected fields 47*b1cdbd2cSJim Jagielski and a value area with a sum up of all fields valid for this 48*b1cdbd2cSJim Jagielski coordinate. For example cell F:21=1221 (ones=B:21=1, tens=c:21=2 49*b1cdbd2cSJim Jagielski hundreds=D:21=2 and thousands=F:3=1) 50*b1cdbd2cSJim Jagielski 51*b1cdbd2cSJim Jagielski 52