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());
}
