Build 3.0.0.116 of xlsgen has a fix related to conditions in number formats.

An example of condition in number format is : [Red][>100]0,00.

It means the number should be displayed in red and two decimals, only if its value is greater than 100. And it means if the condition isn't met, the Standard number format applies, which means for a number no formatting is applied.

By using xlsgen, the use of the FormattedLabel(r,c) property at the worksheet level computes the number format applied a given cell. That is exactly where, starting with build 3.0.0.116, an optional condition is supported in the engine. And this is used for all cells during a print/preview/PDF/XPS/HTML generation.

As a reminder, here is the syntax for optional conditions :

- it is optional
- at most one condition
- must be enclosed in square brackets
- available operators are =, <>, <, <=, >, >=
- at most one operator and exactly one operand that comes with it
- the operand must be a static value such as 100 (i.e. cannot be a formula, a cell reference, etc.)