Examples of FormulaDocument

  }


  public void testParameterReplacementLast()
  {
    final ParameterUpdateEvent event = new ParameterUpdateEvent(this, 2, "SUM(1; (1 + 1))", false);
    final FormulaDocument doc = new FormulaDocument();
    doc.setText("=IF(;;)");
    final FunctionInformation fn = doc.getFunctionForPosition(1);


    final FunctionParameterEditHelper.EditResult editResult =
        FunctionParameterEditHelper.buildFormulaText(event, fn, doc.getText());


    assertEquals("=IF(;;SUM(1; (1 + 1)))", editResult.text);
    assertEquals(21, editResult.caretPositionAfterEdit);
  }

Examples of org.pentaho.openformula.ui.model2.FormulaDocument

  }


  public void testNestedParameterReplacement()
  {
    final ParameterUpdateEvent event = new ParameterUpdateEvent(this, 1, "AND(1; (1 + 1))", true);
    final FormulaDocument doc = new FormulaDocument();
    doc.setText("=IF(;SUM();)");
    final FunctionInformation fn = doc.getFunctionForPosition(9);
    assertEquals("SUM", fn.getCanonicalName());


    final FunctionParameterEditHelper.EditResult editResult =
        FunctionParameterEditHelper.buildFormulaText(event, fn, doc.getText());


    assertEquals("=IF(;SUM(;AND(1; (1 + 1)));)", editResult.text);
    assertEquals(25, editResult.caretPositionAfterEdit);
  }

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.