private void FormatCells(TimeInterval db)
{
if (m_dataTable.Columns.Count == 0)
{
return;
}
// Default format
worksheet.UsedRange.Font.Color = SpreadsheetGear.Colors.Black;
worksheet.Range["A:A"].Interior.Color = SpreadsheetGear.Colors.LightGray;
worksheet.Range["A:A"].Font.Bold = true;
worksheet.Range["A:A"].Font.Italic = true;
worksheet.Range[0, 0, 0, m_dataTable.Columns.Count - 1].Interior.Color = SpreadsheetGear.Colors.LightGray;
worksheet.Range[0, 0, 0, m_dataTable.Columns.Count - 1].Font.Bold = true;
worksheet.Range[0, 0, 0, m_dataTable.Columns.Count - 1].Font.Italic = true;
if (db == TimeInterval.Irregular)
{
for (int i = 1; i < m_dataTable.Columns.Count; i += 2)
{
string dataColumn = SpreadsheetGearExcel.ReferenceFromIndex(i);
string flagColumn = SpreadsheetGearExcel.ReferenceFromIndex(i + 1);
ConditionalFormatting(dataColumn, flagColumn);
}
}
else if (db == TimeInterval.Monthly)
{
string dateRange = "A:A";// +m_dataTable.Rows.Count.ToString();
worksheet.Range[dateRange].NumberFormat = "mmm yyyy";
}
}
private void FormatCells(TimeInterval db)
{
if (db == TimeInterval.Irregular)
{
for (int i = 1; i < m_dataTable.Columns.Count; i += 2)
{
string dataColumn = SpreadsheetGearExcel.ReferenceFromIndex(i);
string flagColumn = SpreadsheetGearExcel.ReferenceFromIndex(i + 1);
ConditionalFormatting(dataColumn, flagColumn);
}
}
else
if (db == TimeInterval.Monthly)
{
string dateRange = "A:A"; // +m_dataTable.Rows.Count.ToString();
worksheet.Range[dateRange].NumberFormat = "mmm yyyy";
}
}
public void ColumnReferenceNames()
{
int i = SpreadsheetGearSeries.ColumnIndexFromRef("A");
Assert.AreEqual(0, i);
i = SpreadsheetGearSeries.ColumnIndexFromRef("AA");
Assert.AreEqual(26, i);
i = SpreadsheetGearSeries.ColumnIndexFromRef("IV");
Assert.AreEqual(255, i);
string s = SpreadsheetGearExcel.ReferenceFromIndex(0);
Assert.AreEqual("A", s);
s = SpreadsheetGearExcel.ReferenceFromIndex(26);
Assert.AreEqual("AA", s);
s = SpreadsheetGearExcel.ReferenceFromIndex(255);
Assert.AreEqual("IV", s);
}
