This is a migrated thread and some comments may be shown as answers.

Enter Data into hidden columns

1 Answer 56 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Manas
Top achievements
Rank 1
Manas asked on 18 Jan 2017, 04:47 AM

Hi,

I am currently hiding few columns in the activeWorkSheet ,my question was is there a way to enter data to hidden columns still keeping the column hidden state true??

1 Answer, 1 is accepted

Sort by
0
Dinko | Tech Support Engineer
Telerik team
answered on 20 Jan 2017, 01:37 PM
Hi Manas,

Even if a column is hidden you can still get its cells and edit their value. For example, if you have hidden the second column "B" you can get the cells in that column and set a different value using the SetValue() method of the CellSelection object.
var workSheet =  this.radSpreadsheet.Workbook.Worksheets[0];
ColumnSelection column = workSheet.Columns[1,1];
column.SetHidden(true);
CellSelection selection = workSheet.Cells[1, 1];
selection.SetValue("Your custom Text");
More information about setting different properties of the cells is available in the Get, Set and Clear Cell Properties help article.

Regards,
Dinko
Telerik by Progress
Want to extend the target reach of your WPF applications, leveraging iOS, Android, and UWP? Try UI for Xamarin, a suite of polished and feature-rich components for the Xamarin framework, which allows you to write beautiful native mobile apps using a single shared C# codebase.
Tags
Spreadsheet
Asked by
Manas
Top achievements
Rank 1
Answers by
Dinko | Tech Support Engineer
Telerik team
Share this question
or