ConditionalFormatting in Export

The possibility to include the conditional formatting of the grid and columns in the export to Excel was added.

ExcelConditionalFormatting

In order to configure this, in WorkWtihPlus for Web Settings -> Actions > Export Action there is a new property named 'Include Conditional Formatting', which needs to have the value 'True'.

Also, you can configure the format for Excel file of each conditional formatting, in WorkWithPlus for Web Settings > Grid node > Property 'Row Conditional Formatting Options' > Excel Format column:

SettingsConditionalFormattingOptions

For each one, you can include more than one format separated by ';'. The possible values are: Italic, Bold, Underline and Color:<COLOR_NUMBER> (i.e: Italic;Bold;Color=RGB(221,75,57). Note: The Color format must be set as the last format.

The conditional formatting options supported for Excel files are row conditional formatting and column conditional formatting.