Enter Data into hidden columns

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

    Posted 17 Jan Link to this post

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

  2. Dinko
    Admin
    Dinko avatar
    416 posts

    Posted 20 Jan 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];
    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.
Back to Top