DT 0.14

NEW FEATURES

• Now the user is able to control the selection range by datatable(..., selection = list(selectable = 3:5)), where positive and non-positive selectable means "enable" and "disable", respectively (thanks, @tomasreigl @shrektan, #201 #793).

• Added a function styleValue() to use column values as CSS values. When the user has a complex CSS rule to apply, storing the CSS values in the columns of the table and call this function is very convenient (thanks, @Mosk915 @shrektan, #801 #802).

• Clicking on a row or cell now always triggers a reactive event in Shiny (input$tableId_row_last_clicked or input$tableId_cell_clicked), even if the same row or cell is clicked multiple times (thanks @gadenbuie, #811).

BUG FIXES

• Fix the issue that formatting functions don't support vectorized arguments any longer. This was a regression of PR #777 (thanks, @pbreheny @shrektan, #790).

• Fix the issue that styleEqual() incorrectly uses the column values as the default css values. This was a regression of PR #702 (thanks, @Chr96er @shrektan, #799)

MINOR CHANGES

• The formatting functions now throw clearer error messages when called on non-datatables objects (thanks, @shrektan, #785).

• Now the server argument in renderDT() is reactive in Shiny (thanks, @shrektan, #794).

• Incorrect selection param now triggers a clear error message on the R side (thanks, @shrektan, #795).

DT 0.13

BUG FIXES

• Fix a bug that on Windows, rmarkdown can't render a file that contains DT with PDF download button enabled (thanks, @mfherman @shrektan, #774)

• The formatting function will no longer throw errors for non-existing columns (thanks, @philibe @shrektan, #623).

• Fix a bug that renderDT() doesn't react to ... arguments (thanks, @AlfTang @shrektan, #152).

• Now DT will always display black text in the RStudio IDE, even under a dark theme like "Cobalt" (thanks, @GegznaV @shrektan, #447 #767).

• Fix the issue that DT doesn't look well in pkgdown (thanks, @jayhesselberth @shrektan, #563).

NEW FEATURES

• All the formatting functions except formatStyle() now support the Responsive plugin (thanks, @andirey @shrektan, #776 #777 #782)

DT 0.12

NEW FEATURES

• Support the Select extension on the client-side processing mode (thanks, @shrektan, #744).

• Support features/scrollResize plug-in (thanks, @andrewkho @shrektan, #467 #754).

• Upgrade DataTables to 1.10.20 and support the new datatables extension SearchPanes (thanks, @shrektan, #756).

BUG FIXES

• The server no longer throws warnings when conducting searching (thanks, @bquast @shrektan, #749).

• Fix a bug that the row generated by the RowGroup extension can't be used as the selector of the DataTables' callback event handlers (thanks, @wiktorowczarz @shrektan, #759).

• Fix a bug that addRow() can't add a data.table row to the proxy (thanks, @sifodia @shrektan, #760 #761).

• Now DT displays the column alignment and the selection style correctly under the bootstrap4 theme (thanks, @pjvandam @shrektan, #601 #765).

DT 0.11

NEW FEATURES

• Support pagination plug-ins (#734).

BUG FIXES

• Highlighting when searching with regex (i.e., using options = list(searchHighlight = TRUE, search = list(regex = TRUE)) for the table) works now (thanks, @lrasmus, #719).

• Updated the AutoFill extension (thanks, @stla @shrektan, #711).

MINOR CHANGES

• In the server-side processing mode, filters now use Perl-compatible regular expressions (regexps), such as for lookround and negating assertions, see help(regex) or https://perldoc.perl.org/perlre.html. This may be most useful in columns (DT::renderDataTable(filter = list(position = "top"), options = list(search = list(regex = TRUE))), but also works in the global search (thanks, @rfhb, #727).

• For a factor column, the choices of the filter now use the factor levels (#728).

DT 0.10

BUG FIXES

• Fix the issue that styleEqual() doesn't work expectedly for values contain special HTML character like > or < (thanks, @hjia222 #723).

DT 0.9

NEW FEATURES

• formatStyle() with styleEqual() is now chainable by default (thanks, @e-kennedy #632).

BUG FIXES

• Fix the issue that the first column can't be disabled from editing (thanks, @tsolloway #669, @haozhu233 #694).

• Fix the issue that the filter boxes are not anchored to the corresponding value columns when there are many columns (thanks, @philibe, #554).

• Column selection now works in row+column selection mode, when one of scrollX or scrollY is enabled (thanks, @akarslan #705).

MINOR CHANGES

• Upgraded DataTables from 1.10.16 to 1.10.19.

DT 0.8

BUG FIXES

• For datatable(), options$buttons now works as expected when providing a scalar string or a boolean value (thanks, @shrektan, #685 #658).

• Fix the issue that when parameters of the formatXXX() functions contain single quotes, they may lead to incorrect JavaScript code due to failing to escape the single quotes (thanks, @shrektan #683 #666, @lorenzwalthert #667).

DT 0.7

BUG FIXES

• Bulk table editing doesn't work for the client-side processing mode without Shiny (e.g. a DataTable on a static HTML page).

DT 0.6

NEW FEATURES

• The table editor has been enhanced: now the editable argument of datatable() can take four possible values, cell (or TRUE for backward compatibility), row, column, or all, which means you can edit a single cell a time, or a whole row or column, or all cells in the table. To trigger the editor, doubleclick on any cell. To submit the edit, hit Ctrl + Enter when multiple cells are being edited, or hit Esc to cancel the edit. See https://github.com/rstudio/DT/tree/master/inst/examples/DT-edit for comprehensive examples (thanks, @LukasK13 #509 and @mgirlich #493).

• Editing can be disabled on specified columns now: pass a list of the form list(target = TARGET, disable = list(columns = INDICES)) to the editable argument of datatable(), where TARGET can be 'cell', 'row', 'column', or 'all', and INDICES is an integer vector of column indices (thanks, @opremicSebastian #657, @l-ts #550).

• Added a funcFilter argument to DT::renderDT() (thanks, @galachad, #638).

BUG FIXES

• Fixed the issue where replaceData() didn't work when used in Shiny modules (thanks, @donarus, #628, #626).

• The JavaScript event cell_edit now always triggers a reactive event on the R side. Since cell_edit will only be triggered when the value shown on the table has been changed so it's almost always what user expects (thanks, @shrektan @stelmath, #647 #645).

• Fix the issue that the server-side search option doesn't handle exotic encoding correctly, because after httpuv v1.5.0, shiny::parseQueryString() always assumes the input is an UTF-8 encoded string (thanks, @shrektan @phileas-condemine, #656).

DT 0.5

NEW FEATURES

• Added the Shiny async support (thanks, @jcheng5, #549; @alexturcan, #543).

• The filters of Date or Datetime columns now display the same format and timezone as the column content if formatDate() is applied on these columns (thanks, @shrektan, #522 #241).

• You can now show and hide columns from shiny using showCols() and hideCols(), and reorder the the display of columns using colReorder() (thanks, @gergness, #527).

• You can now set the default CSS value in styleEqual() by using the newe param default (thanks, @shrektan, #558, #546).

• The js callbacks generated from the format*() functions will be executed in sequential order. formatString() will change the cells based on the existing content rather than the raw data (thanks, @shrektan, #576).

• Added the DataTables plugin ellipsis (thanks, @jarauh, #603).

BUG FIXES

• styleInterval() and styleEqual() now generates the correct callback for Date and Datetime values. (thanks, @shrektan, #500, #495).

• The dt-right class will no longer be added to numeric headers unexpectedly (thanks, @shrektan @carlganz @vnijs, #514 #512 #511 #476).

• The printing values of NA and Inf can be controlled by getOption('DT.TOJSON_ARGS') in the server-side processing mode now. (thanks, @shrektan, #536 #513).

• styleEqual(), styleInterval() and styleColorBar() now generate correct javascript values when options(OutDec = ',') (thanks, @shrektan @mteixido, #516 #515).

• Fixed a bug that selectRows() and selectColumns() behave erratically for scalar inputs or character inputs (thanks, @shrektan #528).

• The server-side processing mode now supports data with nested data.frames in its columns (thanks, @shrektan, #530 #525).

• The colReorder extention now works with the column filters and the server-side processing mode (thanks @shrektan, #532 #531 #160).

• Fix the bug that formatDate() may display dates off by one day when method = "toLocaleDateString" (thanks, @shrektan @DevMui, #539 #538).

• Fix the bug that in IE11, the scroll bar of the filter will disappear when you try to click it (thanks, @shrektan, #557 #556).

• coerceValue() no longer throws warnings for class charactor (thanks, @shrektan, #541 #542).

• Fix the bug that using DT as a htmlwidget inside UI throws an error (thanks, @shrektan, #583).

• The RowReorder extension now works (thanks, @shrektan, #595 #592).