I can't seem to get the following code to work. The only way to get the text to display is to comment out "sheet.Merge(range);".
I want the text to appear in the 1st row, 1st 2 columns and be frozen.
Aspose.Grid.Desktop.Worksheet sheet = DataCollectionGrid.Worksheets[DataCollectionGrid.ActiveSheetIndex];
Aspose.Grid.Desktop.CellRange range = null;
Aspose.Grid.Desktop.GridCell cell = null;
range = new Aspose.Grid.Desktop.CellRange("A1", "B1");
cell = sheet.Cells["A1"];
cell.Value = "Test Merge - Row 1, Columns A & B";
sheet.FrozenRows = 1;