Clear Selection of Column

Aspose.Cells Product Family
1

Hi there,

please have a look at the attached file.

The Column "BZ" is selected. I just need to clear this selection an maybe set the focus to Cell "A1".

How can i do this?

Thanks a lot,

Daniel

2

Hi Daniel,

Thanks for providing us the template file.

Yes, we understand your need. Aspose.Cells is capable to do the task. Please check the following doc how to accomplish it: http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/activating-sheets-and-making-an-active-cell-in-the-worksheet.html

Note: this feature is only available for a licensed version for the product.

Thank you.

3

Thanks for your reply,

unhappily it doesn't solve the task. We tried to set the ActiveCell before.

//Set B2 cell as an active cell in the worksheet.

worksheet1.ActiveCell= "B2";

//Set the B column as the first visible column in the worksheet.

worksheet1.FirstVisibleColumn =1;

//Set the 2nd row as the first visible row in the worksheet.

worksheet1.FirstVisibleRow = 1;

The selected column is still present. Is there an other solution?

Thank you,


Daniel

4

Sorry i didn't check it correctly,

your post solved this task,

Thanks a lot,

Daniel