Closed phargarten2 closed 3 months ago
This issue is stale because it has been open 365 days with no activity. Remove stale label or comment or this will be closed in 7 days.
This issue was closed because it has been stalled for 7 days with no activity.
Describe the bug Thank you for making a package that easily allows me to create complicated Excel sheets from R. The
conditionalFormatting()
function is particularly powerful, and the examples/vignette was helpful.I want to highlight an entire row based on finding text in a column.
To Reproduce For example, from the vignette:
Created on 2023-06-01 with reprex v2.0.2
Expected behavior The entire row should be highlighted, as compared to the first column, wherever an "A" is found. In this case, that would be rows 3, 9, and 10 for columns A and B. The
cols=1:2
argument above for thecontainsText2
sheet is ignored.conditionalFormatting(wb, "containsText2", cols = 1:2, rows = 1:10, type = "expression", rule="FIND(\"A\", A1) > 0")
Screenshots containsText sheet
contatinsText2 sheet
Additional context I attempted to use two different types to find text in an Excel sheet and apply a style. The expression type seems to be more flexible than the contains type.
Other minor issues
FYI: the introduction vignette contains the deprecated
conditionalFormat
function.In the documentation for
conditionalFormatting
, could you add text to roughly describe the default style, as I don't think users will be familiar with hex color codes? (i.e. (Red text overlaid in pink background))? I also figured out that the argumentrule
is essentially an Excel function withtype = "expression"
(the default). Could this be more clear underrules==expression
in the documentation? Just some thoughts to make the function even better.Thank you