Package com.sun.star.sheet

Examples of com.sun.star.sheet.XSheetAuditing

129
130
131
132
133
134
135
136
137
138
139
140
141
            xSheet[0].getCellByPosition(6, 6).setValue(9);
            XNamed xNamed = (XNamed)UnoRuntime.queryInterface(XNamed.class, xSheet[0]);
            sheetName = xNamed.getName();
            xSheet[1].getCellByPosition(6, 6).setValue(16);
            xSheet[1].getCellByPosition(6, 7).setFormula("= SQRT(G7)");
            XSheetAuditing xSheetAuditing = (XSheetAuditing)UnoRuntime.queryInterface(XSheetAuditing.class, xSheet[1]);
            CellAddress add = new CellAddress((short)1, 6, 7);
            xSheetAuditing.showPrecedents(add);
            boolean ok = hasRightAmountOfShapes(1);
            if (!ok)
                throw new StatusException(Status.failed("Wrong amount of shapes on page."));
        }
        catch(com.sun.star.lang.IndexOutOfBoundsException e) {
View Full Code Here
126
127
128
129
130
131
132
133
134
135
136
137
138
            xSheet[0].getCellByPosition(6, 6).setValue(9);
            XNamed xNamed = (XNamed)UnoRuntime.queryInterface(XNamed.class, xSheet[0]);
            sheetName = xNamed.getName();
            xSheet[1].getCellByPosition(6, 6).setValue(16);
            xSheet[1].getCellByPosition(6, 7).setFormula("= SQRT(G7)");
            XSheetAuditing xSheetAuditing = (XSheetAuditing)UnoRuntime.queryInterface(XSheetAuditing.class, xSheet[1]);
            CellAddress add = new CellAddress((short)1, 6, 7);
            xSheetAuditing.showPrecedents(add);
            boolean ok = hasRightAmountOfShapes(1);
            if (!ok)
                throw new StatusException(Status.failed("Wrong amount of shapes on page."));
        }
        catch(com.sun.star.lang.IndexOutOfBoundsException e) {
View Full Code Here
119
120
121
122
123
124
125
126
127
128
129
130
131
            xSheet[0].getCellByPosition(6, 6).setValue(9);
            XNamed xNamed = (XNamed)UnoRuntime.queryInterface(XNamed.class, xSheet[0]);
            sheetName = xNamed.getName();
            xSheet[1].getCellByPosition(6, 6).setValue(16);
            xSheet[1].getCellByPosition(6, 7).setFormula("= SQRT(G7)");
            XSheetAuditing xSheetAuditing = (XSheetAuditing)UnoRuntime.queryInterface(XSheetAuditing.class, xSheet[1]);
            CellAddress add = new CellAddress((short)1, 6, 7);
            xSheetAuditing.showPrecedents(add);
            boolean ok = hasRightAmountOfShapes(1);
            if (!ok)
                throw new StatusException(Status.failed("Wrong amount of shapes on page."));
        }
        catch(com.sun.star.lang.IndexOutOfBoundsException e) {
View Full Code Here
123
124
125
126
127
128
129
130
131
132
133
134
135
            xSheet[0].getCellByPosition(6, 6).setValue(9);
            XNamed xNamed = (XNamed)UnoRuntime.queryInterface(XNamed.class, xSheet[0]);
            sheetName = xNamed.getName();
            xSheet[1].getCellByPosition(6, 6).setValue(16);
            xSheet[1].getCellByPosition(6, 7).setFormula("= SQRT(G7)");
            XSheetAuditing xSheetAuditing = (XSheetAuditing)UnoRuntime.queryInterface(XSheetAuditing.class, xSheet[1]);
            CellAddress add = new CellAddress((short)1, 6, 7);
            xSheetAuditing.showPrecedents(add);
            boolean ok = hasRightAmountOfShapes(1);
            if (!ok)
                throw new StatusException(Status.failed("Wrong amount of shapes on page."));
        }
        catch(com.sun.star.lang.IndexOutOfBoundsException e) {
View Full Code Here
725
726
727
728
729
730
731
732
733
734
735
            showPrecedents(false);
    }

    public void showPrecedents( boolean bool ){
        CellAddress addr = getListBoxSelectedItemAddress();
        XSheetAuditing xSheetAuditing = (XSheetAuditing)UnoRuntime.queryInterface( XSheetAuditing.class, getController().getActiveSheet() );
        if( bool )
            xSheetAuditing.showPrecedents(addr);
        else
            xSheetAuditing.hidePrecedents(addr);
    }
View Full Code Here
741
742
743
744
745
746
747
748
749
750
751
            showDependents(false);
    }

    public void showDependents( boolean bool ){
        CellAddress addr = getListBoxSelectedItemAddress();
        XSheetAuditing xSheetAuditing = (XSheetAuditing)UnoRuntime.queryInterface( XSheetAuditing.class, getController().getActiveSheet() );
        if( bool )
            xSheetAuditing.showDependents(addr);
        else
            xSheetAuditing.hideDependents(addr);
    }
View Full Code Here
749
750
751
752
753
754
755
756
757
758
        else
            xSheetAuditing.hideDependents(addr);
    }

    public void clearArrows(){
        XSheetAuditing xSheetAuditing = null;
        xSheetAuditing = (XSheetAuditing) UnoRuntime.queryInterface( XSheetAuditing.class, getController().getActiveSheet() );
        if(xSheetAuditing != null)
            xSheetAuditing.clearArrows();
    }
View Full Code Here
756
757
758
759
760
761
762
763
764
765
        if(xSheetAuditing != null)
            xSheetAuditing.clearArrows();
    }

    public void clearArrowsOfClosingSheet(){
        XSheetAuditing xSheetAuditing = null;
        xSheetAuditing = (XSheetAuditing) UnoRuntime.queryInterface( XSheetAuditing.class, getController().getClosingActiveSheet() );
        if(xSheetAuditing != null)
            xSheetAuditing.clearArrows();
    }
View Full Code Here
134
135
136
137
138
139
140
141
142
143
144
145
146
            xSheet[0].getCellByPosition(6, 6).setValue(9);
            XNamed xNamed = (XNamed)UnoRuntime.queryInterface(XNamed.class, xSheet[0]);
            sheetName = xNamed.getName();
            xSheet[1].getCellByPosition(6, 6).setValue(16);
            xSheet[1].getCellByPosition(6, 7).setFormula("= SQRT(G7)");
            XSheetAuditing xSheetAuditing = (XSheetAuditing)UnoRuntime.queryInterface(XSheetAuditing.class, xSheet[1]);
            CellAddress add = new CellAddress((short)1, 6, 7);
            xSheetAuditing.showPrecedents(add);
            boolean ok = hasRightAmountOfShapes(1);
            if (!ok)
                throw new StatusException(Status.failed("Wrong amount of shapes on page."));
        }
        catch(com.sun.star.lang.IndexOutOfBoundsException e) {
View Full Code Here
123
124
125
126
127
128
129
130
131
132
133
134
135
            xSheet[0].getCellByPosition(6, 6).setValue(9);
            XNamed xNamed = (XNamed)UnoRuntime.queryInterface(XNamed.class, xSheet[0]);
            sheetName = xNamed.getName();
            xSheet[1].getCellByPosition(6, 6).setValue(16);
            xSheet[1].getCellByPosition(6, 7).setFormula("= SQRT(G7)");
            XSheetAuditing xSheetAuditing = (XSheetAuditing)UnoRuntime.queryInterface(XSheetAuditing.class, xSheet[1]);
            CellAddress add = new CellAddress((short)1, 6, 7);
            xSheetAuditing.showPrecedents(add);
            boolean ok = hasRightAmountOfShapes(1);
            if (!ok)
                throw new StatusException(Status.failed("Wrong amount of shapes on page."));
        }
        catch(com.sun.star.lang.IndexOutOfBoundsException e) {
View Full Code Here
TOP

Related Classes of com.sun.star.sheet.XSheetAuditing

  • ifc.sheet._XDocumentAuditing
  • org.openoffice.extensions.validator.Gui
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.