Forums Ultimate UI for WPF
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Richa
345
How to update Xamspreedsheet staring Row Number with required number
posted

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

Grid 3- Spreedsheet3 -
Row Number 7
Row Number 8
Row Number 9

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?

  • 1530
    posted

    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 Tenev
    Software Developer