Editable Dataframe - feature requests and bugs

karangattu commented 7 months ago

Find below all the feature requests for future releases of editable dataframes

[x] Allow users to use Shift Key + multiple rows to highlight multiple rows when row_selection is configured to be multiple
[ ] During edit mode, py-shiny should perform validation when user attempts to enter data that conflicts with the data type of the column in question.
[ ] Allow users to move columns around for ease of use or better readability when working with dataframes
[ ] Option for users to use pagination i.e. show 10, 25 or 50 entries in the table instead of infinite scroll if the data is being populated by calling an API.
[ ] Allow users to undo or redo the changes made to a cell.
[ ] Color in darkly mode is subtle and user might not recognize the highlighted cells.
[ ] Have a way where users can move between different cells without editing each cell. In short when user clicks on a cell, do not turn on editing, only when user presses return/Enter key or double click on the cell.
[ ] Hitting tab currently allows to shift focus to the next cell on the right in the same row. When it reaches end of line for that row, hitting Tab should allow to switch to the first cell in the next row.
[ ] Allow copying across multiple cells by either dragging the selected cell or pasting when a selected row is in focus.

Find below all the issues found during the initial exploratory testing of editable dataframes

[x] When the user makes changes to a dataframe with mode=edit, scroll down the table till it is out of focus, then scroll back up. You will see all the edited cells highlighted with the green border animation.
- Removed border animation in #1283; This removes the animation problem
[x] When a dataframe is sorted, hitting return/enter key will not move to the next row, but instead the unsorted order. (#1291)
[x] Editing a cell in Firefox causes the border to bleed beyond the column area. (#1292)
- top: 0;left: 0;width: 100%;height: 100%; fixes the issue in Firefox

schloerke commented 7 months ago

mdaeron commented 6 months ago

May I suggest the following features?

[ ] ability to paste multi-row, tab-delimited data (basically, enable straightforward copy-and-paste from Office-like spreadsheet software)
[ ] automatically add rows when pasting such data

These two things would go a long way towards building apps that everyone can use, even without any coding background.

nh-cadmus commented 5 months ago

I would like to suggest the following additional functionality:

[ ] Ability to define which columns should be editable (or which columns should be read-only)
[ ] Different input controls for different data types, e.g. a boolean field should contain checkboxes, a timestamp field should contain a date picker, etc.
[ ] Ability to define a custom dropdown list of available values for a column
[x] Data validation options - perhaps the ability to define a custom validation function for a column and/or a row, which gets called when data is added/updated and if it returns false shows an error message. Would allow for simple validation like a numeric range for number columns, and more complex custom validation for fields that might have special requirements.

schloerke commented 5 months ago

davidchall commented 3 months ago

Feature requests to help end users create their own table, rather than editing an existing table:

posit-dev / py-shiny