Integrated spreadsheet expanding table with collapsable columns

摘要

GUI selected rows of a displayed spreadsheet are collapsed based on column values such that all of the rows having the same value in the selected column are represented by a single collapsed row with an indicator indicating the row is collapsed. All column values of all the rows of the spreadsheet can be collapsed or individual column values can be collapsed. Collapsed rows are expanded for all rows or for a selected row. The expanded rows may be sorted, retain the original sequence but be grouped by column value or may be displayed in the original sequence with rows having different values.