Thanks for the excellent ag-grid integration for Shiny!

Is it possible to enable grid csv export? I tried the following but it appeared to not affect the aggrid behavior.

RagGrid::aggrid(mtcars, list(showToolPanel=TRUE, suppressCsvExport=FALSE))

The underlying csv export is described in the ag-grid docs.

The RagGrid does NOT seem to support nested headers as in ag-grid. Any possibility of an enhancement?

Hello,

I am having difficulty configuring a default row grouping when pivot mode is active. When the page/app loads I would like a certain set of rows to be checked in the Columns > Row Group sidebar. What type of R configuration data structure is required to make this configuration work? I've tried a number of data structure formats and none seem to work. For example:

columnDefs = data.frame(
  c(headerName='Price', field='price', pivot=TRUE, rowGroup=TRUE, enableRowGroup=TRUE),
  c(headerName='Quantity', field='quantity', pivot=TRUE, rowGroup=TRUE, enableRowGroup=TRUE)
)

RagGrid::aggrid(
  data,
  colOpts = list(),
  options = list(emablePivot=TRUE, pivotMode=TRUE, columnDefs=columnDefs),
  formattingOptions = list(Price='$0,0.00', Quantity: '$0,0.00')
)

Ideally when the table loads I would like Price and Quantity to both be enabled as Row Groups.

Can you please suggest an alternative data structure to get this working (assuming that's the issue at hand)?

Thank you very much!

Use aggrid enterprise with iris dataset and select group by series

1. Percentage
2. Currency
3. Precision

Filtering options for numbering column are irrelevant

Actual Behavior

Expected Behavior

Error in getDeps("aggrid-enterprice", "17.1.1") :
could not find function "htmlDependency"

I updated the description but this still doesn't work correctly

Is there a way to unescape HTML tags in cell contents as in DT::datatable(escape=FALSE)? I'm afraid my JS skills are very limited. Thx!

It would be easier to contribute if the project license referenced one of these - https://opensource.org/licenses

If you render a RagGrid from a reactive expression then the RagGrid renders multiple times.

The HTML element needs clearing inside renderValue

See what DT does on: https://github.com/rstudio/DT/blob/cd8e49fa69ddb786974fb661c275b780adcbebf9/inst/htmlwidgets/datatables.js#L117

See also a question/answer on https://stackoverflow.com/questions/44348963/replace-existing-r-shiny-htmlwidget-data-with-new-data

Include airtable style sorting , filtering using the community version

I am looking to trap the cellchanged event in Shiny and and get the row /col modified as well as new value. Is there an easy wat to do this?

Can't figure out how to remove the first column from the grid that has the row indexes. There is no label for this column, so I cannot access it programmatically using colOpts.

library(shiny)
library(RagGrid)

ui <- shinyUI(fluidPage(
  title = 'Use the RagGrid package in shiny',
  fluidRow(
    column(2),
    column(8, RagGrid::RagGridOutput('tbl1')),
    column(2)
  )
))

server <- shinyServer(function(input, output, session) {
  output$tbl1 <- renderRagGrid(aggrid(iris))
})

shinyApp(ui = ui, server = server)

Try this

aggrid(USJudgeRatings)

vs 

datatable(USJudgeRatings)