public void TestCloneSheet()
{
Workbook workbook = GetTestDataProvider().CreateWorkbook();
CreationHelper factory = workbook.GetCreationHelper();
Sheet sheet = workbook.CreateSheet("Test Clone");
Row row = sheet.CreateRow(0);
Cell cell = row.CreateCell(0);
Cell cell2 = row.CreateCell(1);
cell.SetCellValue(factory.CreateRichTextString("Clone_test"));
cell2.CellFormula = "SIN(1)";
Sheet ClonedSheet = workbook.CloneSheet(0);
Row ClonedRow = ClonedSheet.GetRow(0);
//Check for a good clone
Assert.AreEqual(ClonedRow.GetCell(0).RichStringCellValue.String, "Clone_test");
//Check that the cells are not somehow linked
cell.SetCellValue(factory.CreateRichTextString("Difference Check"));
cell2.CellFormula = "cos(2)";
if ("Difference Check".Equals(ClonedRow.GetCell(0).RichStringCellValue.String))
{
Assert.Fail("string cell not properly Cloned");
}
if ("COS(2)".Equals(ClonedRow.GetCell(1).CellFormula))
{
Assert.Fail("formula cell not properly Cloned");
}
Assert.AreEqual(ClonedRow.GetCell(0).RichStringCellValue.String, "Clone_test");
Assert.AreEqual(ClonedRow.GetCell(1).CellFormula, "SIN(1)");
}
public void TestCloneSheetMultipleTimes()
{
Workbook workbook = GetTestDataProvider().CreateWorkbook();
CreationHelper factory = workbook.GetCreationHelper();
Sheet sheet = workbook.CreateSheet("Test Clone");
Row row = sheet.CreateRow(0);
Cell cell = row.CreateCell(0);
cell.SetCellValue(factory.CreateRichTextString("Clone_test"));
//Clone the sheet multiple times
workbook.CloneSheet(0);
workbook.CloneSheet(0);
Assert.IsNotNull(workbook.GetSheet("Test Clone"));
Assert.IsNotNull(workbook.GetSheet("Test Clone (2)"));
Assert.AreEqual("Test Clone (3)", workbook.GetSheetName(2));
Assert.IsNotNull(workbook.GetSheet("Test Clone (3)"));
workbook.RemoveSheetAt(0);
workbook.RemoveSheetAt(0);
workbook.RemoveSheetAt(0);
workbook.CreateSheet("abc ( 123)");
workbook.CloneSheet(0);
Assert.AreEqual("abc (124)", workbook.GetSheetName(1));
}
void Start()
{
characterController = GetComponent <CharacterController>();
inputHandler = GetComponent <InputHandler>();
myRigidBody = GetComponent <Rigidbody>();
currentGravity = gravity;
if (isLocalPlayer)
{
CreationHelper.SetLayer(transform, LayerMask.NameToLayer("Player"), false);
}
else
{
CreationHelper.SetLayer(transform, LayerMask.NameToLayer("Enemy"), false);
}
}
public void TestShiftMerged()
{
Workbook wb = GetTestDataProvider().CreateWorkbook();
CreationHelper factory = wb.GetCreationHelper();
Sheet sheet = wb.CreateSheet();
Row row = sheet.CreateRow(0);
Cell cell = row.CreateCell(0);
cell.SetCellValue(factory.CreateRichTextString("first row, first cell"));
row = sheet.CreateRow(1);
cell = row.CreateCell(1);
cell.SetCellValue(factory.CreateRichTextString("second row, second cell"));
CellRangeAddress region = new CellRangeAddress(1, 1, 0, 1);
sheet.AddMergedRegion(region);
sheet.ShiftRows(1, 1, 1);
region = sheet.GetMergedRegion(0);
Assert.AreEqual(2, region.FirstRow, "Merged region not moved over to row 2");
}
