/**************************************************************
*
* Licensed to the Apache Software Foundation (ASF) under one
* or more contributor license agreements. See the NOTICE file
* distributed with this work for additional information
* regarding copyright ownership. The ASF licenses this file
* to you under the Apache License, Version 2.0 (the
* "License"); you may not use this file except in compliance
* with the License. You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing,
* software distributed under the License is distributed on an
* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
* KIND, either express or implied. See the License for the
* specific language governing permissions and limitations
* under the License.
*
*************************************************************/
import com.sun.star.uno.UnoRuntime;
import com.sun.star.lang.XMultiServiceFactory;
import com.sun.star.beans.XPropertySet;
import com.sun.star.table.XCellRange;
import com.sun.star.table.XCell;
import com.sun.star.text.XTextDocument;
import com.sun.star.text.XText;
import com.sun.star.text.XTextTable;
import com.sun.star.text.XTextCursor;
import com.sun.star.text.XTextRange;
import com.sun.star.form.binding.XValueBinding;
import com.sun.star.form.binding.XBindableValue;
import com.sun.star.form.binding.XListEntrySource;
import com.sun.star.form.binding.XListEntrySink;
public class SpreadsheetValueBinding extends DocumentBasedExample
{
/** Creates a new instance of SpreadsheetValueBinding */
public SpreadsheetValueBinding()
{
super( DocumentType.CALC );
}
/* ------------------------------------------------------------------ */
protected void prepareDocument() throws com.sun.star.uno.Exception, java.lang.Exception
{
super.prepareDocument();
SpreadsheetDocument document = (SpreadsheetDocument)m_document;
final short sheet = (short)0;
final short exchangeColumn = (short)1; // B
final short exchangeRow = (short)1; // 2
final Integer backColor = new Integer( 0x00E0E0E0 );
// ----------------------------------------------------------------------
// a numeric control
XPropertySet numericControl = m_formLayer.insertControlLine( "NumericField",
"enter a value", "", 30 );
numericControl.setPropertyValue( "ValueMin", new Short( (short)1 ) );
numericControl.setPropertyValue( "ValueMax", new Short( (short)5 ) );
numericControl.setPropertyValue( "Value", new Short( (short)1 ) );
numericControl.setPropertyValue( "DecimalAccuracy", new Short( (short)0 ) );
numericControl.setPropertyValue( "Spin", new Boolean( true ) );
// bind the control model to cell B2
implBind( numericControl, document.createCellBinding( sheet, exchangeColumn, exchangeRow ) );
// ----------------------------------------------------------------------
// insert a list box
XPropertySet listBox = m_formLayer.insertControlLine( "ListBox",
"select an entry", "", 2, 40, 20 );
listBox.setPropertyValue( "Dropdown", new Boolean( false ) );
// a list binding for cell range C1-C5
final short listSourceSheet = (short)1;
final short column = (short)0;
final short topRow = (short)0;
final short bottomRow = (short)4;
XListEntrySource entrySource = document.createListEntrySource(
listSourceSheet, column, topRow, bottomRow );
// bind it to the list box
XListEntrySink consumer = (XListEntrySink)UnoRuntime.queryInterface(
XListEntrySink.class, listBox );
consumer.setListEntrySource( entrySource );
// and also put the list selection index into cell B2
implBind( listBox, document.createListIndexBinding( sheet, exchangeColumn, exchangeRow ) );
// ----------------------------------------------------------------------
// fill the cells which we just bound the listbox to
XCellRange exchangeSheet = document.getSheet( listSourceSheet );
String[] listContent = new String[] { "first", "second", "third", "forth", "fivth" };
for ( short row = topRow; row <= bottomRow; ++row )
{
XTextRange cellText = (XTextRange)UnoRuntime.queryInterface(
XTextRange.class, exchangeSheet.getCellByPosition( column, row ) );
cellText.setString( listContent[row] );
}
// some coloring
XPropertySet exchangeCell = UNO.queryPropertySet(
document.getSheet( sheet ).getCellByPosition( exchangeColumn, exchangeRow )
);
exchangeCell.setPropertyValue( "CellBackColor", backColor );
numericControl.setPropertyValue( "BackgroundColor", backColor );
listBox.setPropertyValue( "BackgroundColor", backColor );
}
/* ------------------------------------------------------------------ */
private void implBind( XPropertySet controlModel, XValueBinding binding ) throws com.sun.star.form.binding.IncompatibleTypesException
{
XBindableValue bindable = (XBindableValue)UnoRuntime.queryInterface(
XBindableValue.class, controlModel
);
bindable.setValueBinding( binding );
}
/* ------------------------------------------------------------------ */
/** class entry point
*/
public static void main(String argv[]) throws java.lang.Exception
{
SpreadsheetValueBinding aSample = new SpreadsheetValueBinding();
aSample.run( argv );
}
}