Layout options for Spreadsheet control

Question

Hi,I'm looking into using thespreadsheet control in my WPF MVVM project. How do I turn off the Row & Column headers, and hide the worksheet tabs? I only need 1 worksheet and I don't need the headers.After that, are there any tutorials on cut & paste in this control?Rob

Kanimozhi Bharathi · Answer

Hi,I'm looking into using thespreadsheet control in my WPF MVVM project. How do I turn off the Row & Column headers, and hide the worksheet tabs? I only need 1 worksheet and I don't need the headers.After that, are there any tutorials on cut & paste in this control?Rob

Hi Robert,

Thank you for
using Syncfusion Products. 

We have analysed
your query and you can hide the row/column headers and Tabs by setting the
IsRowColumnHeadersVisible and DisplayWorkbookTabs to false and you can load a
single worksheet by passing parameter as 1 in New method like the below code
snippet:

Code Snippet:


 
  
  this.spreadSheetControl.New(1);
  this.spreadSheetControl.ExcelProperties.WorkBook.DisplayWorkbookTabs
  = false;
  this.spreadSheetControl.GridProperties.IsRowColumnHeadersVisible
  = false;
  
 


We have prepared
a sample based on this and you can download the sample from the below location.

Please
let us know if you have any queries.

Thanks,

Kanimozhi
B

Attachment: WpfApplication22_b049245e.zip

Kanimozhi Bharathi · Answer

Hi Robert,

Thank you for using Syncfusion Products.

For Cut & Paste in Spreadsheet Control, Please refer the below documentation link

Documentation Link: https://help.syncfusion.com/ug/wpf/default.htm#!documents/clipboardsupport2.htm

Please let us know if you have any queries.

Thanks,

Kanimozhi B