Forums Retired Products and Controls
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
William
345
Create a grid with an Excel Style look and feel
posted

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?

Parents
No Data
Reply
  • 34510
    Verified Answer
    Offline posted

    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.

Children