public void Reference1()
{
XlCell cell = xs.AddCell(1, 1, 1, XlContentType.Integer);
cell.Reference = "A1";
Assert.AreEqual("A1", cell.Reference);
Assert.AreEqual(1, cell.Row);
Assert.AreEqual(1, cell.Col);
cell.Reference = "B2";
Assert.AreEqual("B2", cell.Reference);
Assert.AreEqual(2, cell.Row);
Assert.AreEqual(2, cell.Col);
cell.Reference = "BB48";
Assert.AreEqual("BB48", cell.Reference);
Assert.AreEqual(48, cell.Row);
Assert.AreEqual(54, cell.Col);
cell.Reference = "AR1";
Assert.AreEqual("AR1", cell.Reference);
Assert.AreEqual(1, cell.Row);
Assert.AreEqual(44, cell.Col);
cell.Reference = "XFD010";
Assert.AreEqual("XFD10", cell.Reference);
Assert.AreEqual(10, cell.Row);
Assert.AreEqual(16384, cell.Col);
}
public DummySchemaRowData(XlSchema schema, int rowIndex)
{
int columnIndex = 1;
foreach (XlColumn column in schema.Columns)
{
XlCell cell = new XlCell(0U, column.Type, GetValue(column.Type, rowIndex, columnIndex++));
_list.Add(cell);
}
}
public void Reference()
{
XlCell cell = xs.AddCell(DateTime.Now, 1, 1, XlContentType.Date);
Assert.AreEqual("A1", cell.Reference);
cell.Col = 15;
cell.Row = 2;
Assert.AreEqual("O2", cell.Reference);
cell.Col = 78;
cell.Row = 3;
Assert.AreEqual("BZ3", cell.Reference);
}
public SchemaRowData(XlSchema schema, List <string> items)
{
int columnIndex = 0;
foreach (XlColumn column in schema.Columns)
{
string item;
if (items[columnIndex] != null)
{
item = items[columnIndex];
}
else
{
item = "";
}
XlCell cell = new XlCell(0U, column.Type, item);
_list.Add(cell);
columnIndex++;
}
}
public void Reference0()
{
XlCell cell = xs.AddCell(DateTime.Now, 1, 1, XlContentType.Date);
cell.Reference = "asdasd a";
}
public void Constructor1()
{
XlCell cell = xs.AddCell(DateTime.Now, 0, 0, XlContentType.Date);
}
public void Constructor0()
{
XlCell cell = xs.AddCell(1, 1, 1, XlContentType.Integer);
Assert.IsNotNull(cell);
}
