h-spreadsheet: additional features

[ninetteadhikari]

Additional features:

• Allow users to view a summary of columns to hide/display when they click on the Hide fields checkbox on the toolbar #386

• Allow column reordering and save position by dragging and dropping into position #387

• Delete a single row: Click on a single cell and right click

• Delete a single row: Hover on the row index number and click on the checkbox and right click

• Delete multiple selected rows: Hover on multiple row index numbers and click on the checkboxes, then right click on one of the selected rows. For all record deletion, display confirmation dialog (as shown when two records are selected)

![Uploading image.png…]()

• Allow sortable columns when you click on the column header icon or OR when they right click on the column #388
• Allow a user to hide a column when they click on the column header icon OR when they right click on the column #397

• allow users to move a row and save the position #389

For future enhancements:

• Add view/edit event/hook (not sure if its done yet) - tap into the logic to double-click functionality
• improvement on setting data type by column
• allow user to control the width of the column
• allow devs to merge cells (header cells): example from ElementUI: https://element.eleme.io/#/en-US/component/table#grouping-table-head
• allow users to freeze/fix certain columns
• allows user to use tab key to switch cells
• make the '+' add button to be sticky at the bottom when the table is long
• Select a row height. Provide a set of predefined row heights a user can select:
• Short (1 line)
• Medium (2 lines)
• Tall (4 lines)
• Extra Tall (6 lines)

• Summary of sort columns:
  

• Highlight entire row when right clicking the row

#286

Originally posted by @andrewtpham in #355 (comment)

[andrewtpham]

@michaelbukachi tested in develop, looks really good. Here's a few more things we can continue working on:

• When a single checkbox is selected and a user right clicks, the single record menu should display:

Currently the delete all selected records menu displays. This should only display when 2 or more rows are selected.

• We can add the summary of hide/display columns when a user clicks the + icon on the far right column of the spreadsheet
• We can add the right click when a user clicks the column icon or right clicks on the column header to display the column menu:

• We can add the ability to move columns by dragging and dropping
• We can add the ability to move rows by dragging and dropping

[amosnjoroge]

Additional issues:

• When deleting multiple records reset the checked state of the checkboxes.
• Highlight a row by both left and right click. When right clicking highlight the row before the right click pop up is displayed.
• Tab key navigation to the next cell during edit (nice to have, lower priority)

[andrewtpham]

@michaelbukachi for the hide column icon, you can use the eye icon el-icon-view and we can figure out how to put a slash through it