search

awalker89 / openxlsx

R package for .xlsx file reading and writing.
Other
365 stars 78 forks source link

Question - conditionalFormatting for column with missing cell values #531

Open freddiebailey opened 3 years ago

freddiebailey commented 3 years ago

Expected Behavior

I have a table of data which I want to use the function conditionalFormatting() with, using "type = colour scale". For columns where the cells contain all non-missing values, the colourScale type works great. However, I have a number of columns where cells contain some NA values (which I do not want to remove). Whenever there is a column with NA my code doesn't work. It currently looks like this:

Expected


Actual Behavior

Conditionally format the columns containing missing cells using a colour scale argument in conditionalFormatting(). When I open up the spreadsheet I have created in Excel then I am able to conditionally format this manually, but I want this to be an automated process. It should look like this:

Actual


Steps to Reproduce the Problem

My code is:

conditionalFormatting(wb, new_sheet2, cols = 1, rows = 2:(nrow(My_Report) + 1), type = "colourScale", rule = c((min(My_Report[1])), (max(My_Report[1]))), style = c("pink", "red"))

conditionalFormatting(wb, new_sheet2, cols = 2, rows = 2:(nrow(My_Report) + 1), type = "colourScale", rule = c((min(My_Report[2])), (max(My_Report[2]))), style = c("pink", "red"))


sessionInfo()


ycphs commented 2 years ago

Could you please create an issue at ycphs/openxlsx?

This is the active fork of the package.