Package org.apache.poi.hssf.record.formula

Examples of org.apache.poi.hssf.record.formula.Ptg.toFormulaString()

654
655
656
657
658
659
660
661
662
663
664
        if (ptg.getClass() == Area3DPtg.class){
            result = ptg.toFormulaString(refs);

        } else if (ptg.getClass() == Ref3DPtg.class){
            result = ptg.toFormulaString(refs);
        }

        return result;
    }
View Full Code Here
159
160
161
162
163
164
165
166
167
168
169
        StringBuffer buf = new StringBuffer();
    Ptg[] tokens = record.getParsedExpression();
    for (int i = 0; i < tokens.length; i++) {
      Ptg token = tokens[i];
            buf.append( token.toFormulaString());
            switch (token.getPtgClass()) {
                case Ptg.CLASS_REF :
                    buf.append("(R)");
                    break;
                case Ptg.CLASS_VALUE :
View Full Code Here
91
92
93
94
95
96
97
98
99
100
101
                WorkbookDependentFormula optg = (WorkbookDependentFormula) ptg;
                stack.push(optg.toFormulaString(book));
                continue;
            }
            if (! (ptg instanceof OperationPtg)) {
                stack.push(ptg.toFormulaString());
                continue;
            }

            OperationPtg o = (OperationPtg) ptg;
            String[] operands = getOperands(stack, o.getNumberOfOperands());
View Full Code Here
91
92
93
94
95
96
97
98
99
100
101
                WorkbookDependentFormula optg = (WorkbookDependentFormula) ptg;
        stack.push(optg.toFormulaString(book));
                continue;
            }
            if (! (ptg instanceof OperationPtg)) {
                stack.push(ptg.toFormulaString());
                continue;
            }

            OperationPtg o = (OperationPtg) ptg;
            String[] operands = getOperands(stack, o.getNumberOfOperands());
View Full Code Here
874
875
876
877
878
879
880
881
882
883
884
    Ptg[] ptgs;
    ptgs = parseFormula("mode({1,2,2,#REF!;FALSE,3,3,2})");
    assertEquals(2, ptgs.length);
    Ptg ptg0 = ptgs[0];
    assertEquals(ArrayPtg.class, ptg0.getClass());
    assertEquals("{1.0,2.0,2.0,#REF!;FALSE,3.0,3.0,2.0}", ptg0.toFormulaString());

    ArrayPtg aptg = (ArrayPtg) ptg0;
    Object[][] values = aptg.getTokenArrayValues();
    assertEquals(ErrorConstant.valueOf(HSSFErrorConstants.ERROR_REF), values[0][3]);
    assertEquals(Boolean.FALSE, values[1][0]);
View Full Code Here
650
651
652
653
654
655
656
657
658
659
660
        if (field_13_name_definition == null) return "#REF!";
        Ptg ptg = (Ptg) field_13_name_definition.peek();
        String result = "";

        if (ptg.getClass() == Area3DPtg.class){
            result = ptg.toFormulaString(refs);

        } else if (ptg.getClass() == Ref3DPtg.class){
            result = ptg.toFormulaString(refs);
        }
View Full Code Here
653
654
655
656
657
658
659
660
661
662
663
        if (ptg.getClass() == Area3DPtg.class){
            result = ptg.toFormulaString(refs);

        } else if (ptg.getClass() == Ref3DPtg.class){
            result = ptg.toFormulaString(refs);
        }

        return result;
    }
View Full Code Here
881
882
883
884
885
886
887
888
889
890
891
    Ptg[] ptgs;
    ptgs = parseFormula("mode({1,2,2,#REF!;FALSE,3,3,2})");
    assertEquals(2, ptgs.length);
    Ptg ptg0 = ptgs[0];
    assertEquals(ArrayPtg.class, ptg0.getClass());
    assertEquals("{1.0,2.0,2.0,#REF!;FALSE,3.0,3.0,2.0}", ptg0.toFormulaString());

    ArrayPtg aptg = (ArrayPtg) ptg0;
    Object[][] values = aptg.getTokenArrayValues();
    assertEquals(ErrorConstant.valueOf(HSSFErrorConstants.ERROR_REF), values[0][3]);
    assertEquals(Boolean.FALSE, values[1][0]);
View Full Code Here
667
668
669
670
671
672
673
674
675
676
677
        if (field_13_name_definition == null) return "#REF!";
        Ptg ptg = (Ptg) field_13_name_definition.peek();
        String result = "";

        if (ptg.getClass() == Area3DPtg.class){
            result = ptg.toFormulaString(book);

        } else if (ptg.getClass() == Ref3DPtg.class){
            result = ptg.toFormulaString(book);
        }
View Full Code Here
670
671
672
673
674
675
676
677
678
679
680
        if (ptg.getClass() == Area3DPtg.class){
            result = ptg.toFormulaString(book);

        } else if (ptg.getClass() == Ref3DPtg.class){
            result = ptg.toFormulaString(book);
        }

        return result;
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.