 |
| IXlsSparkline |
|
COM interface ( getting help with interfaces )
interface IXlsSparkline : IDispatch
{
[id(1),propget] HRESULT Count([out, retval]int* nbobjects);
[id(2),propget] HRESULT Item([in]int i, [out, retval]IXlsSparklineElement** sparklineElement);
[id(3)] HRESULT Add([out, retval]IXlsSparklineElement** sparklineElement);
[id(4)] HRESULT Delete([in]int i);
[id(5),propput] HRESULT SparklineType([in]enumSparklineType sparklineType);
[id(5),propget] HRESULT SparklineType([out, retval]enumSparklineType* sparklineType);
[id(6),propput] HRESULT SparklineColor([in]enumSparklineElement element, [in]int rgb);
[id(6),propget] HRESULT SparklineColor([in]enumSparklineElement element, [out, retval]int* rgb);
[id(7),propput] HRESULT ShowMarkers([in]BOOL show);
[id(7),propget] HRESULT ShowMarkers([out, retval]BOOL* show);
[id(8),propput] HRESULT ShowMaximumValue([in]BOOL show);
[id(8),propget] HRESULT ShowMaximumValue([out, retval]BOOL* show);
[id(9),propput] HRESULT ShowMinimumValue([in]BOOL show);
[id(9),propget] HRESULT ShowMinimumValue([out, retval]BOOL* show);
[id(10),propput] HRESULT ShowFirstValue([in]BOOL show);
[id(10),propget] HRESULT ShowFirstValue([out, retval]BOOL* show);
[id(11),propput] HRESULT ShowLastValue([in]BOOL show);
[id(11),propget] HRESULT ShowLastValue([out, retval]BOOL* show);
[id(12),propput] HRESULT ShowNegativeValues([in]BOOL show);
[id(12),propget] HRESULT ShowNegativeValues([out, retval]BOOL* show);
[id(13),propput] HRESULT CustomMinimum([in]double v);
[id(13),propget] HRESULT CustomMinimum([out, retval]double* v);
[id(14),propput] HRESULT CustomMaximum([in]double v);
[id(14),propget] HRESULT CustomMaximum([out, retval]double* v);
[id(15),propput] HRESULT LineWeight([in]double lineweight);
[id(15),propget] HRESULT LineWeight([out, retval]double* lineweight);
[id(16),propput] HRESULT ShowEmptyCellsAs([in]enumChartInterpolate emptycase);
[id(16),propget] HRESULT ShowEmptyCellsAs([out, retval]enumChartInterpolate* emptycase);
[id(17),propput] HRESULT ShowHiddenValues([in]BOOL show);
[id(17),propget] HRESULT ShowHiddenValues([out, retval]BOOL* show);
[id(18),propput] HRESULT ShowAxis([in]BOOL show);
[id(18),propget] HRESULT ShowAxis([out, retval]BOOL* show);
[id(19),propput] HRESULT ShowRightToLeft([in]BOOL show);
[id(19),propget] HRESULT ShowRightToLeft([out, retval]BOOL* show);
[id(20),propput] HRESULT CustomDateAxis([in]BSTR rangeAsFormula);
[id(20),propget] HRESULT CustomDateAxis([out, retval]BSTR* rangeAsFormula);
[id(21),propput] HRESULT IndividualMinimum([in]BOOL b);
[id(21),propget] HRESULT IndividualMinimum([out, retval]BOOL* b);
[id(22),propput] HRESULT IndividualMaximum([in]BOOL b);
[id(22),propget] HRESULT IndividualMaximum([out, retval]BOOL* b);
}
HRESULT Count([out, retval]int* nbobjects);
returns how many sparkline elements are stored.
HRESULT Item([in]int i, [out, retval]IXlsSparklineElement** sparklineElement);
returns the i-th sparkline element. The index starts at 1.
HRESULT Add([out, retval]IXlsSparklineElement** sparklineElement);
adds a sparkline element.
HRESULT Delete([in]int i);
deletes the i-th sparkline element. The index starts at 1.
HRESULT SparklineType([in]enumSparklineType sparklineType);
defines the sparkline type. Default is : lines.
HRESULT SparklineType([out, retval]enumSparklineType* sparklineType);
returns the sparkline type. Default is : lines.
HRESULT SparklineColor([in]enumSparklineElement element, [in]int rgb);
defines the sparkline type. Default is : lines.
HRESULT SparklineColor([in]enumSparklineElement element, [out, retval]int* rgb);
returns the sparkline type. Default is : lines.
HRESULT ShowMarkers([in]BOOL show);
defines whether markers should show. Default is : no.
HRESULT ShowMarkers([out, retval]BOOL* show);
returns whether markers should show. Default is : no.
HRESULT ShowMaximumValue([in]BOOL show);
defines whether the maximum value should show. Default is : no.
HRESULT ShowMaximumValue([out, retval]BOOL* show);
returns whether the maximum value should show. Default is : no.
HRESULT ShowMinimumValue([in]BOOL show);
defines whether the minimum value should show. Default is : no.
HRESULT ShowMinimumValue([out, retval]BOOL* show);
returns whether the minimum value should show. Default is : no.
HRESULT ShowFirstValue([in]BOOL show);
defines whether the first value should show. Default is : no.
HRESULT ShowFirstValue([out, retval]BOOL* show);
returns whether the first value should show. Default is : no.
HRESULT ShowLastValue([in]BOOL show);
defines whether the last value should show. Default is : no.
HRESULT ShowLastValue([out, retval]BOOL* show);
returns whether the last value should show. Default is : no.
HRESULT ShowNegativeValues([in]BOOL show);
defines whether negative values should show. Default is : no.
HRESULT ShowNegativeValues([out, retval]BOOL* show);
returns whether negative values should show. Default is : no.
HRESULT CustomMinimum([in]double v);
defines the minimum value.
HRESULT CustomMinimum([out, retval]double* v);
returns the minimum value.
HRESULT CustomMaximum([in]double v);
defines the maximum value.
HRESULT CustomMaximum([out, retval]double* v);
returns the maximum value.
HRESULT LineWeight([in]double lineweight);
defines the line weight. Applies to sparklines of type line. Default value is : 1.
HRESULT LineWeight([out, retval]double* lineweight);
returns the line weight. Applies to sparklines of type line. Default value is : 1.
HRESULT ShowEmptyCellsAs([in]enumChartInterpolate emptycase);
defines how empty cells should be handled. Default value is : gap.
HRESULT ShowEmptyCellsAs([out, retval]enumChartInterpolate* emptycase);
returns how empty cells should be handled. Default value is : gap.
HRESULT ShowHiddenValues([in]BOOL show);
defines whether hidden cell values should show. Default is : no.
HRESULT ShowHiddenValues([out, retval]BOOL* show);
returns whether hidden cell values should show. Default is : no.
HRESULT ShowAxis([in]BOOL show);
defines whether the axis should show. Default is : no.
HRESULT ShowAxis([out, retval]BOOL* show);
returns whether the axis should show. Default is : no.
HRESULT ShowRightToLeft([in]BOOL show);
defines whether the sparkline should show right to left. Default is : no.
HRESULT ShowRightToLeft([out, retval]BOOL* show);
returns whether the sparkline should show right to left. Default is : no.
HRESULT CustomDateAxis([in]BSTR rangeAsFormula);
defines an optional range of the custom date axis by passing a formula as parameter. Default is : no custom date axis.
HRESULT CustomDateAxis([out, retval]BSTR* rangeAsFormula);
returns an optional range of the custom date axis by passing a formula as parameter. Default is : no custom date axis.
HRESULT IndividualMinimum([in]BOOL b);
defines whether the minimum of sparkline elements is calculated on a per element basis or applies to all elements. Default is : individual.
HRESULT IndividualMinimum([out, retval]BOOL* b);
returns whether the minimum of sparkline elements is calculated on a per element basis or applies to all elements. Default is : individual.
HRESULT IndividualMaximum([in]BOOL b);
defines whether the maximum of sparkline elements is calculated on a per element basis or applies to all elements. Default is : individual.
HRESULT IndividualMaximum([out, retval]BOOL* b);
returns whether the maximum of sparkline elements is calculated on a per element basis or applies to all elements. Default is : individual.