IXlsDatabarSubCondition

COM interface ( getting help with interfaces )

interface IXlsDatabarSubCondition : IDispatch
{
  [id(1),propput] HRESULT ImplicitValue([in]BOOL implicit);
  [id(2),propput] HRESULT ExplicitValueAsFormula([in]BSTR formula);
  [id(3),propput] HRESULT ExplicitPercentAsFormula([in]BSTR formula);
  [id(4),propput] HRESULT ExplicitFormulaAsFormula([in]BSTR formula);
  [id(5),propput] HRESULT ExplicitPercentileAsFormula([in]BSTR formula);
  [id(6),propput] HRESULT Length([in]int lengthPercent);
  [id(6),propget] HRESULT Length([out, retval]int* lengthPercent);

}

HRESULT ImplicitValue([in]BOOL implicit);
sets whether data bars are defined by their implicit min/max values. Default value is YES.

HRESULT ExplicitValueAsFormula([in]BSTR formula);
sets whether data bars are defined by an explicit value, expressed as a formula. Example : =10.

HRESULT ExplicitPercentAsFormula([in]BSTR formula);
sets whether data bars are defined by an explicit percent value, expressed as a formula.

HRESULT ExplicitFormulaAsFormula([in]BSTR formula);
sets whether data bars are defined by an explicit formula.

HRESULT ExplicitPercentileAsFormula([in]BSTR formula);
sets whether data bars are defined by an explicit percentile value, expressed as a formula.

HRESULT Length([in]int lengthPercent);
sets the length of the minimum or maximum bar, accordingly, in percent of the column width. Applies to Excel 2010 XLSX files only (and above).

HRESULT Length([out, retval]int* lengthPercent);
retrieves the length of the minimum or maximum bar, accordingly, in percent of the column width. Applies to Excel 2010 XLSX files only (and above).