Package com.sun.star.sheet

Examples of com.sun.star.sheet.XFormulaParser

237
238
239
240
241
242
243
244
245
246
247
248
249
        return s;
    }

    //check the input of user and adjust m_xValidSheet, m_selectedCellPos members
    public boolean isValidSelectedName(String selectAreaName){
        XFormulaParser xParser = getFormulaParser();
        CellAddress origin = new CellAddress();
        FormulaToken[] tokens = xParser.parseFormula(selectAreaName, origin);
        if (tokens.length == 0)
            return false;

        for(int i = 0 ; i < tokens.length; i++)
            if (tokens[i].OpCode != 0)
View Full Code Here
376
377
378
379
380
381
382
383
384
385
        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);
        CellAddress addr = xCellAddr.getCellAddress();
        return xParser.printFormula(tokens, addr);
    }
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
50
51
        addr.Sheet = (short)ref.Sheet;
        addr.Column = (short)ref.Column;
        addr.Row = (short)ref.Row;

        FormulaToken[] tokens = { selectedCellToken };
        XFormulaParser xParser = m_Controller.getFormulaParser();

        String selectedCellName = xParser.printFormula(tokens, addr);

        for(WatchedCell item: m_list){
            if(item.getSheetName().equals(sheetName) && item.getCellName().equals(selectedCellName)){
                bool = false;
                num = item.getNum();
View Full Code Here
111
112
113
114
115
116
117
118
        // 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();
        XFormulaParser xParser = m_Controller.getFormulaParser();
        m_cellName = xParser.printFormula(tokens, addr);
    }
View Full Code Here
TOP

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

  • 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.