1 /*************************************************************************
2  *
3  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
4  *
5  * Copyright 2000, 2010 Oracle and/or its affiliates.
6  *
7  * OpenOffice.org - a multi-platform office productivity suite
8  *
9  * This file is part of OpenOffice.org.
10  *
11  * OpenOffice.org is free software: you can redistribute it and/or modify
12  * it under the terms of the GNU Lesser General Public License version 3
13  * only, as published by the Free Software Foundation.
14  *
15  * OpenOffice.org is distributed in the hope that it will be useful,
16  * but WITHOUT ANY WARRANTY; without even the implied warranty of
17  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
18  * GNU Lesser General Public License version 3 for more details
19  * (a copy is included in the LICENSE file that accompanied this code).
20  *
21  * You should have received a copy of the GNU Lesser General Public License
22  * version 3 along with OpenOffice.org.  If not, see
23  * <http://www.openoffice.org/license.html>
24  * for a copy of the LGPLv3 License.
25  *
26  ************************************************************************/
27 package ifc.sheet;
28 
29 import com.sun.star.sheet.XSpreadsheet;
30 import com.sun.star.sheet.XSpreadsheetDocument;
31 import com.sun.star.table.XCell;
32 import com.sun.star.uno.UnoRuntime;
33 
34 import lib.MultiPropertyTest;
35 
36 
37 public class _Shape extends MultiPropertyTest {
38     public void _Anchor() {
39         XSpreadsheetDocument xSheetDoc = (XSpreadsheetDocument) UnoRuntime.queryInterface(
40                                                  XSpreadsheetDocument.class,
41                                                  tEnv.getObjRelation(
42                                                          "DOCUMENT"));
43         String[] sheetNames = xSheetDoc.getSheets().getElementNames();
44         XSpreadsheet xSheet = null;
45         XCell xCell = null;
46 
47         try {
48             xSheet = (XSpreadsheet) UnoRuntime.queryInterface(
49                              XSpreadsheet.class,
50                              xSheetDoc.getSheets().getByName(sheetNames[0]));
51             xCell = xSheet.getCellByPosition(0, 0);
52         } catch (com.sun.star.container.NoSuchElementException e) {
53             e.printStackTrace();
54         } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
55             e.printStackTrace();
56         } catch (com.sun.star.lang.WrappedTargetException e) {
57             e.printStackTrace();
58         }
59 
60         testProperty("Anchor", xSheet, xCell);
61     }
62 }