GrapeCity Developer Tools

jump to: - select feature - Welcome to the Spread for... Annotation Mode Auto Complete Borders Cell Notes Cell Types Charting Conditional Formatting Control Layer DataBinding Drag Drop Drag Fill Excel Compatibility Filtering Fonts/Colors Formulas Formula Textbox Freezing Rows/Columns Grouping Outline Grouping (Excel-l... Hierarchy Import Export Merging Move Rows/Columns Multiple Headers Operation Modes Printing Printing to PDF Reporting Search Shapes Sheets Sorting Spans Designers and Wizards SubEditors Unbound Undo/Redo Viewports Zoom Rate this tour

Hierarchy

Sheets can display relational data, such as from a relational database, in hierarchical views.



The user can expand or collapse the levels of the hierarchy by clicking on the expand and collapse hierarchy icons (plus and minus signs).

To set up hierarchical data display, you first create a data set to hold the relational data, then define the relations between the data, and finally, set the FarPoint Spread component to display the data as you want. You can customize the cell type, the colors, the headers, and other aspects of the appearance of the view. You can also bind to a hierarchical collection.