Skip to content

Add Excel-style conditional formatting support to AddSheetOptions #14

@davidnmbond

Description

@davidnmbond

Summary

Add Excel-style conditional formatting support to AddSheetOptions.

Scope

  • Add AddSheetOptions.ConditionalFormats
  • Add public configuration types: ConditionalFormat, ConditionalFormatRule, ConditionalFormatStyle, ConditionalFormatRuleType, ConditionalFormatOperator
  • Write OpenXML conditional formatting to generated worksheets
  • Support multiple rules per format and multiple target columns
  • Allow all-column rules when ColumnNames is omitted

Notes

  • The API stays tightly coupled to Excel/OpenXML conditional formatting concepts.
  • Column names match the final exported header text.
  • Multi-column targets emit per-column conditional-formatting blocks so relative formulas evaluate correctly.

Validation

  • Structural OpenXML unit tests cover multiple rules on one column, multiple target columns, and all-column targeting.
  • The generated workbook was manually verified in Excel.

Documentation

  • README usage examples
  • XML documentation examples on the public API
  • Work log entry in IMPROVEMENTS.md

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions