/**************************************************************
*
* 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.
*
*************************************************************/
// __________ Imports __________
// base classes
import com.sun.star.uno.XInterface;
import com.sun.star.uno.UnoRuntime;
import com.sun.star.lang.*;
// property access
import com.sun.star.beans.*;
// application specific classes
import com.sun.star.chart.*;
import com.sun.star.drawing.*;
import com.sun.star.table.CellRangeAddress;
import com.sun.star.table.XCellRange;
import com.sun.star.sheet.XSpreadsheetDocument;
import com.sun.star.frame.XModel;
import com.sun.star.frame.XController;
import com.sun.star.util.XNumberFormatsSupplier;
import com.sun.star.util.XNumberFormats;
// base graphics things
import com.sun.star.awt.Point;
import com.sun.star.awt.Size;
import com.sun.star.awt.Rectangle;
import com.sun.star.awt.FontWeight;
import com.sun.star.awt.FontRelief;
// Exceptions
import com.sun.star.uno.Exception;
import com.sun.star.uno.RuntimeException;
import com.sun.star.beans.UnknownPropertyException;
import com.sun.star.lang.IndexOutOfBoundsException;
import com.sun.star.util.MalformedNumberFormatException;
// __________ Implementation __________
/** Create a spreadsheet add some data.
Create a presentation and add a chart.
Connect the chart to a calc range via a listener
@author Björn Milcke
*/
public class ListenAtCalcRangeInDraw implements XChartDataChangeEventListener
{
public static void main( String args[] )
{
ListenAtCalcRangeInDraw aMySelf = new ListenAtCalcRangeInDraw( args );
aMySelf.run();
}
public ListenAtCalcRangeInDraw( String args[] )
{
Helper aHelper = new Helper( args );
maSheetDoc = aHelper.createSpreadsheetDocument();
maDrawDoc = aHelper.createDrawingDocument();
CalcHelper aCalcHelper = new CalcHelper( maSheetDoc );
ChartHelper aChartHelper = new ChartHelper( maDrawDoc );
XCellRange aRange = aCalcHelper.insertFormulaRange( 3, 30 );
// the unit for measures is 1/100th of a millimeter
// position at (1cm, 1cm)
Point aPos = new Point( 1000, 1000 );
// size of the chart is 15cm x 9.271cm
Size aExtent = new Size( 15000, 9271 );
// insert a new chart into the "Chart" sheet of the
// spreadsheet document
maChartDocument = aChartHelper.insertOLEChartInDraw(
"ChartWithCalcData",
aPos,
aExtent,
"com.sun.star.chart.XYDiagram" );
// attach the data coming from the cell range to the chart
maChartData = (XChartData) UnoRuntime.queryInterface( XChartData.class, aRange );
maChartDocument.attachData( maChartData );
}
// ____________________
public void run()
{
try
{
((XPropertySet) UnoRuntime.queryInterface(
XPropertySet.class, maChartDocument )).setPropertyValue(
"HasSubTitle", new Boolean( true ));
// start listening for death of spreadsheet
((XComponent) UnoRuntime.queryInterface(
XComponent.class, maSheetDoc )).addEventListener( this );
// start listening for death of chart
((XComponent) UnoRuntime.queryInterface(
XComponent.class, maChartDocument )).addEventListener( this );
//start listening for change of data
maChartData.addChartDataChangeEventListener( this );
}
catch( Exception ex )
{
System.out.println( "Oops: " + ex );
}
// call listener
ChartDataChangeEvent aEvent = new ChartDataChangeEvent();
aEvent.Type = ChartDataChangeType.ALL;
chartDataChanged( aEvent );
}
// ____________________
// XEventListener (base of XChartDataChangeEventListener)
public void disposing( EventObject aSourceObj )
{
if( UnoRuntime.queryInterface( XChartDocument.class, aSourceObj.Source ) != null )
System.out.println( "Disconnecting Listener because Chart was shut down" );
if( UnoRuntime.queryInterface( XSpreadsheetDocument.class, aSourceObj.Source ) != null )
System.out.println( "Disconnecting Listener because Spreadsheet was shut down" );
// remove data change listener
maChartData.removeChartDataChangeEventListener( this );
// remove dispose listeners
((XComponent) UnoRuntime.queryInterface(
XComponent.class, maSheetDoc )).removeEventListener( this );
((XComponent) UnoRuntime.queryInterface(
XComponent.class, maChartDocument )).removeEventListener( this );
System.exit( 0 );
}
// ____________________
// XChartDataChangeEventListener
public void chartDataChanged( ChartDataChangeEvent aEvent )
{
// update subtitle
String aTitle = new String( "Last Update: " + new java.util.Date( System.currentTimeMillis() ));
try
{
XPropertySet aDocProp = (XPropertySet) UnoRuntime.queryInterface(
XPropertySet.class, maChartDocument );
aDocProp.setPropertyValue( "HasMainTitle", new Boolean( true ));
((XPropertySet) UnoRuntime.queryInterface(
XPropertySet.class, maChartDocument.getSubTitle())).setPropertyValue(
"String", aTitle );
maChartDocument.attachData( maChartData );
}
catch( Exception ex )
{
System.out.println( "Oops: " + ex );
}
System.out.println( "Data has changed" );
}
// __________ private __________
private XSpreadsheetDocument maSheetDoc;
private XModel maDrawDoc;
private XChartDocument maChartDocument;
private XChartData maChartData;
}