Examples of com.sun.star.sheet.XCellRangeAddressable

com.sun.star.sheet.XCellRangeAddressable

    * Has <b> OK </b> status if the range address expands at all used area
    * in first case and if the range address just points to the cell at the
    * start of the used area in second case. <p>
    */
    public void _gotoStartOfUsedArea() {
        XCellRangeAddressable oAddr = (XCellRangeAddressable)
                UnoRuntime.queryInterface (XCellRangeAddressable.class, oObj) ;


        boolean result = true ;


        // with true parameter first
        oObj.gotoEndOfUsedArea(false);
        oObj.gotoStartOfUsedArea(true);
        sAddr = oAddr.getRangeAddress();


        result &= (sAddr.StartColumn == 1);
        result &= (sAddr.StartRow == 1);
        result &= (sAddr.EndColumn == 4);
        result &= (sAddr.EndRow == 5);
        
        // now testing with false parameter
        oObj.gotoStartOfUsedArea(false);
        sAddr = oAddr.getRangeAddress();


        result &= (sAddr.StartColumn == 1);
        result &= (sAddr.StartRow == 1);
        result &= (sAddr.EndColumn == 1);
        result &= (sAddr.EndRow == 1);

View Full Code Here

        } catch (com.sun.star.lang.IndexOutOfBoundsException e) {
            e.printStackTrace(log);
            tRes.tested("copyRange()", false);
        }


        XCellRangeAddressable oAddr =
            (XCellRangeAddressable)
                 UnoRuntime.queryInterface (XCellRangeAddressable.class, oObj);
        short iSheet = oAddr.getRangeAddress().Sheet;
        CellAddress sDest;
        CellRangeAddress sSrc;


        sSrc = new CellRangeAddress(iSheet, 1, 1, 2, 2);
        sDest = new CellAddress(iSheet, 1, 10);

View Full Code Here

    public void _insertCells(){
        boolean result = false;


        XSpreadsheet oSheet = (XSpreadsheet)
            UnoRuntime.queryInterface(XSpreadsheet.class, oObj);
        XCellRangeAddressable oAddr = (XCellRangeAddressable)
            UnoRuntime.queryInterface (XCellRangeAddressable.class, oObj);
        short iSheet = oAddr.getRangeAddress().Sheet;
        try {
            oSheet.getCellByPosition(0,20).setValue(100);
            oSheet.getCellByPosition(1,20).setValue(100);
            oSheet.getCellByPosition(2,20).setValue(100);
            oSheet.getCellByPosition(3,20).setValue(100);

View Full Code Here

        boolean result = false;


        XSpreadsheet oSheet = (XSpreadsheet)
            UnoRuntime.queryInterface(XSpreadsheet.class, oObj);


        XCellRangeAddressable oAddr = (XCellRangeAddressable)
            UnoRuntime.queryInterface (XCellRangeAddressable.class, oObj);


        short iSheet = oAddr.getRangeAddress().Sheet;
        //prepare source range
        try {
            oSheet.getCellByPosition(4,0).setValue(111);
            oSheet.getCellByPosition(4,1).setValue(222);

View Full Code Here

    public void _removeRange(){
        boolean result = false;


        XSpreadsheet oSheet = (XSpreadsheet)
            UnoRuntime.queryInterface(XSpreadsheet.class, oObj);
        XCellRangeAddressable oAddr = (XCellRangeAddressable)
            UnoRuntime.queryInterface (XCellRangeAddressable.class, oObj);
        short iSheet = oAddr.getRangeAddress().Sheet;
        try {
            //prepare source range
            oSheet.getCellByPosition(5, 0).setValue(333);
            oSheet.getCellByPosition(5, 1).setValue(444);

View Full Code Here

    }
    
    // method returns false if the ranges are equal and true otherwise
    
    private boolean compareRanges(Object old, Object newEl) {
        XCellRangeAddressable xCRA = (XCellRangeAddressable) 
                UnoRuntime.queryInterface(XCellRangeAddressable.class,old);
        
        XCellRangeAddressable xCRA2 = (XCellRangeAddressable) 
                UnoRuntime.queryInterface(XCellRangeAddressable.class,newEl);
                
        int orgStartCol = xCRA.getRangeAddress().StartColumn;
        int orgEndCol = xCRA.getRangeAddress().EndColumn;        
        int orgStartRow = xCRA.getRangeAddress().StartRow;
        int orgEndRow = xCRA.getRangeAddress().EndRow;                
        
        int newStartCol = xCRA2.getRangeAddress().StartColumn;
        int newEndCol = xCRA2.getRangeAddress().EndColumn;        
        int newStartRow = xCRA2.getRangeAddress().StartRow;
        int newEndRow = xCRA2.getRangeAddress().EndRow;
        
        boolean ret = true;
        
        if (orgStartCol == newStartCol) {
            log.println("\t StartColumn is the same");

View Full Code Here

    oRect.Width = 25000;
    oRect.Height = 11000;
    
    XCellRange oRange = (XCellRange)UnoRuntime.queryInterface(XCellRange.class, oSheet);
    XCellRange myRange = oRange.getCellRangeByName("A1:n4");
    XCellRangeAddressable oRangeAddr = (XCellRangeAddressable)UnoRuntime.queryInterface(
            XCellRangeAddressable.class, myRange);
    CellRangeAddress myAddr = oRangeAddr.getRangeAddress();


    CellRangeAddress[] oAddr = new CellRangeAddress[1];
    oAddr[0] = myAddr;
    XTableChartsSupplier oSupp = (XTableChartsSupplier)UnoRuntime.queryInterface(
            XTableChartsSupplier.class, oSheet);

View Full Code Here

            // Get the cell range of the written values.
            XCellRange xcellrangeChart = xcellrange.getCellRangeByName( "A1:" +
            charRectangle + intMaximumWidthRow );
            
            // Get the addressable cell range.
            XCellRangeAddressable xcellrangeaddressable =
            ( XCellRangeAddressable ) UnoRuntime.queryInterface(
                XCellRangeAddressable.class, xcellrangeChart );
            
            // Get the cell range address.
            CellRangeAddress cellrangeaddress = xcellrangeaddressable.getRangeAddress();
            
            // Create the cell range address for the chart.
            CellRangeAddress[] cellrangeaddressChart =
            new CellRangeAddress[ 1 ];
            cellrangeaddressChart[ 0 ] = cellrangeaddress;

View Full Code Here

    public XCell[] getActiveCells(){
        XCell[] xCells = null;
        try {
            Object obj = m_xModel.getCurrentSelection();
            m_Gui.test(obj);
            XCellRangeAddressable xCellRangeAddressable = (XCellRangeAddressable) UnoRuntime.queryInterface(XCellRangeAddressable.class, obj);
            CellRangeAddress cellRangeAddress = xCellRangeAddressable.getRangeAddress();
            int n = cellRangeAddress.EndColumn - cellRangeAddress.StartColumn + 1;
            int m = cellRangeAddress.EndRow - cellRangeAddress.StartRow + 1;
            xCells = new XCell[n*m];
            XCellRange xCellRange = getSheetByIndex(cellRangeAddress.Sheet).getCellRangeByPosition(cellRangeAddress.StartColumn, cellRangeAddress.StartRow, cellRangeAddress.EndColumn, cellRangeAddress.EndRow);
            int ii = 0;

View Full Code Here

        return true;
    }


    public void addCell() {
        Object obj = m_xModel.getCurrentSelection();
        XCellRangeAddressable xCellRangeAddr =  (XCellRangeAddressable)UnoRuntime.queryInterface(XCellRangeAddressable.class, obj);
        if(xCellRangeAddr == null){
            try {
                XSheetCellRangeContainer xSheetCellRangeContainer = (XSheetCellRangeContainer) UnoRuntime.queryInterface(XSheetCellRangeContainer.class, obj);
                Object oRange = xSheetCellRangeContainer.getByIndex(0);
                xCellRangeAddr = (XCellRangeAddressable) UnoRuntime.queryInterface(XCellRangeAddressable.class, oRange);
            } catch (IndexOutOfBoundsException ex) {
                ex.printStackTrace();
            } catch (WrappedTargetException ex) {
                ex.printStackTrace();
            }
        }
        CellRangeAddress rangeAddr = xCellRangeAddr.getRangeAddress();
        ComplexReference ref = new ComplexReference();
        ref.Reference1.Column = rangeAddr.StartColumn;
        ref.Reference1.Row    = rangeAddr.StartRow;
        ref.Reference1.Sheet  = rangeAddr.Sheet;
        ref.Reference1.Flags = ReferenceFlags.SHEET_3D;

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

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

ChartTypeChange

com.sun.star.comp.demo.SCalcDemo

complex.sc.CalcRTL

ifc.container._XNameReplace

ifc.sheet._XArrayFormulaRange

ifc.sheet._XCellRangeMovement

ifc.sheet._XCellRangeReferrer

ifc.sheet._XMultipleOperation

ifc.sheet._XNamedRanges

ifc.sheet._XSheetCellCursor

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.