I have an object which has the following hierarchy:
LOS >> Sections >> Categories >> Accounts
The accounts object contains a date property
I want to create and excel style grid. I am converting a previous web grid. I have attached for reference. I really don't see any events that will allow me create this look. Is it possible to take my object and flatten it out to an excel style user interface?
Hi wpearson4,
Changing the appearance of the XamGrid can be done through the use of styles. The XamGrid has numerous styling points that you can use to change the way it looks.https://help.infragistics.com/Help/Doc/Silverlight/2011.2/CLR4.0/html/SL_DesignersGuide_Styling_Points_for_xamGrid.html
Flattening the data into a flat list is an option since you use the same columns for each data type. You can have a flat collection of a seperate data type that you fill in the with the data from the hierarchy and this list is what you would bind to the grid. You can then use conditional formatting on the cells to change the background and foreground color depending on what kind of data they are representing in their rows.
You might also be able to use the hierarchy directly by removing expansion indicators and changing the indentations on the child rows so they appear to be a flat list.
I looked at the link you sent. Is it possible to style individual rows or even cells?
Yes you can style Cells and Rows individually. The Row object has a CellStyle property that it uses to apply styles to all the cells in a row. The Cell object has a Style property that is used to apply styles on that particular cell.
Cell style property:https://help.infragistics.com/Doc/Silverlight/2011.2/CLR4.0/?page=InfragisticsSL4.Controls.Grids.XamGrid.v11.2~Infragistics.Controls.Grids.CellBase~Style.html
Row style property:https://help.infragistics.com/Doc/Silverlight/2011.2/CLR4.0/?page=InfragisticsSL4.Controls.Grids.XamGrid.v11.2~Infragistics.Controls.Grids.Row~CellStyle.html