private void SetFormula(String formula, FormulaType formulaType)
{
XSSFWorkbook wb = (XSSFWorkbook)_row.Sheet.Workbook;
if (formula == null)
{
RemoveFormula();
return;
}
if (wb.CellFormulaValidation)
{
IFormulaParsingWorkbook fpb = XSSFEvaluationWorkbook.Create(wb);
//validate through the FormulaParser
FormulaParser.Parse(formula, fpb, formulaType, wb.GetSheetIndex(this.Sheet), RowIndex);
}
CT_CellFormula f = new CT_CellFormula();
f.Value = formula;
_cell.f = (f);
if (_cell.IsSetV())
{
_cell.unsetV();
}
}
public void SetFirstVisibleTab_57373()
{
XSSFWorkbook wb = new XSSFWorkbook();
try
{
/*Sheet sheet1 =*/
wb.CreateSheet();
ISheet sheet2 = wb.CreateSheet();
int idx2 = wb.GetSheetIndex(sheet2);
ISheet sheet3 = wb.CreateSheet();
int idx3 = wb.GetSheetIndex(sheet3);
// add many sheets so "first visible" is relevant
for (int i = 0; i < 30; i++)
{
wb.CreateSheet();
}
wb.FirstVisibleTab = (/*setter*/ idx2);
wb.SetActiveSheet(idx3);
//wb.Write(new FileOutputStream(new File("C:\\temp\\test.xlsx")));
Assert.AreEqual(idx2, wb.FirstVisibleTab);
Assert.AreEqual(idx3, wb.ActiveSheetIndex);
IWorkbook wbBack = XSSFTestDataSamples.WriteOutAndReadBack(wb);
sheet2 = wbBack.GetSheetAt(idx2);
sheet3 = wbBack.GetSheetAt(idx3);
Assert.AreEqual(idx2, wb.FirstVisibleTab);
Assert.AreEqual(idx3, wb.ActiveSheetIndex);
wbBack.Close();
}
finally
{
wb.Close();
}
}
public int GetExternalSheetIndex(String sheetName)
{
int sheetIndex = _uBook.GetSheetIndex(sheetName);
return(ConvertToExternalSheetIndex(sheetIndex));
}
public void SetFirstVisibleTab_57373()
{
XSSFWorkbook wb = new XSSFWorkbook();
try
{
/*Sheet sheet1 =*/
wb.CreateSheet();
ISheet sheet2 = wb.CreateSheet();
int idx2 = wb.GetSheetIndex(sheet2);
ISheet sheet3 = wb.CreateSheet();
int idx3 = wb.GetSheetIndex(sheet3);
// add many sheets so "first visible" is relevant
for (int i = 0; i < 30; i++)
{
wb.CreateSheet();
}
wb.FirstVisibleTab = (/*setter*/idx2);
wb.SetActiveSheet(idx3);
//wb.Write(new FileOutputStream(new File("C:\\temp\\test.xlsx")));
Assert.AreEqual(idx2, wb.FirstVisibleTab);
Assert.AreEqual(idx3, wb.ActiveSheetIndex);
IWorkbook wbBack = XSSFTestDataSamples.WriteOutAndReadBack(wb);
sheet2 = wbBack.GetSheetAt(idx2);
sheet3 = wbBack.GetSheetAt(idx3);
Assert.AreEqual(idx2, wb.FirstVisibleTab);
Assert.AreEqual(idx3, wb.ActiveSheetIndex);
}
finally
{
wb.Close();
}
}
