Enter Data into hidden columns

2 posts, 0 answers
  1. Manas
    Manas avatar
    2 posts
    Member since:
    Sep 2016

    Posted 17 Jan 2017 Link to this post


    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??

  2. Dinko
    Dinko avatar
    523 posts

    Posted 20 Jan 2017 Link to this post

    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];
    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.

    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.
Back to Top