Build 3.5.0.45 of xlsgen adds support for a number of extended databar properties in the object model. Extended databars were introduced in Excel 2010.
Among the exposed properties are :
- NegativeColor : RGB type
- ShowBorders : BOOLEAN type
- BordersColor : RGB type
- BordersNegativeColor : RGB type
- AxisColor : RGB type
- NegativeColorSameAsPositive : BOOL type
- NegativeBordersColorSameAsPositive: BOOL type
In essence, the above properties allow customization of databar borders, as well as colors for negative values, as well as the axis color separating positive and negative values.
And also, in sub conditions :
- Length : int type
This property allows to better align the databar with the column width. Use a value of 0 to align on the left. And use a value of 100 (expressed in percent) to align on the right.