Merging Cells and Freezing a row problem

Aspose.Cells Product Family
1

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");

sheet.Merge(range);

cell = sheet.Cells["A1"];

cell.Value = "Test Merge - Row 1, Columns A & B";

sheet.FrozenRows = 1;

2

Hi,

Yes, I noticed, there seams to have some sort of clash when merging rows and freezng panes at the same time.

We will sort it out soon.

Thank you.

3

I appreciate the fast response.

Do you have any sort of timeframe for when this might be enhanced?

Are we talking weeks, months?

4

Hi,

We will get back to you soon.

Thanks for being patient!

5

Hi again, any word on when the update might be happening?

We're moving in to the next stage of development and need to know if this can meet our needs or if we need to find something else.

Thanks.

6

Hi,

Thanks for considering Aspose.

Sorry for a bit delay as we are extremely busy in some of our tasks on hand. We will update you soon.

Thanks for being patient!

7

We will fix this problem within this week.

8

Hi sswift is not online. Last active: 09-21-2007, 1:56 PM sswift

Sorry about the delay .

Please try the attached fix .

9

Thanks! Works great.