Build 3.0.0.24 of xlsgen adds 4 predefined conditional formattings to XLS and XLSX files.
These are text-based conditional formattings, i.e. conditional formattings which highlight cells based on a rule governed by a text condition.
The 4 text conditions are :
- beginningWith
- endingWith
- containing
- notContaining
Internally, the 4 predefined conditional formattings are replaced by Excel formulas and stored in XLS and XLSX files as such.
Here is an example :
xlsgen::IXlsConditionalFormattingPtr cf = wksht->NewRange(L"R2C1:R10C1")->NewConditionalFormatting();
cf->PredefinedCondition->BeginsWith(L"apple");
cf->Style = style2;