Planned activities for 0.3

[bedantaguru]

These are the planned activity for 0.3.0
These are in progress in nightly
Few of these may be dropped (as all of these are experimental)

• Complete Heuristic maturation phase 1 : complete Create Example Data on which read_cells works (as expected) #5
• Introduce grammar
• %<^% kind of symbols for NNE etc.
• Add shinytest prototype as described in Adopt to shinytest structure to include shiny modules in native coverage #13
• Compatibility of cell traceback with external operations (like {unpivotr} etc)
• Multi routes tests
• Optional packages availability based test
• Mark cell-analysis for remodelling into a state (maybe in later version)
• {DT} based table plots - check DT based table plots / display #16
• reveal.js – Presentation for various topics
• {pkgdown} tweaks [like all tables to DT etc]
• Explore Github Actions as guided in this. Also check Add tests on other CI(s) #18
• Fix all issues tagged as bug like ( cell_df not retaining other columns #20 )

[bedantaguru]

Also, follow a release routine for stability in the release process.

[bedantaguru]

Here are a few references for

{DT} based table plots

• There is an option to select cells in native DataTable (see this link)
• There is an option in DT that works with shiny only (sample of development code given below)
• Most likely native DataTable option is not going to work in DT and Shiny (Here are references for that)
  • Feature request: Selecting multiple rows using shift+click rstudio/DT#305
  • Integrate Select Extension rstudio/DT#717
  • Warn if Select ext is used in server mode or with selection enabled rstudio/DT#743

require(tidycells)
require(DT)

xl <- tidyxl::xlsx_cells("inst/extdata/marks.xlsx")
fmt <-tidyxl::xlsx_formats("inst/extdata/marks.xlsx")

cd <- as_cell_df(xl)

cdd <- as.data.frame(cd)

require(shiny)

std_opts <- list(
  pageLength = 10,
  keys = TRUE,
  sDom = '<"top">lrt<"bottom">pB',
  deferRender = TRUE,
  #scrollX = TRUE,
  scrollX= 400,
  scrollY = 500,
  scroller = TRUE,
  scrollCollapse = TRUE,
  ordering = FALSE,
  fixedColumns = TRUE,
  fixedHeader = TRUE
)


runGadget(shinyApp(
  ui = fluidPage(DTOutput("dt")),
  server = function(input, output){
    output$dt <- renderDT({
      datatable(cdd,
                escape = FALSE,
                rownames = TRUE,
                style = "bootstrap",
                fillContainer = FALSE,
                class = "cell-border stripe",
                extensions = c("KeyTable", "Scroller","FixedHeader"),
                selection = list(target = 'cell'),
                #editable = TRUE,
                options = std_opts)
    })
  }
))

I'll test it and keep a watch on the same.

[bedantaguru]

Just tested this feature as mentioned here it is still not well connected to shiny. Hence going ahead with DT option. Maybe in later versions of DT this feature will be implemented.

(Here is the comment on this from DT developer)

DT has its own implementation of row/column/cell selections in Shiny, which is very different from the Select extension. In particular, the Select extension is unlikely to work in the server-side processing mode. On the other hand, DT’s implementation does not allow multiple selections via the Shift/Ctrl keys at the moment.

[bedantaguru]

It [DT and Shiny with Select Extension] seems doable. However, this should be kept as an optional feature.