DataEditR 1.0.0

Major New Features

• Add change tracking with the new track parameter in data_edit() and dataEditServer(). Set track = TRUE to highlight edited and added cells with a blue border, or pass a CSS color string (e.g. track = "red") for a custom highlight colour. Uses Handsontable’s afterRenderer hook and name-based cell matching so that inserted rows or columns no longer cause all subsequent cells to appear changed.
• Add tidyverse-style code generation via the new data_code() function and updated code argument in data_edit(). Instead of dput() output, the editor now generates human-readable dplyr pipe code using rename(), select(), mutate(), slice(), and tibble::add_row() to replicate column renames, additions/removals, cell value changes, and row additions/removals. Row names (e.g. those in mtcars) are preserved via tibble::rownames_to_column() / tibble::column_to_rownames().

Automatic Data Synchronisation

• Remove the sync button in favour of automatic data synchronisation. Changes made to filtered or selected data subsets are now automatically merged back into the master copy of the data as they are made.
• Fix bug where column indices were not passed to the sync logic (values$cols instead of values$columns).
• Add auto parameter to dataSyncServer() to allow automatic synchronisation when used as a standalone module.
• Improve performance by preventing unnecessary table re-renders after data synchronisation. Filter and select modules no longer reset on every sync.

Bug Fixes

• Fix factor column crash: passing a data frame with factor columns no longer causes an error in hot_context_menu. Factor columns are now converted to character before rendering and converted back on output via col_factor.
• Fix dataFilter “not between” and “not contain” filter logic which incorrectly used ncol() instead of nrow(), causing wrong row indices to be returned.
• Fix dataFilter multi-filter intersection which used duplicated() and missed rows matching all filters when no duplicates existed. Now uses table() to correctly compute the intersection.
• Fix stale input$x race condition in dataEditServer() when switching reactive data. A data_loading flag now prevents the old table’s input$x from overwriting values$x before the new data has rendered.

DataEditR 0.1.7

• Remove the sync button in favour of automatic data synchronisation. Changes made to filtered or selected data subsets are now automatically merged back into the master copy of the data as they are made.
• Fix bug where column indices were not passed to the sync logic (values$cols instead of values$columns).
• Add auto parameter to dataSyncServer() to allow automatic synchronisation when used as a standalone module.
• Improve performance by preventing unnecessary table re-renders after data synchronisation. Filter and select modules no longer reset on every sync.

DataEditR 0.1.6

• Update FontAwesome icon names.

DataEditR 0.1.5

• Add cancel argument to data_edit() to allow control over return value when the data editor is deliberately closed by the user, set to the original input dat by default.
• Make the switch to bslib for more flexibility in setting custom themes data_edit(). Users can now supply a bs_theme object to the theme argument to fully customise the appearance of the data_edit() UI.
• Fix handling of numeric row names to ensure maintenance of row indices relative to the master copy.
• Improved handling of highlighted data_edit() calls within RStudio.

DataEditR 0.1.4

• Fix header location on scroll.
• Make sure column names are retained when loading empty datasets within dataInput.
• Add checks for empty data within dataInput and dataEdit to ensure that the supplied data always contains as least a single row and column.
• Add support for writing data to googlesheets by calling write_fun as the application closes.
• Fix data_edit() to ensure that we don’t search for data through RStudio addin if RStudio is not in use.

DataEditR 0.1.3

• Display hints when user hovers cursor over buttons.
• Make sure R objects containing . can be loaded into the data editor.
• Turn on highlighting for columns and rows.
• Add dataSync module to handle synchronisation of an edited data subset with the complete dataset.
• Improved support for tibbles.
• Fix dataFilter to ensure the logic and levels are always updated when the column selection changes.

DataEditR 0.1.2

• data_edit() can now export the code required to generate the final edited version of the data to an R script.
• Update vignette and website to demonstrate usage of code argument.
• Make sure to search the correct environment when creating templates or reading files.

DataEditR 0.1.1

• Ensure dataInput searches for data outside data_edit().
• Prevent loading of highlighted data object in RStudio when data has been supplied to data_edit() directly.
• Allow saving by write_fun whenever save_as is supplied.

DataEditR 0.1.0

• Make the switch to GitHub Actions for continuous integration.
• Update dataSelect and dataFilter examples now that the return values are lists instead of reactive expressions.

DataEditR 0.0.9

• Minor improvements to ensure that the original data is retained when new columns are added or renamed. Requires installation of rhandsontable from install_github("DillonHammill/rhandsontable").

DataEditR 0.0.8

• Add dataSelect and dataFilter modules to filter data,
• Add a Sync button to update the entire dataset with changes made to a subset. Data is still exported as a whole but a new button could be added in the future to export the subsetted data.
• Add cut button to allow return of subsetted data upon closing the application with the Done button.

DataEditR 0.0.7

• Create dataInput, dataEdit and dataOutput modules.
• Create RStudio addin to interactively edit data.
• Update user interface to allow interactive file selection or input of R data objects.
• Add new viewer options to open the data editor in a dialog box, browser or RStudio viewer pane. This can be controlled through the viewer argument and has been set to use a dialog box by default. Additional arguments viewer_height and viewer_width have been added to allow control over the dimensions of dialog boxes.
• Add a cancel button in top left to return data unchanged.
• Add new hide argument to optionally display the dataInput and dataOutput modules. This functionality requires the shinyjs package. The hide argument allows users to maximize the space available to display the data and also prevent users from interacting with these modules. It is still possible to save data to file when dataOutput module is not visible, by simply supplying the file name to the save_as argument of data_edit().
• Improve handling of row names with the dataEdit module.
• Add helper function to handle generation of templates based on inputs to data_edit() to make it easier to create data.frames from scratch. The default template size has been increased to be a 10 x 10 grid.
• Add logo_side argument to control whether the logo should be placed on the left or right of the title.
• Add new code argument to data_edit() to print the code required to create the edited data to the console.

DataEditR 0.0.6

• Add ability to pass column names to data_edit() to construct a template data.frame with pre-defined column names.

DataEditR 0.0.5

• Fix row indices when rows are added or removed.
• Improve handling of duplicate row indices in case of accidental editing.

DataEditR 0.0.4

• Add col_readonly argument to prevent users from editing values or column names of certain columns.
• Prevent error when column is clicked but not edited.

DataEditR 0.0.3

• Add col_names argument to allow control over which column names can be edited by the user.

DataEditR 0.0.2

• Fixes for CRAN submission.

DataEditR 0.0.1

• Add data_edit() to allow interactive data viewing, entry and editing.