Package com.sun.star.sheet

Examples of com.sun.star.sheet.SingleReference

89
90
91
92
93
94
95
96
97
98
99
    }

    protected FormulaToken getRefToken(XCell xCell) {
        XCellAddressable xCellAddr =  (XCellAddressable)UnoRuntime.queryInterface(XCellAddressable.class, xCell);
        CellAddress addr = xCellAddr.getCellAddress();
        SingleReference ref = new SingleReference();
        ref.Column = addr.Column;
        ref.Row    = addr.Row;
        ref.Sheet  = addr.Sheet;
        ref.Flags = ReferenceFlags.SHEET_3D;
        FormulaToken token = new FormulaToken();
View Full Code Here
251
252
253
254
255
256
257
258
259
260
261
        FormulaToken token = tokens[0];

        if (SingleReference.class == token.Data.getClass()){

            SingleReference ref = (SingleReference)token.Data;
            m_xValidSheet = getSheetByIndex(ref.Sheet);
            if (m_xValidSheet == null)
                return false;
            m_selectedCellToken = new FormulaToken[1];
            m_selectedCellToken[0] = token;
View Full Code Here
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
    }

    @Override
    public String toString(){
       
        SingleReference formulaCellRef = (SingleReference)getGui().getController().getRefToken(m_xCell).Data;

        String itemValue = getGui().createStringWithSpace( getGui().getController().getCellName( m_xCell ).replace("$", ""), 24 );
        itemValue += getErrorMessage(); // get errorXXX original message, it independent even if the formula had been corrected

        if( m_ErrorType == 0 ) {
            itemValue += " - " + getGui().getDialogPropertyValue("Strings", "Strings.correctedLabel.Label");
        } else {
            if( m_ErrorType != 3 ){
                String sCells = "";
                String currCellName = "";
                if( m_lNotValidPrecCells != null ) {
                    for (XCell currXCell : m_lNotValidPrecCells){
                        SingleReference currCellRef = (SingleReference)getGui().getController().getRefToken(currXCell).Data;
                        currCellName = (currCellRef.Sheet == formulaCellRef.Sheet) ? "" : getGui().getController().getSheetNameByIndex(currCellRef.Sheet) + ".";
                        currCellName += getGui().getController().getCellName(currXCell).replace("$", "");
                        sCells += " " + currCellName;
                    }
                }
View Full Code Here
342
343
344
345
346
347
348
349
350
351
352
    }

    public String getMemberCellSheetName(){
        String sheetName = "";
        if(m_number == _selectedItemPos ) {
            SingleReference cellRef = (SingleReference)getGui().getController().getRefToken( m_xCell ).Data;
            cellRef.Flags = 128;
            String activeCellName = getGui().getController().getActiveSheetName();
            String currSheetName = getGui().getController().getSheetNameByIndex(cellRef.Sheet);
            sheetName = currSheetName.equals(activeCellName) ? "" : currSheetName + ".";
        }
View Full Code Here
372
373
374
375
376
377
378
379
380
381
382
        return parseFormula(tokens);
    }

    public String getCellName(XCell xCell) {
        FormulaToken formulaToken = getRefToken(xCell);
        SingleReference ref = (SingleReference)formulaToken.Data;
        // We don't want to display the sheet name, and the cell position should be absolute, not relative.
        ref.Flags = 0;
        FormulaToken[] tokens = { formulaToken };
        XFormulaParser xParser = getFormulaParser();
        XCellAddressable xCellAddr =  (XCellAddressable)UnoRuntime.queryInterface(XCellAddressable.class, xCell);
View Full Code Here
385
386
387
388
389
390
391
392
393
394
395
    }

    protected FormulaToken getRefToken(XCell xCell) {
        XCellAddressable xCellAddr =  (XCellAddressable)UnoRuntime.queryInterface(XCellAddressable.class, xCell);
        CellAddress addr = xCellAddr.getCellAddress();
        SingleReference ref = new SingleReference();
        ref.Column = addr.Column;
        ref.Row    = addr.Row;
        ref.Sheet  = addr.Sheet;
        ref.Flags = ReferenceFlags.SHEET_3D;
        FormulaToken token = new FormulaToken();
View Full Code Here
445
446
447
448
449
450
451
452
453
454
455
                address.EndColumn   = ref.Reference2.Column;
                address.EndRow      = ref.Reference2.Row;
                lAddresses.add( address );
            }
            if(tokens[i].Data.toString().startsWith("com.sun.star.sheet.SingleReference")){
                SingleReference ref = (SingleReference)tokens[i].Data;
                ref.Flags = 0;

                CellRangeAddress address = new CellRangeAddress();
                address.Sheet = (short)ref.Sheet;
                address.StartColumn = address.EndColumn = ref.Column;
View Full Code Here
30
31
32
33
34
35
36
37
38
39
40
        short num = 0;

        XNamed xNamed = (XNamed)UnoRuntime.queryInterface(XNamed.class, xValidSheet);
        String sheetName = xNamed.getName();

        SingleReference ref = (SingleReference)selectedCellToken.Data;
        ref.Flags = 0;
       
        CellAddress addr = new CellAddress();
        addr.Sheet = (short)ref.Sheet;
        addr.Column = (short)ref.Column;
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
    }
   
    public void init() throws IndexOutOfBoundsException {

        //m_xCell is the basic of WatchedCell objects. This won't be changed!
        SingleReference ref = (SingleReference) m_cellToken.Data;
        m_xCell = m_xSpreadsheet.getCellByPosition(ref.Column, ref.Row);

        setValue();
        setFormula();
View Full Code Here
105
106
107
108
109
110
111
112
113
114
115
        }
    }

    public void setCellName(){
        m_cellToken = getController().getRefToken(m_xCell);
        SingleReference ref = (SingleReference)m_cellToken.Data;
        // We don't want to display the sheet name, and the cell position should be absolute, not relative.
        ref.Flags = 0;
        FormulaToken[] tokens = { m_cellToken };
        XCellAddressable xCellAddr =  (XCellAddressable)UnoRuntime.queryInterface(XCellAddressable.class, m_xCell);
        CellAddress addr = xCellAddr.getCellAddress();
View Full Code Here
TOP

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

  • org.openoffice.extensions.validator.Cell
  • org.openoffice.extensions.validator.Controller
  • org.openoffice.extensions.watchwindow.Controller
  • org.openoffice.extensions.watchwindow.DataModel
  • org.openoffice.extensions.watchwindow.WatchedCell
    • 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.