excelR icon indicating copy to clipboard operation
excelR copied to clipboard

Automatically changing the color of text in a cell when user makes changes in excelR

Open Leo-Lee15 opened this issue 6 years ago • 2 comments

Thanks for this awesome package!

I have a question. Is there a way to know which cells are edited by the user in shiny apps. Say, automatically changing the color of text in a cell when user makes changes in excelR. If the user makes changes in some cells, then the color of the text in these cells or the can be changed accordingly. Just like the following Excel screenshot.

image

Besides, how can I turn the table into a heatmap? Just like the rhandsontable package?See the following example:

image

rhandsontable Introduction

Thanks again for this super useful package! Hope you can consider my feature requests.

Leo-Lee15 avatar Sep 17 '19 15:09 Leo-Lee15

Currently there is no such feature in the package. Thank you sending these requests, I'll surely consider these requests and try to include it in the future versions.

There is no automatic way for changing the color of text in a cell when user makes changes in excelR, however that can be done with bit of R code, by checking the previous and current data and using style parameter.

Swechhya avatar Sep 18 '19 11:09 Swechhya

Thanks for your instructions!

Leo-Lee15 avatar Sep 19 '19 00:09 Leo-Lee15