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 Jagielski 23*b1cdbd2cSJim Jagielski 24*b1cdbd2cSJim Jagielski // __________ Imports __________ 25*b1cdbd2cSJim Jagielski 26*b1cdbd2cSJim Jagielski // base classes 27*b1cdbd2cSJim Jagielski import com.sun.star.uno.XInterface; 28*b1cdbd2cSJim Jagielski import com.sun.star.uno.UnoRuntime; 29*b1cdbd2cSJim Jagielski import com.sun.star.lang.*; 30*b1cdbd2cSJim Jagielski 31*b1cdbd2cSJim Jagielski // property access 32*b1cdbd2cSJim Jagielski import com.sun.star.beans.*; 33*b1cdbd2cSJim Jagielski 34*b1cdbd2cSJim Jagielski // application specific classes 35*b1cdbd2cSJim Jagielski import com.sun.star.chart.*; 36*b1cdbd2cSJim Jagielski import com.sun.star.drawing.*; 37*b1cdbd2cSJim Jagielski import com.sun.star.text.XTextDocument; 38*b1cdbd2cSJim Jagielski 39*b1cdbd2cSJim Jagielski import com.sun.star.table.CellRangeAddress; 40*b1cdbd2cSJim Jagielski import com.sun.star.frame.XModel; 41*b1cdbd2cSJim Jagielski import com.sun.star.frame.XController; 42*b1cdbd2cSJim Jagielski 43*b1cdbd2cSJim Jagielski import com.sun.star.util.XNumberFormatsSupplier; 44*b1cdbd2cSJim Jagielski import com.sun.star.util.XNumberFormats; 45*b1cdbd2cSJim Jagielski 46*b1cdbd2cSJim Jagielski // base graphics things 47*b1cdbd2cSJim Jagielski import com.sun.star.awt.Point; 48*b1cdbd2cSJim Jagielski import com.sun.star.awt.Size; 49*b1cdbd2cSJim Jagielski import com.sun.star.awt.Rectangle; 50*b1cdbd2cSJim Jagielski import com.sun.star.awt.FontWeight; 51*b1cdbd2cSJim Jagielski import com.sun.star.awt.FontRelief; 52*b1cdbd2cSJim Jagielski 53*b1cdbd2cSJim Jagielski // Exceptions 54*b1cdbd2cSJim Jagielski import com.sun.star.uno.Exception; 55*b1cdbd2cSJim Jagielski import com.sun.star.uno.RuntimeException; 56*b1cdbd2cSJim Jagielski import com.sun.star.beans.UnknownPropertyException; 57*b1cdbd2cSJim Jagielski import com.sun.star.lang.IndexOutOfBoundsException; 58*b1cdbd2cSJim Jagielski import com.sun.star.util.MalformedNumberFormatException; 59*b1cdbd2cSJim Jagielski 60*b1cdbd2cSJim Jagielski 61*b1cdbd2cSJim Jagielski // __________ Implementation __________ 62*b1cdbd2cSJim Jagielski 63*b1cdbd2cSJim Jagielski /** Test to create a writer document and insert an OLE Chart. 64*b1cdbd2cSJim Jagielski 65*b1cdbd2cSJim Jagielski Be careful! This does not really work. The Writer currently has no 66*b1cdbd2cSJim Jagielski interface for dealing with OLE objects. You can add an OLE shape to the 67*b1cdbd2cSJim Jagielski Writer's drawing layer, but it is not treated correctly as OLE object. 68*b1cdbd2cSJim Jagielski Thus, you can not activate the chart by double-clicking. The office may 69*b1cdbd2cSJim Jagielski also crash when the document is closed! 70*b1cdbd2cSJim Jagielski 71*b1cdbd2cSJim Jagielski @author Björn Milcke 72*b1cdbd2cSJim Jagielski */ 73*b1cdbd2cSJim Jagielski public class ChartInWriter 74*b1cdbd2cSJim Jagielski { 75*b1cdbd2cSJim Jagielski // ____________________ 76*b1cdbd2cSJim Jagielski main( String args[] )77*b1cdbd2cSJim Jagielski public static void main( String args[] ) 78*b1cdbd2cSJim Jagielski { 79*b1cdbd2cSJim Jagielski Helper aHelper = new Helper( args ); 80*b1cdbd2cSJim Jagielski 81*b1cdbd2cSJim Jagielski ChartHelper aChartHelper = new ChartHelper( 82*b1cdbd2cSJim Jagielski (XModel) UnoRuntime.queryInterface( XModel.class, 83*b1cdbd2cSJim Jagielski aHelper.createTextDocument())); 84*b1cdbd2cSJim Jagielski 85*b1cdbd2cSJim Jagielski // the unit for measures is 1/100th of a millimeter 86*b1cdbd2cSJim Jagielski // position at (1cm, 1cm) 87*b1cdbd2cSJim Jagielski Point aPos = new Point( 1000, 1000 ); 88*b1cdbd2cSJim Jagielski 89*b1cdbd2cSJim Jagielski // size of the chart is 15cm x 12cm 90*b1cdbd2cSJim Jagielski Size aExtent = new Size( 15000, 13000 ); 91*b1cdbd2cSJim Jagielski 92*b1cdbd2cSJim Jagielski // insert a new chart into the "Chart" sheet of the 93*b1cdbd2cSJim Jagielski // spreadsheet document 94*b1cdbd2cSJim Jagielski XChartDocument aChartDoc = aChartHelper.insertOLEChartInWriter( 95*b1cdbd2cSJim Jagielski "BarChart", 96*b1cdbd2cSJim Jagielski aPos, 97*b1cdbd2cSJim Jagielski aExtent, 98*b1cdbd2cSJim Jagielski "com.sun.star.chart.AreaDiagram" ); 99*b1cdbd2cSJim Jagielski 100*b1cdbd2cSJim Jagielski // instantiate test class with newly created chart 101*b1cdbd2cSJim Jagielski ChartInWriter aTest = new ChartInWriter( aChartDoc ); 102*b1cdbd2cSJim Jagielski 103*b1cdbd2cSJim Jagielski try 104*b1cdbd2cSJim Jagielski { 105*b1cdbd2cSJim Jagielski aTest.lockControllers(); 106*b1cdbd2cSJim Jagielski 107*b1cdbd2cSJim Jagielski // do tests here 108*b1cdbd2cSJim Jagielski aTest.testWall(); 109*b1cdbd2cSJim Jagielski 110*b1cdbd2cSJim Jagielski aTest.unlockControllers(); 111*b1cdbd2cSJim Jagielski } 112*b1cdbd2cSJim Jagielski catch( Exception ex ) 113*b1cdbd2cSJim Jagielski { 114*b1cdbd2cSJim Jagielski System.out.println( "UNO Exception caught: " + ex ); 115*b1cdbd2cSJim Jagielski System.out.println( "Message: " + ex.getMessage() ); 116*b1cdbd2cSJim Jagielski } 117*b1cdbd2cSJim Jagielski 118*b1cdbd2cSJim Jagielski System.exit( 0 ); 119*b1cdbd2cSJim Jagielski } 120*b1cdbd2cSJim Jagielski 121*b1cdbd2cSJim Jagielski 122*b1cdbd2cSJim Jagielski // ________________________________________ 123*b1cdbd2cSJim Jagielski ChartInWriter( XChartDocument aChartDoc )124*b1cdbd2cSJim Jagielski public ChartInWriter( XChartDocument aChartDoc ) 125*b1cdbd2cSJim Jagielski { 126*b1cdbd2cSJim Jagielski maChartDocument = aChartDoc; 127*b1cdbd2cSJim Jagielski maDiagram = maChartDocument.getDiagram(); 128*b1cdbd2cSJim Jagielski } 129*b1cdbd2cSJim Jagielski 130*b1cdbd2cSJim Jagielski // ____________________ 131*b1cdbd2cSJim Jagielski lockControllers()132*b1cdbd2cSJim Jagielski public void lockControllers() 133*b1cdbd2cSJim Jagielski throws RuntimeException 134*b1cdbd2cSJim Jagielski { 135*b1cdbd2cSJim Jagielski ((XModel) UnoRuntime.queryInterface( XModel.class, maChartDocument )).lockControllers(); 136*b1cdbd2cSJim Jagielski } 137*b1cdbd2cSJim Jagielski 138*b1cdbd2cSJim Jagielski // ____________________ 139*b1cdbd2cSJim Jagielski unlockControllers()140*b1cdbd2cSJim Jagielski public void unlockControllers() 141*b1cdbd2cSJim Jagielski throws RuntimeException 142*b1cdbd2cSJim Jagielski { 143*b1cdbd2cSJim Jagielski ((XModel) UnoRuntime.queryInterface( XModel.class, maChartDocument )).unlockControllers(); 144*b1cdbd2cSJim Jagielski } 145*b1cdbd2cSJim Jagielski 146*b1cdbd2cSJim Jagielski // ____________________ 147*b1cdbd2cSJim Jagielski testWall()148*b1cdbd2cSJim Jagielski public void testWall() 149*b1cdbd2cSJim Jagielski throws RuntimeException, UnknownPropertyException, PropertyVetoException, 150*b1cdbd2cSJim Jagielski com.sun.star.lang.IllegalArgumentException, WrappedTargetException 151*b1cdbd2cSJim Jagielski { 152*b1cdbd2cSJim Jagielski XPropertySet aWall = ((X3DDisplay) UnoRuntime.queryInterface( 153*b1cdbd2cSJim Jagielski X3DDisplay.class, maDiagram )).getWall(); 154*b1cdbd2cSJim Jagielski 155*b1cdbd2cSJim Jagielski // change background color of area 156*b1cdbd2cSJim Jagielski aWall.setPropertyValue( "FillColor", new Integer( 0xeecc99 )); 157*b1cdbd2cSJim Jagielski aWall.setPropertyValue( "FillStyle", FillStyle.SOLID ); 158*b1cdbd2cSJim Jagielski } 159*b1cdbd2cSJim Jagielski 160*b1cdbd2cSJim Jagielski // ______________________________ 161*b1cdbd2cSJim Jagielski // 162*b1cdbd2cSJim Jagielski // private members 163*b1cdbd2cSJim Jagielski // ______________________________ 164*b1cdbd2cSJim Jagielski 165*b1cdbd2cSJim Jagielski private XChartDocument maChartDocument; 166*b1cdbd2cSJim Jagielski private XDiagram maDiagram; 167*b1cdbd2cSJim Jagielski } 168