-
Notifications
You must be signed in to change notification settings - Fork 275
Conditional Formatting ‐ Priority
As of Epplus 7.0 you can apply multiple ConditionalFormattings to a singular cell/range with Epplus.
However in some cases two different ConditionalFormattings may affect the look of the same style attribute. For example both may be trying to change the background colour of the cell. Excel and in turn Epplus resolves this with an integer called Priority where a ConditionalFormattingRule has higher priority the lower the value is. Highest possible priority is when priority = 1.
When there is no conflict on a certain attribute it will apply the only attribute that can be found even if its from a ConditionalFormatting with lower priority.
For example in this sample, the highPriority.BackgroundColor will be visible in excel due to its priority but the LowPriority will be making the text italicized. Since highPriority has no Style.Font value.
using (var pck = new ExcelPackage())
{
var sheet = pck.Workbook.Worksheets.Add("prioritySheet");
var lowPriority = sheet.ConditionalFormatting.AddBeginsWith(new ExcelAddress("A1"));
lowPriority.Priority = 500;
lowPriority.Text = "D";
lowPriority.Style.Fill.BackgroundColor.Color = Color.DarkRed;
lowPriority.Style.Font.Italic = true;
var highPriority = sheet.ConditionalFormatting.AddEndsWith(new ExcelAddress("A1"));
highPriority.Text = "r";
highPriority.Priority = 2;
highPriority.Style.Fill.BackgroundColor.Color = Color.DarkBlue;
highPriority.Style.Font.Color.Color = Color.White;
sheet.Cells["A1"].Value = "Danger";
//Change MYPATH to whatever directory you would like to save in.
//For example C:\\PriorityTest if you make a folder of that name.
pck.SaveAs("MYPATH\\priorityTest.xlsx");
}
Expected Result:
EPPlus Software AB - https://epplussoftware.com
- Getting Started
- The Sample Project
- EPPlus and Docker
- EPPlus and Blazor
- EPPlus and Linux
- Security
- Configuration
- Releases/versioning
- What is new in EPPlus 5+
- Breaking Changes in EPPlus 5
- Breaking Changes in EPPlus 6
- Breaking Changes in EPPlus 7
- Addressing a worksheet
- Dimension/Used range
- Copying ranges/sheets
- Insert/Delete
- Filling ranges
- Sorting ranges
- Taking and skipping columns/rows
- Data validation
- Comments
- Freeze and Split Panes
- Header and Footer
- Autofit columns
- Grouping and Ungrouping Rows and Columns
- Formatting and styling
- Conditional formatting
- Using Themes
- Working with custom named table- or slicer- styles