public void RecalcId() { XSSFWorkbook wb = new XSSFWorkbook(); Assert.IsFalse(wb.GetForceFormulaRecalculation()); CT_Workbook ctWorkbook = wb.GetCTWorkbook(); Assert.IsFalse(ctWorkbook.IsSetCalcPr()); wb.SetForceFormulaRecalculation(true); // resets the EngineId flag to zero CT_CalcPr calcPr = ctWorkbook.calcPr; Assert.IsNotNull(calcPr); Assert.AreEqual(0, (int)calcPr.calcId); calcPr.calcId = 100; Assert.IsTrue(wb.GetForceFormulaRecalculation()); wb.SetForceFormulaRecalculation(true); // resets the EngineId flag to zero Assert.AreEqual(0, (int)calcPr.calcId); Assert.IsFalse(wb.GetForceFormulaRecalculation()); // calcMode="manual" is unset when forceFormulaRecalculation=true calcPr.calcMode = (ST_CalcMode.manual); wb.SetForceFormulaRecalculation(true); Assert.AreEqual(ST_CalcMode.auto, calcPr.calcMode); }
public bool GetForceFormulaRecalculation() { CT_CalcPr calcPr = this.GetCTWorkbook().calcPr; if (calcPr != null) { return(calcPr.calcId != 0U); } return(false); }
public void SetForceFormulaRecalculation(bool value) { CT_Workbook ctWorkbook = this.GetCTWorkbook(); CT_CalcPr ctCalcPr = ctWorkbook.IsSetCalcPr() ? ctWorkbook.calcPr : ctWorkbook.AddNewCalcPr(); ctCalcPr.calcId = 0U; if (!value || ctCalcPr.calcMode != ST_CalcMode.manual) { return; } ctCalcPr.calcMode = ST_CalcMode.auto; }
public void TestRecalcId() { XSSFWorkbook wb = new XSSFWorkbook(); Assert.IsFalse(wb.GetForceFormulaRecalculation()); CT_Workbook ctWorkbook = wb.GetCTWorkbook(); Assert.IsFalse(ctWorkbook.IsSetCalcPr()); wb.SetForceFormulaRecalculation(true); // resets the EngineId flag to zero CT_CalcPr calcPr = ctWorkbook.calcPr; Assert.IsNotNull(calcPr); Assert.AreEqual(0, (int)calcPr.calcId); calcPr.calcId = 100; Assert.IsTrue(wb.GetForceFormulaRecalculation()); wb.SetForceFormulaRecalculation(true); // resets the EngineId flag to zero Assert.AreEqual(0, (int)calcPr.calcId); Assert.IsFalse(wb.GetForceFormulaRecalculation()); }