Conditional formatting and column removal

[michaelhogersosis]

Hi there,

Thanks for this amazing package. I would like to ask if it is possible to both have editable/removable columns, while simultaneously applying formatting with the renderer.

           rhandsontable(current$current, col_highlight = col_highlight,
                          row_highlight = row_highlight, useTypes = FALSE, width = '100%') %>%
                          hot_context_menu(allowRowEdit = TRUE, allowColEdit = TRUE) %>%
                          hot_col(1, renderer =  "

           function (instance, td, row, col, prop, value, cellProperties) {
                          Handsontable.renderers.TextRenderer.apply(this, arguments);
                          td.style.background = 'green';
                          td.style.color = 'white';
                          
                          if (instance.params) {
                          hcols = instance.params.col_highlight
                          hcols = hcols instanceof Array ? hcols : [hcols]
                          hrows = instance.params.row_highlight
                          hrows = hrows instanceof Array ? hrows : [hrows]
                          }

                          if (instance.params && hrows.includes(row)){
                            td.style.background = 'red';
                            td.style.color = 'white';
                          }"
                    })

The renderer above breaks the possibility to edit the columns unfortunately.

[jrowen]

Could you please include the definition of the current variable.

[lz100]

Hi @jrowen I would like to ask the same thing, could we trun useTypes to FALSE and formatting cells the same time? My code is similar

rhandsontable(t.df, useTypes = FALSE, row_highlight = 2) %>% 
                hot_context_menu(allowRowEdit = TRUE, allowColEdit = TRUE) %>% 
                hot_cols(renderer =  "function(instance, td, row, col, prop, value, cellProperties) {
                           Handsontable.renderers.TextRenderer.apply(this, arguments);
                           if (instance.params) {
                             hrows = instance.params.row_highlight
                             hrows = hrows instanceof Array ? hrows : [hrows] 
                           }
                           if (instance.params && hrows.includes(row)) td.style.background = 'pink';
                         }
                         ")

t.df can be any dataframe, e.g. t.df = data.frame(A=rep("a", 5), B=TRUE, C=1)

I think the problem is the TextRenderer, since TextRenderer=FALSE changed it not to be any JS type.

Could you give some clues how to make the change?