import com.jxcell.CellException; import com.jxcell.View; public class Group { public static void main(String args[]) { View m_view1 = new View(); View m_view2 = new View(); try { m_view2.setNumber(0,0,458); m_view1.setWorkbookName("wb1"); m_view2.setWorkbookName("wb2"); m_view1.setGroup("group"); m_view2.setGroup("group"); m_view1.setFormula(0, 1, 1, "SUM('[wb2]Sheet1'!$A$1:$D$4)"); double result = m_view1.getNumber(1, 1); System.out.println("Result:" + result); com.jxcell.designer.Designer.newDesigner(m_view1); } catch (CellException e) { e.printStackTrace(); } } }