row/col length set in options not respected

[nanxstats]

It looks like row and col set in options are not effective, although the other parameters are. I'm not sure if this is from upstream, but here is a minimal reproducible example:

library("shiny")
library("RXSpreadsheet")

ui <- fluidPage(
  RXSpreadsheetOutput(outputId = "example")
)

server <- function(input, output) {
  output$example <- RXSpreadsheet::renderRXSpreadsheet({
    df <- dataFrameListToList(list(
      "sheet1" = data.frame(matrix(rnorm(25), nrow = 5, ncol = 5))
    ))
    RXSpreadsheet(df, options = list(
      "showGrid" = FALSE,
      "row" = list("len" = 10),
      "style" = list(bgcolor = "#DDD")
    ))
  })
}

shinyApp(ui = ui, server = server)

Thanks for creating the package.

[MichaelHogers]

Hi Nan,

Thank you for raising this issue. I have been doing a bit of testing and it seems that the actual javascript library works correctly with the len setting for row and col.

Upgrading the xspreadsheet.js file for RXSpreadsheet unfortunately did not do the trick. There might be an issue in the list to JSON conversion, I will check it later.

Best regards,

Michael