dbzhang800 / QtXlsxWriter

.xlsx file reader and writer for Qt5
http://qtxlsx.debao.me
Other
1.24k stars 631 forks source link

ConditionalFormatting and BackgroundColor how #180

Open stachna opened 5 years ago

stachna commented 5 years ago

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);