I want to create a page in WPF such that it contains multiple XamDataGrids and each grid contains a XamSpreadsheet and within each spredsheet the starting rownumber should be such that RowNumber of spredsheet will get change with grid changes , please refer below example for more details
Grid 1- Spreedsheet1 - Row Number 1 Row Number 2 Row Number 3
Grid 2- Spreedsheet2 - Row Number 4 Row Number 5 Row Number 6
Grid 3- Spreedsheet3 - Row Number 7 Row Number 8 Row Number 9
Secondly, one more functionalty required- The Grids can be drag and drop such that Grid 2 can be dragged and dropped over Grid 1 then the XamSpreadsheet RowNumber should get changed, as per below example:
Grid 2- Spreedsheet2 - Row Number 1 Row Number 2 Row Number 3
Grid 1- Spreedsheet1 - Row Number 4 Row Number 5 Row Number 6
Note : It would nice to have if there is only 1 XamDataGrid which has multipleRows and each Row within XamDataGrid contains a XamSpreadsheet and the rest is similar as above.Basically I want to split XamSpreadsheet into different sections and want to display on UI as seperate parts to the user with excelfile look and feel with the rownumbers starting as required by the user instead of 1?
Please let me know how can I achieve this or is there any other control apart from XamSpreadsheet than I can use to achieve this functionality?
Hello Richa,
XamSpreadsheet doesn't support changing the default start row number. However you can try hide the first rows in the xamSpreadsheet like this:
xamSpreadSheet1.ActiveWorksheet.HideRows(0, 3);
Integrating the xamSpreadsheet inside a xamDataGrid has been determined to be a product idea. You can suggest new product ideas for future versions by emailing ideas@infragistics.com.
Submitting your idea will send it directly to our product management team so that it can be imported into our new ideas community once live: http://ideas.infragistics.com.
Remember when submitting your idea to explain the context in which a feature would be used and why it is needed as well as anything that would prevent you from accomplishing this today. You can even add screenshots to build a stronger case. You can also link back to this thread for additional details.
Thank you in advance to submitting your product idea.
Sincerely,Teodor TenevSoftware Developer