fpSpread1.Sheets[0].RowCount = 10;
fpSpread1.Sheets[0].ColumnCount = 15;
// Show the footer.
fpSpread1.Sheets[0].ColumnFooter.Visible = true;
fpSpread1.Sheets[0].ColumnFooter.RowCount = 2;
FarPoint.Win.Spread.NamedStyle nstyleheaders = new FarPoint.Win.Spread.NamedStyle("test");
nstyleheaders.BackColor = Color.Red;
fpSpread1.NamedStyles.Add(nstyleheaders);
fpSpread1.Sheets[0].ColumnFooter.DefaultStyle = nstyleheaders;
fpSpread1.Sheets[0].ColumnFooter.DefaultStyleName = "test";