I am using Aspose.Grid in my web application. The following code was working fine until now:
private void ColorCells(DataSet _ds)
WebWorksheet sheet = dg.WebWorksheets[dg.ActiveSheetIndex];
int rows = _ds.Tables.Rows.Count;
for (int i = 0; i < rows; i++)
if (_ds.Tables.Rows[i]["Adjustment"].ToString().ToLower() == "yes")
sheet.Cells[i, 8].Style.BackColor = Color.FromName("Red");
sheet.Cells[i, 8].Style.ForeColor = Color.FromName("White");
Now, the entire column (every row) takes on the color assignment that I set for the last row of the grid. I no longer can set cell coloring row by row.
What am I doing wrong? What can I do to change this behavior? I have installed the 10/11/2007 hotfix, no change.
Thank you for your time and attention,