 |
| IXlsDatabarCondition |
|
COM interface ( getting help with interfaces )
interface IXlsDatabarCondition : IDispatch
{
[id(1),propget] HRESULT ShortestBar([out, retval]IXlsDatabarSubCondition** sbc);
[id(2),propget] HRESULT LongestBar([out, retval]IXlsDatabarSubCondition** lbc);
[id(3),propput] HRESULT ShowBarsOnly([in]BOOL showbarsonly);
[id(3),propget] HRESULT ShowBarsOnly([out, retval]BOOL* showbarsonly);
[id(4),propget] HRESULT Color([out, retval] int* nRGB);
[id(4),propput] HRESULT Color([in]int nRGB);
[id(5),propget] HRESULT ShowBorders([out, retval]BOOL* showborders);
[id(5),propput] HRESULT ShowBorders([in]BOOL showborders);
[id(6),propget] HRESULT BordersColor([out, retval] int* nRGB);
[id(6),propput] HRESULT BordersColor([in]int nRGB);
[id(7),propget] HRESULT BordersNegativeColor([out, retval] int* nRGB);
[id(7),propput] HRESULT BordersNegativeColor([in]int nRGB);
[id(8),propget] HRESULT NegativeColor([out, retval] int* nRGB);
[id(8),propput] HRESULT NegativeColor([in]int nRGB);
[id(9),propget] HRESULT AxisColor([out, retval] int* nRGB);
[id(9),propput] HRESULT AxisColor([in]int nRGB);
[id(10),propget] HRESULT NegativeColorSameAsPositive([out, retval]BOOL* negativeColorSame);
[id(10),propput] HRESULT NegativeColorSameAsPositive([in]BOOL negativeColorSame);
[id(11),propget] HRESULT NegativeBordersColorSameAsPositive([out, retval]BOOL* negativeBordersColorSame);
[id(11),propput] HRESULT NegativeBordersColorSameAsPositive([in]BOOL negativeBordersColorSame);
[id(12),propget] HRESULT GradientFill([out, retval]BOOL* borderGradientFill);
[id(12),propput] HRESULT GradientFill([in]BOOL borderGradientFill);
[id(13),propget] HRESULT Direction([out, retval] enumTextReadingOrder* readingOrder);
[id(13),propput] HRESULT Direction([in]enumTextReadingOrder readingOrder);
[id(14),propget] HRESULT AxisPosition([out, retval] enumDatabarAxisPosition* axisposition);
[id(14),propput] HRESULT AxisPosition([in]enumDatabarAxisPosition axisposition);
[id(15),propput] HRESULT Formula([in]BSTR formula);
[id(15),propget] HRESULT Formula([out, retval]BSTR* formula);
}
HRESULT ShortestBar([out, retval]IXlsDatabarSubCondition** sbc);
creates conditions for the shortest databar.
HRESULT LongestBar([out, retval]IXlsDatabarSubCondition** lbc);
creates conditions for the longest databar.
HRESULT ShowBarsOnly([in]BOOL showbarsonly);
sets whether only data bars are shown (values are hidden). Default value is NO.
HRESULT ShowBarsOnly([out, retval]BOOL* showbarsonly);
retrieves whether whether only data bars are shown (values are hidden). Default value is NO.
HRESULT Color([out, retval] int* nRGB);
retrieves the primary color of the databar.
HRESULT Color([in]int nRGB);
sets the primary color of the databar. Uses a 24-bit color number or an enumerated type. Default is : black.
HRESULT ShowBorders([out, retval]BOOL* showborders);
retrieves whether borders should show. Applies to Excel 2010 XLSX files only (and above).
HRESULT ShowBorders([in]BOOL showborders);
sets whether borders should show. Applies to Excel 2010 XLSX files only (and above).
HRESULT BordersColor([out, retval] int* nRGB);
retrieves the color of borders. Applies to Excel 2010 XLSX files only (and above).
HRESULT BordersColor([in]int nRGB);
sets the color of borders. Applies to Excel 2010 XLSX files only (and above).
HRESULT BordersNegativeColor([out, retval] int* nRGB);
retrieves the color of borders for negative values. Applies to Excel 2010 XLSX files only (and above).
HRESULT BordersNegativeColor([in]int nRGB);
sets the color of borders for negative values. Applies to Excel 2010 XLSX files only (and above).
HRESULT NegativeColor([out, retval] int* nRGB);
retrieves the color for negative values of the databar. Applies to Excel 2010 XLSX files only (and above).
HRESULT NegativeColor([in]int nRGB);
sets the color for negative values of the databar. Applies to Excel 2010 XLSX files only (and above).
HRESULT AxisColor([out, retval] int* nRGB);
retrieves the axis color for the databar, separating positive and negative values, if applicable. Applies to Excel 2010 XLSX files only (and above).
HRESULT AxisColor([in]int nRGB);
sets the axis color for the databar, separating positive and negative values, if applicable. Applies to Excel 2010 XLSX files only (and above).
HRESULT NegativeColorSameAsPositive([out, retval]BOOL* negativeColorSame);
retrieves whether the color for negative values should be the same than for positive values. Default is : FALSE. Applies to Excel 2010 XLSX files only (and above).
HRESULT NegativeColorSameAsPositive([in]BOOL negativeColorSame);
sets whether the color for negative values should be the same than for positive values. Default is : FALSE. Applies to Excel 2010 XLSX files only (and above).
HRESULT NegativeBordersColorSameAsPositive([out, retval]BOOL* negativeBordersColorSame);
retrieves whether the borders color for negative values should be the same than for positive values. Default is : TRUE. Applies to Excel 2010 XLSX files only (and above).
HRESULT NegativeBordersColorSameAsPositive([in]BOOL negativeBordersColorSame);
sets whether the borders color for negative values should be the same than for positive values. Default is : TRUE. Applies to Excel 2010 XLSX files only (and above).
HRESULT GradientFill([out, retval]BOOL* borderGradientFill);
retrieves whether borders should have a gradient fill or a solid fill. Default is : gradient fill. Applies to Excel 2010 XLSX files only (and above).
HRESULT GradientFill([in]BOOL borderGradientFill);
sets whether borders should have a gradient fill or a solid fill. Default is : gradient fill. Applies to Excel 2010 XLSX files only (and above).
HRESULT Direction([out, retval] enumTextReadingOrder* readingOrder);
retrieves the bar reading order, among content, left to right and right to left. Default value : context. Applies to Excel 2010 XLSX files only (and above).
HRESULT Direction([in]enumTextReadingOrder readingOrder);
sets the bar reading order, among content, left to right and right to left. Default value : context. Applies to Excel 2010 XLSX files only (and above).
HRESULT AxisPosition([out, retval] enumDatabarAxisPosition* axisposition);
retrieves the axis position differentiating positive and negative values. Applies to Excel 2010 XLSX files only (and above).
HRESULT AxisPosition([in]enumDatabarAxisPosition axisposition);
sets the axis position differentiating positive and negative values. Applies to Excel 2010 XLSX files only (and above).
HRESULT Formula([in]BSTR formula);
puts an optional formula for dynamically limiting the area where the databar applies.
HRESULT Formula([out, retval]BSTR* formula);
gets an optional formula for dynamically limiting the area where the databar applies.