QtXlsxWriter icon indicating copy to clipboard operation
QtXlsxWriter copied to clipboard

ConditionalFormatting and BackgroundColor how

Open stachna opened this issue 6 years ago • 0 comments

All working but not background color how to fix it.

ConditionalFormatting cf;
Format fmt;
fmt.setBorderStyle(Format::BorderDashed);
fmt.setBorderColor(QColor(0x99, 0xbb, 0xff));
fmt.setFontColor(QColor(0, 0, 0x80));
fmt.setFillPattern(Format::PatternSolid);
fmt.setPatternBackgroundColor(QColor(0xcc, 0xee, 0xff));
cf.addRange("A1:A10);
cf.addHighlightCellsRule(ConditionalFormatting::Highlight_Expression, "A1 <> 1", fmt);

stachna avatar Dec 12 '18 20:12 stachna