• Fixed a bug with missing numeric values rendered as 0 (thanks, @tverbeke, #1000).

• Box scalar elements of 'list' columns so that, e.g., data.frame(col = I(integer(), 1, 2:3)) is represented in JavaScript as [[], [1], [2, 3]] instead of [[], 1, [2, 3]] (thanks, @mtmorgan, #1005).

• Make sure number inputs return numeric values when editing numeric table cells (thanks, @stla, #987).

• Enhancements to updateFilters() (#971):

  • Added support for data with integer and character columns (@mikmart #972).
  • Fixed an issue with length 1 options causing filters not to update (@mikmart #973).
  • Fixed an issue with slider limits sometimes being incorrectly scaled (@mikmart #974).
  • Updates to factor and logical filters now match the initial render (@mikmart #975).
  • Disabled status is now also affected by updates (@mikmart #977).

• New functions doColumnSearch() and doGlobalSearch() let you do server-side searching with filter search strings. These are particularly useful in conjunction with updateFilters() for implementing dynamic limits for filter controls based on currently filtered data (@mikmart #982).

• Server-side searching is now faster when multiple filters are active (@mikmart).

• Fix a bug that the column filter didn't work for strings like "+" (@stephan-hutter @shrektan #980).

NEW FEATURES

• Add the zero.print argument to formatPercentage(), formatCurrency(), formatSignif() and formatRound(), which allows to control the format of zero values. It's useful when the data is "sparse" (thanks, @shrektan #953).

• formatXXX() functions now gain a new argument rows (starting from 1), which can be used to specify the rows that the "style" should be applied to. Note that it only works expected in the client-side processing mode, i.e., server = FALSE. formatStyle() is the only exception that doesn't have this argument and should use styleRow() instead (thanks, @jrecasens @shrektan #520).

• Added a new function updateFilters to allow users to update the filters of a DataTable object that has been updated by reference, such as with replaceData() (thanks, @giadasp #934, @wholmes105 #939).

MAJOR CHANGES

• Now users can provide column names of the data to options$columnDefs$targets. Previously, it only supports column indexes or "_all" (thanks, @shrektan #948).

MINOR CHANGES

• styleRow() and styleEqual() now allows a scalar values argument like other R functions, e.g., styleRow(1:5, 'abcd') is the same as styleRow(1:5, rep('abcd', 5)). It throws error that the length(rows) must be equal to length(values) in the previous version (thanks, @shrektan #955).

BUG FIXES

• Fix the bug that addRow() doesn't support a list of data after R 3.4.0, where structure(NULL, ...) was deprecated (thanks, @stla @shrektan #959).

• Fix the bug that DT table can't vertically fill the container, e.g., RStudio IDE or FlexDashboard (thanks, @mbojan @shrektan #951).

• Fix the bug that DT failed to parse ajax request correctly, when special strings like "=" exist (thanks, @shrektan #965).

MAJOR CHANGES

• Upgraded the DataTables library to v1.11.3 (thanks, @shrektan #942, @michaelquinn32 #940).

NEW FEATUERS

• Add vertical and opacity option to filter which applies to the noUiSliders. This is useful with limited width DataTables to prevent x overflow (thanks, @alexvpickering, #919).

• Now the user is able to restrict the editing to accept only numbers by, e.g., datatable(..., editable = list(target = "cell", numeric = 3:5)). By default, the editing is restricted to numbers for all numeric columns; set numeric = "none" to disable this behavior (thanks, @stla, #860 #824).

• Now the user can request text areas for the editing by, e.g., datatable(..., editable = list(target = "cell", area = 1:2)). Text areas are useful for cells with large contents (thanks, @stla #860, @fabiangehring #671).

MAJOR CHANGES

• Upgraded jQuery from v1.12.4 to v3.x imported from the jquerylib R package (f0043fa).

NEW FEATURES

• datatable()'s style argument now defaults to 'auto', which resolves to either 'bootstrap' or 'bootstrap4' when a {bslib} theme is relevant. If a {bslib} theme isn't relevant, 'auto' resolves to the old default value of 'default' (thanks, @cpsievert, #852).

• Add a new function styleRow(). It's useful when you want to apply CSS styles based on Row Indexes (thanks, @s-fleck, #894).

BUG FIXES

• datatable(data) and datatable(data, fillContainer = TRUE) now work as expected when statically rendered inside flexdashboard::flex_dashboard() (thanks, @cpsievert, #904).

NEW FEATURES

• Support the new datatables' extension SearchBuilder. With this new extension, users can construct a complex search query by adding groups and conditions. Note, as the time of writing, this extension only works on the client-side processing mode (thanks, @stla, #875)

• Add a new plugin diacritics-neutralise, which can be used for searching accented, non-Latin characters with their unaccented counterparts. Note, it will only work in the client-side processing mode (thanks, @tyler-richardett, #887).

MINOR CHANGES

• The autoHideNavigation argument now works with the default theme. In addition, the prerequisite is properly documented. Specifically speaking, it only works when the pageLength option is provided and is rendered in the client-side processing mode (thanks, @bhogan-mitre, #856).

• When editing factor columns, editData() now automatically updates the factor levels if it's necessary (thanks, @aman-malik3010, #865).

BUG FIXES

• Fix the issue that addRow() would fail when the proxy DT table contains no data (e.g., a zero-row data.frame) (thanks, @chalioui, #888).

• DT no longer overrides the options$responsive to TRUE. Thus, it enables users to provide customized options for the Responsive extension (thanks, @hdrab127, #885).

NEW FEATURES

• Add a new plugin accent-neutralise, which can be used for searching accented characters with their unaccented counterparts. Note, it will only work in the client-side processing mode (#822).

• addRow() now has a new parameter resetPaging. By setting it to FALSE, we can keep the paging position after adding a row (thanks, @stanstrup, #853).

MINOR CHANGES

• Upgrade the SearchPanes extension to v1.1.1 so that it can display all the entries properly with the Scroller extension (thanks, @JonasMandel @stla, #820).

• The class argument now keeps user-defined classes with bootstrap themes (thanks, @mmuurr, #806).

• Now DT will throw a clear error message if the value of search provided in datatables(..., options=) is illegal (thanks, @realHenningLorenzen, #848).

BUG FIXES

• Fix the issue that the sorting results may not be expected after formatting functions applied. This is a regression of PR #777 (thanks, @fernandofernandezgonzalez @shrektan, #837).

• styleColorBar() now displays correctly on Safari, when the data is greater than the upper limit, due to negative css percentage values (thanks, @Seyphaton, #843).

BUG FIXES

• Fix the issue that the formatting functions may throw error for named colname inputs (thanks, @jarauh @shrektan, #831).

• The input$xxx_xxx_selected values will always be reset to NULL or an empty list when the table gets reloaded (thanks, @stibu81 @shrektan, #828).