1 /**************************************************************
2  *
3  * Licensed to the Apache Software Foundation (ASF) under one
4  * or more contributor license agreements.  See the NOTICE file
5  * distributed with this work for additional information
6  * regarding copyright ownership.  The ASF licenses this file
7  * to you under the Apache License, Version 2.0 (the
8  * "License"); you may not use this file except in compliance
9  * with the License.  You may obtain a copy of the License at
10  *
11  *   http://www.apache.org/licenses/LICENSE-2.0
12  *
13  * Unless required by applicable law or agreed to in writing,
14  * software distributed under the License is distributed on an
15  * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16  * KIND, either express or implied.  See the License for the
17  * specific language governing permissions and limitations
18  * under the License.
19  *
20  *************************************************************/
21 
22 
23 
24 import com.sun.star.lang.XComponent;
25 import com.sun.star.uno.XComponentContext;
26 import com.sun.star.uno.UnoRuntime;
27 import com.sun.star.uno.AnyConverter;
28 import com.sun.star.bridge.XUnoUrlResolver;
29 import com.sun.star.frame.XComponentLoader;
30 import com.sun.star.lang.XMultiComponentFactory;
31 import com.sun.star.lang.XMultiServiceFactory;
32 import com.sun.star.lang.XServiceInfo;
33 import com.sun.star.beans.XPropertySet;
34 import com.sun.star.beans.XPropertySetInfo;
35 import com.sun.star.beans.PropertyValue;
36 import com.sun.star.beans.UnknownPropertyException;
37 import com.sun.star.beans.PropertyVetoException;
38 import com.sun.star.text.XTextDocument;
39 import com.sun.star.text.XText;
40 import com.sun.star.text.XTextCursor;
41 import com.sun.star.text.XWordCursor;
42 import com.sun.star.text.XTextContent;
43 import com.sun.star.text.XTextTable;
44 import com.sun.star.text.XTextTableCursor;
45 import com.sun.star.table.XTableRows;
46 import com.sun.star.table.XCellRange;
47 import com.sun.star.table.XCell;
48 import com.sun.star.table.XCellCursor;
49 import com.sun.star.table.TableBorder;
50 import com.sun.star.table.BorderLine;
51 import com.sun.star.drawing.XShape;
52 import com.sun.star.awt.Size;
53 import com.sun.star.awt.Point;
54 import com.sun.star.sheet.XSpreadsheetDocument;
55 import com.sun.star.sheet.XSpreadsheet;
56 import com.sun.star.sheet.XSheetCellCursor;
57 import com.sun.star.container.XIndexAccess;
58 import com.sun.star.drawing.XDrawPagesSupplier;
59 import com.sun.star.drawing.XDrawPageSupplier;
60 import com.sun.star.drawing.XDrawPage;
61 
62 import com.sun.star.text.XTextTablesSupplier;
63 import com.sun.star.container.XNameAccess;
64 import com.sun.star.container.XNamed;
65 import com.sun.star.text.XBookmarksSupplier;
66 import com.sun.star.text.XTextRange;
67 
68 /**
69  *
70  * @author dschulten
71  */
72 public class HelloTextTableShape {
73 
74     private XComponentContext xRemoteContext = null;
75     private XMultiComponentFactory xRemoteServiceManager = null;
76 
77     /** Creates a new instance of HelloTextTableShape */
HelloTextTableShape()78     public HelloTextTableShape() {
79     }
80 
81     /**
82      * @param args the command line arguments
83      */
main(String[] args)84     public static void main(String[] args) {
85         HelloTextTableShape helloTextTableShape1 = new HelloTextTableShape();
86         try {
87             helloTextTableShape1.useDocuments();
88         }
89         catch (java.lang.Exception e){
90             System.err.println(e.getMessage());
91             e.printStackTrace();
92         }
93         finally {
94             System.exit(0);
95         }
96 
97     }
98 
useDocuments()99     protected void useDocuments() throws java.lang.Exception {
100         useWriter();
101         useCalc();
102         useDraw();
103     }
104 
useWriter()105     protected void useWriter() throws java.lang.Exception {
106         try {
107             // create new writer document and get text, then manipulate text
108             XComponent xWriterComponent = newDocComponent("swriter");
109             XTextDocument xTextDocument = (XTextDocument)UnoRuntime.queryInterface(
110                 XTextDocument.class, xWriterComponent);
111             XText xText = xTextDocument.getText();
112 
113             manipulateText(xText);
114 
115             // get internal service factory of the document
116             XMultiServiceFactory xWriterFactory = (XMultiServiceFactory)UnoRuntime.queryInterface(
117                 XMultiServiceFactory.class, xWriterComponent);
118 
119             // insert TextTable and get cell text, then manipulate text in cell
120             Object table = xWriterFactory.createInstance("com.sun.star.text.TextTable");
121             XTextContent xTextContentTable = (XTextContent)UnoRuntime.queryInterface(
122                 XTextContent.class, table);
123 
124             xText.insertTextContent(xText.getEnd(), xTextContentTable, false);
125 
126             XCellRange xCellRange = (XCellRange)UnoRuntime.queryInterface(
127                 XCellRange.class, table);
128             XCell xCell = xCellRange.getCellByPosition(0, 1);
129             XText xCellText = (XText)UnoRuntime.queryInterface(XText.class, xCell);
130 
131             manipulateText(xCellText);
132             manipulateTable(xCellRange);
133 
134             // insert RectangleShape and get shape text, then manipulate text
135             Object writerShape = xWriterFactory.createInstance(
136                 "com.sun.star.drawing.RectangleShape");
137             XShape xWriterShape = (XShape)UnoRuntime.queryInterface(
138                 XShape.class, writerShape);
139             xWriterShape.setSize(new Size(10000, 10000));
140             XTextContent xTextContentShape = (XTextContent)UnoRuntime.queryInterface(
141                 XTextContent.class, writerShape);
142 
143             xText.insertTextContent(xText.getEnd(), xTextContentShape, false);
144 
145             XPropertySet xShapeProps = (XPropertySet)UnoRuntime.queryInterface(
146                 XPropertySet.class, writerShape);
147             // wrap text inside shape
148             xShapeProps.setPropertyValue("TextContourFrame", new Boolean(true));
149 
150 
151             XText xShapeText = (XText)UnoRuntime.queryInterface(XText.class, writerShape);
152 
153             manipulateText(xShapeText);
154             manipulateShape(xWriterShape);
155 
156 /* more code snippets used in the manual:
157 
158             Object bookmark = xWriterFactory.createInstance ( "com.sun.star.text.Bookmark" );
159             // name the bookmark
160             XNamed xNamed = (XNamed) UnoRuntime.queryInterface (
161                     XNamed.class, bookmark );
162             xNamed.setName("MyUniqueBookmarkName");
163 
164             // get XTextContent interface and insert it at the end of the document
165             XTextContent xTextContent = (XTextContent) UnoRuntime.queryInterface (
166                     XTextContent.class, bookmark );
167             //mxDocText.insertTextContent ( mxDocText.getEnd(), xTextContent, false );
168             xText.insertTextContent ( xText.getEnd(), xTextContent, false );
169 
170                         //query BookmarksSupplier
171                         XBookmarksSupplier xBookmarksSupplier = (XBookmarksSupplier)UnoRuntime.queryInterface(
172                             XBookmarksSupplier.class, xWriterComponent);
173                         XNameAccess xNamedBookmarks = xBookmarksSupplier.getBookmarks();
174                         Object foundBookmark = xNamedBookmarks.getByName("MyUniqueBookmarkName");
175                         XTextContent xFoundBookmark = (XTextContent)UnoRuntime.queryInterface(XTextContent.class, foundBookmark);
176                         XTextRange xFound = xFoundBookmark.getAnchor();
177                         xFound.setString(" The throat mike, glued to her neck, "
178                             + "looked as much as possible like an analgesic dermadisk.");
179 
180 
181 
182 
183             // first query the XTextTablesSupplier interface from our document
184             XTextTablesSupplier xTablesSupplier = (XTextTablesSupplier) UnoRuntime.queryInterface(
185                     XTextTablesSupplier.class, xWriterComponent);
186             // get the tables collection
187             XNameAccess xNamedTables = xTablesSupplier.getTextTables();
188 
189             // now query the XIndexAccess from the tables collection
190             XIndexAccess xIndexedTables = (XIndexAccess) UnoRuntime.queryInterface(
191                     XIndexAccess.class, xNamedTables);
192 
193             // we need properties
194             XPropertySet xTableProps = null;
195 
196             // get the tables
197             for (int i = 0; i < xIndexedTables.getCount(); i++) {
198                     //Object table = xIndexedTables.getByIndex(i);
199                     table = xIndexedTables.getByIndex(i);
200                     xTableProps = (XPropertySet) UnoRuntime.queryInterface(
201                             XPropertySet.class, table);
202                     xTableProps.setPropertyValue("BackColor", new Integer(0xC8FFB9));
203             }
204  */
205         }
206         catch( com.sun.star.lang.DisposedException e ) { //works from Patch 1
207             xRemoteContext = null;
208             throw e;
209         }
210 
211     }
212 
useCalc()213     protected void useCalc() throws java.lang.Exception {
214         try {
215             // create new calc document and manipulate cell text
216             XComponent xCalcComponent = newDocComponent("scalc");
217             XSpreadsheetDocument xSpreadsheetDocument =
218                 (XSpreadsheetDocument)UnoRuntime.queryInterface(
219                     XSpreadsheetDocument .class, xCalcComponent);
220             Object sheets = xSpreadsheetDocument.getSheets();
221             XIndexAccess xIndexedSheets = (XIndexAccess)UnoRuntime.queryInterface(
222                 XIndexAccess.class, sheets);
223             Object sheet = xIndexedSheets.getByIndex(0);
224 
225             //get cell A2 in first sheet
226             XCellRange xSpreadsheetCells = (XCellRange)UnoRuntime.queryInterface(
227                 XCellRange.class, sheet);
228             XCell xCell = xSpreadsheetCells.getCellByPosition(0,1);
229             XPropertySet xCellProps = (XPropertySet)UnoRuntime.queryInterface(
230                 XPropertySet.class, xCell);
231             xCellProps.setPropertyValue("IsTextWrapped", new Boolean(true));
232 
233             XText xCellText = (XText)UnoRuntime.queryInterface(XText.class, xCell);
234 
235             manipulateText(xCellText);
236             manipulateTable(xSpreadsheetCells);
237 
238             // get internal service factory of the document
239             XMultiServiceFactory xCalcFactory = (XMultiServiceFactory)UnoRuntime.queryInterface(
240                 XMultiServiceFactory.class, xCalcComponent);
241             // get Drawpage
242             XDrawPageSupplier xDrawPageSupplier = (XDrawPageSupplier)UnoRuntime.queryInterface(XDrawPageSupplier.class, sheet);
243             XDrawPage xDrawPage = xDrawPageSupplier.getDrawPage();
244 
245             // create and insert RectangleShape and get shape text, then manipulate text
246             Object calcShape = xCalcFactory.createInstance(
247                 "com.sun.star.drawing.RectangleShape");
248             XShape xCalcShape = (XShape)UnoRuntime.queryInterface(
249                 XShape.class, calcShape);
250             xCalcShape.setSize(new Size(10000, 10000));
251             xCalcShape.setPosition(new Point(7000, 3000));
252 
253             xDrawPage.add(xCalcShape);
254 
255             XPropertySet xShapeProps = (XPropertySet)UnoRuntime.queryInterface(
256                 XPropertySet.class, calcShape);
257             // wrap text inside shape
258             xShapeProps.setPropertyValue("TextContourFrame", new Boolean(true));
259 
260 
261             XText xShapeText = (XText)UnoRuntime.queryInterface(XText.class, calcShape);
262 
263             manipulateText(xShapeText);
264             manipulateShape(xCalcShape);
265 
266         }
267         catch( com.sun.star.lang.DisposedException e ) { //works from Patch 1
268             xRemoteContext = null;
269             throw e;
270         }
271 
272     }
273 
useDraw()274     protected void useDraw() throws java.lang.Exception {
275         try {
276             //create new draw document and insert rectangle shape
277             XComponent xDrawComponent = newDocComponent("sdraw");
278             XDrawPagesSupplier xDrawPagesSupplier =
279                 (XDrawPagesSupplier)UnoRuntime.queryInterface(
280                     XDrawPagesSupplier.class, xDrawComponent);
281 
282             Object drawPages = xDrawPagesSupplier.getDrawPages();
283             XIndexAccess xIndexedDrawPages = (XIndexAccess)UnoRuntime.queryInterface(
284                 XIndexAccess.class, drawPages);
285             Object drawPage = xIndexedDrawPages.getByIndex(0);
286             XDrawPage xDrawPage = (XDrawPage)UnoRuntime.queryInterface(XDrawPage.class, drawPage);
287 
288             // get internal service factory of the document
289             XMultiServiceFactory xDrawFactory =
290                 (XMultiServiceFactory)UnoRuntime.queryInterface(
291                     XMultiServiceFactory.class, xDrawComponent);
292 
293             Object drawShape = xDrawFactory.createInstance(
294                 "com.sun.star.drawing.RectangleShape");
295             XShape xDrawShape = (XShape)UnoRuntime.queryInterface(XShape.class, drawShape);
296             xDrawShape.setSize(new Size(10000, 20000));
297             xDrawShape.setPosition(new Point(5000, 5000));
298             xDrawPage.add(xDrawShape);
299 
300             XText xShapeText = (XText)UnoRuntime.queryInterface(XText.class, drawShape);
301             XPropertySet xShapeProps = (XPropertySet)UnoRuntime.queryInterface(
302                 XPropertySet.class, drawShape);
303 
304             // wrap text inside shape
305             xShapeProps.setPropertyValue("TextContourFrame", new Boolean(true));
306 
307             manipulateText(xShapeText);
308             manipulateShape(xDrawShape);
309         }
310         catch( com.sun.star.lang.DisposedException e ) { //works from Patch 1
311             xRemoteContext = null;
312             throw e;
313         }
314 
315 
316     }
317 
manipulateText(XText xText)318     protected void manipulateText(XText xText) throws com.sun.star.uno.Exception {
319         // simply set whole text as one string
320         xText.setString("He lay flat on the brown, pine-needled floor of the forest, "
321             + "his chin on his folded arms, and high overhead the wind blew in the tops "
322             + "of the pine trees.");
323 
324         // create text cursor for selecting and formatting
325         XTextCursor xTextCursor = xText.createTextCursor();
326         XPropertySet xCursorProps = (XPropertySet)UnoRuntime.queryInterface(
327             XPropertySet.class, xTextCursor);
328 
329         // use cursor to select "He lay" and apply bold italic
330         xTextCursor.gotoStart(false);
331         xTextCursor.goRight((short)6, true);
332         // from CharacterProperties
333         xCursorProps.setPropertyValue("CharPosture",
334             com.sun.star.awt.FontSlant.ITALIC);
335         xCursorProps.setPropertyValue("CharWeight",
336             new Float(com.sun.star.awt.FontWeight.BOLD));
337 
338         // add more text at the end of the text using insertString
339         xTextCursor.gotoEnd(false);
340         xText.insertString(xTextCursor, " The mountainside sloped gently where he lay; "
341             + "but below it was steep and he could see the dark of the oiled road "
342             + "winding through the pass. There was a stream alongside the road "
343             + "and far down the pass he saw a mill beside the stream and the falling water "
344             + "of the dam, white in the summer sunlight.", false);
345         // after insertString the cursor is behind the inserted text, insert more text
346         xText.insertString(xTextCursor, "\n  \"Is that the mill?\" he asked.", false);
347     }
348 
manipulateTable(XCellRange xCellRange)349     protected void manipulateTable(XCellRange xCellRange) throws com.sun.star.uno.Exception {
350 
351         String backColorPropertyName = "";
352         XPropertySet xTableProps = null;
353 
354         // enter column titles and a cell value
355         XCell xCell = xCellRange.getCellByPosition(0,0);
356         XText xCellText = (XText)UnoRuntime.queryInterface(XText.class, xCell);
357         xCellText.setString("Quotation");
358         xCell = xCellRange.getCellByPosition(1,0);
359         xCellText = (XText)UnoRuntime.queryInterface(XText.class, xCell);
360         xCellText.setString("Year");
361         xCell = xCellRange.getCellByPosition(1,1);
362         xCell.setValue(1940);
363         XCellRange xSelectedCells = xCellRange.getCellRangeByName("A1:B1");
364         XPropertySet xCellProps = (XPropertySet)UnoRuntime.queryInterface(
365             XPropertySet.class, xSelectedCells);
366 
367         // format table headers and table borders
368         // we need to distinguish text and sheet tables:
369         // property name for cell colors is different in text and sheet cells
370         // we want to apply TableBorder to whole text table, but only to sheet cells with content
371         XServiceInfo xServiceInfo = (XServiceInfo)UnoRuntime.queryInterface(
372             XServiceInfo.class, xCellRange);
373         if (xServiceInfo.supportsService("com.sun.star.sheet.Spreadsheet")) {
374             backColorPropertyName = "CellBackColor";
375             xSelectedCells = xCellRange.getCellRangeByName("A1:B2");
376             xTableProps = (XPropertySet)UnoRuntime.queryInterface(
377                 XPropertySet.class, xSelectedCells);
378         }
379         else if (xServiceInfo.supportsService("com.sun.star.text.TextTable")) {
380             backColorPropertyName = "BackColor";
381             xTableProps = (XPropertySet)UnoRuntime.queryInterface(
382                 XPropertySet.class, xCellRange);
383         }
384         // set cell background color
385         xCellProps.setPropertyValue(backColorPropertyName, new Integer(0x99CCFF));
386 
387         // set table borders
388         // create description for blue line, width 10
389         BorderLine theLine = new BorderLine();
390         theLine.Color = 0x000099;
391         theLine.OuterLineWidth = 10;
392         // apply line description to all border lines and make them valid
393         TableBorder bord = new TableBorder();
394         bord.VerticalLine = bord.HorizontalLine =
395             bord.LeftLine = bord.RightLine =
396             bord.TopLine = bord.BottomLine =
397                 theLine;
398         bord.IsVerticalLineValid = bord.IsHorizontalLineValid =
399             bord.IsLeftLineValid = bord.IsRightLineValid =
400             bord.IsTopLineValid = bord.IsBottomLineValid =
401                 true;
402 
403         xTableProps.setPropertyValue("TableBorder", bord);
404 
405         bord = (TableBorder)xTableProps.getPropertyValue("TableBorder");
406         theLine = bord.TopLine;
407         int col = theLine.Color;
408         System.out.println(col);
409     }
410 
manipulateShape(XShape xShape)411     protected void manipulateShape(XShape xShape) throws com.sun.star.uno.Exception {
412         XPropertySet xShapeProps = (XPropertySet)UnoRuntime.queryInterface(XPropertySet.class, xShape);
413         xShapeProps.setPropertyValue("FillColor", new Integer(0x99CCFF));
414         xShapeProps.setPropertyValue("LineColor", new Integer(0x000099));
415         xShapeProps.setPropertyValue("RotateAngle", new Integer(3000));
416 
417         xShapeProps.setPropertyValue("TextLeftDistance", new Integer(0));
418         xShapeProps.setPropertyValue("TextRightDistance", new Integer(0));
419         xShapeProps.setPropertyValue("TextUpperDistance", new Integer(0));
420         xShapeProps.setPropertyValue("TextLowerDistance", new Integer(0));
421     }
422 
423 
newDocComponent(String docType)424     protected XComponent newDocComponent(String docType) throws java.lang.Exception {
425         String loadUrl = "private:factory/" + docType;
426         xRemoteServiceManager = this.getRemoteServiceManager();
427         Object desktop = xRemoteServiceManager.createInstanceWithContext(
428             "com.sun.star.frame.Desktop", xRemoteContext);
429         XComponentLoader xComponentLoader = (XComponentLoader)UnoRuntime.queryInterface(
430             XComponentLoader.class, desktop);
431         PropertyValue[] loadProps = new PropertyValue[0];
432         return xComponentLoader.loadComponentFromURL(loadUrl, "_blank", 0, loadProps);
433     }
434 
getRemoteServiceManager()435     protected XMultiComponentFactory getRemoteServiceManager() throws java.lang.Exception {
436         if (xRemoteContext == null && xRemoteServiceManager == null) {
437             try {
438                 // First step: get the remote office component context
439                 xRemoteContext = com.sun.star.comp.helper.Bootstrap.bootstrap();
440                 System.out.println("Connected to a running office ...");
441 
442                 xRemoteServiceManager = xRemoteContext.getServiceManager();
443             }
444             catch( Exception e) {
445                 e.printStackTrace();
446                 System.exit(1);
447             }
448         }
449         return xRemoteServiceManager;
450     }
451 }
452