static Demonstration()
{
fpSpread = new FpSpread();
sheetView = new SheetView();
fpSpread.Sheets.Add(sheetView);
cellType = new FarPoint.Win.Spread.CellType.GeneralCellType();
sheetView.Cells[0, 0].CellType = cellType;
}
public static ICellType CreateInstance(FormatInfo Format)
{
ICellType r = null;
if (Format.Style == FormatStyle.Currency ||
Format.Style == FormatStyle.General ||
Format.Style == FormatStyle.Number ||
Format.Style == FormatStyle.Percent ||
Format.Style == FormatStyle.ScientificCount)
{
FarPoint.Win.Spread.CellType.GeneralCellType rs = new FarPoint.Win.Spread.CellType.GeneralCellType();
rs.FormatString = Format.Format;
rs.WordWrap = true;
r = rs;
return(r);
}
else if (Format.Style == FormatStyle.Date ||
Format.Style == FormatStyle.Time)
{
DateTimeCellType ds = new DateTimeCellType();
ds.UserDefinedFormat = Format.Format;
r = ds;
return(r);
}
else if (Format.Style == FormatStyle.Text)
{
FarPoint.Win.Spread.CellType.TextCellType rs = new FarPoint.Win.Spread.CellType.TextCellType();
rs.Multiline = true;
rs.WordWrap = true;
r = rs;
return(r);
}
else
{
FarPoint.Win.Spread.CellType.GeneralCellType gs = new FarPoint.Win.Spread.CellType.GeneralCellType();
gs.FormatString = Format.Format;
r = gs;
return(r);
}
}