PROGRESS.md

Jupyter Tabular Data Editor Extension Progress

An account of tasks and features that are completed or planned

Try out our current extension via Binder

Read about the new model

Features To Be Added (listed in order of highest priority)

• Edit cells (text editing only)
• Save
• Add rows/columns
• Delete rows/columns
• Move rows/columns
• Undo/redo capabilities
• Copy, paste, cut
• Command Toolbar
• Search and Replace
• Clear contents
• CSV launcher
• Multi row/column insert/remove
• Ghost row/column
• Data type detection (format data mode)

---

Potential Future Features

• Fill handle
• Freeze rows/columns
• Moving cells
• Multi row/column move
• Filter
• Sort
• Referencing other cells in formulas (relative positioning)
• Kernel-backed cell outputs

Current Progress

08/24/20 - 08/28/20

Final Presentation

• Bug fixes and cleanup - Kalen/Logan
• Project Documentation - Ryan

08/17/20 - 08/21/20

• Format data mode - Kalen
• Data type icons - Logan
• README updates - Ryan

08/10/20 - 08/14/20

• CSV launcher - Kalen
• Unsaved changes dialog - Kalen
• Scroll and select while searching - Kalen
• Multi insert/remove for rows/columns - Kalen
• Ghost column and ghost row - Logan
• Usability testing - Ryan
• Dark theme search color change - Ryan

Completed Prototypes - Ryan

• Data detection

08/03/20 - 08/07/20

Demo 2

• Litestore refactor - Kalen
• Selection UI/UX fixes - Kalen
• Moving shadow/line UI/UX fixes - Kalen
• New data model - Logan

Completed Prototypes - Ryan

• Ghost add
• Freeze function

07/27/20 - 07/31/20

Extension available to try out in a binder demo

• Command Toolbar - Kalen
• Clear contents (rows, columns, selections) - Kalen
• Multiple context menus depending on region - Logan
• Improvement in time complexity of column ops - Logan
• EditorModel ~50% complete. - Logan
• CSS styling changes to data grid - Ryan

Completed Prototypes - Ryan

• Ghost columns/ rows
• Copying and pasting
• Context menus

07/20/20 - 07/24/20

• Search and replace functionality - Kalen
• Theme manager (light/dark) - Kalen
• CSS Styling changes to dark theme - Ryan
• CSS Styling changes to moving row/column shadow - Ryan
• Move columns and rows - Logan

Design Exploration - Ryan

• Ghost columns/ rows
• No formula bar
• Insert drop down menu toolbar
• Simplified context menus

07/13/20 - 07/17/20

• Set up Jest framework for testing - Kalen, Logan
• Implemented Litestore (simplified version of Lumino Datastore) to manage model data - Kalen
• Able to undo and redo basic cell functions (cell editing, additions/removals of rows/columns) - Kalen
• Able to copy/cut and paste - Logan
• Created a new npm package for our slightly modified version of lumino - Logan
• Started designing the UX/UI for writing code (i.e. code editor) for a cell in a table (Phase 2 Exploration) - Ryan
• Added a toolbar with clickable buttons (functionality still needs to be implementted) - Ryan

07/06/20 - 07/10/20

Demo - Initial Progress

• Set up pre-commit hook (Husky/Lint-Staged) for linting and formatting code - Kalen
• Able to add rows and columns - Logan
• Able to delete rows and columns - Kalen, Logan
• Able to save file after editing in our extension - Kalen, Logan
• Alphabetic column header - Kalen
• Added UI/UX for user story issues - Ryan

Completed Prototypes - Ryan

• Sorting Data
• Search and Replace

06/29/20 - 07/02/20

• Created a fork of JupyterLab CSVViewer package (renaming of some attributes/methods to protected/public) - Logan
• Cells are now editable (text editing only) - Kalen, Logan

Completed Prototypes - Ryan

• Editing datagrid
• Saving datagrid
• Moving cells, rows, and columns
• Inserting rows and columns
• Filtering data

06/22/20 - 06/26/20

• Initial repo setup - Kalen, Logan, Ryan
• Linked extension to JupyterLab - Kalen, Logan
• Completed heuristic evaluation - Ryan
• Finished personas, user journeys, and user stories - Ryan