 |
| IXlsDynamicRange |
|
COM interface ( getting help with interfaces )
interface IXlsDynamicRange : IDispatch
{
[id(1), propget] HRESULT Name([out, retval] BSTR* name);
[id(2), propget] HRESULT Formula([out, retval] BSTR* formula);
[id(2), propput] HRESULT Formula([in] BSTR formula);
[id(3), propget] HRESULT Hidden([out, retval]BOOL* hidden);
[id(3), propput] HRESULT Hidden([in]BOOL hidden);
[id(4) ] HRESULT Delete();
[id(5), propput] HRESULT BuiltInNamedRange([in]enumBuiltInNamedRange type);
[id(6), propget] HRESULT Worksheet([out, retval]BSTR* worksheetname);
[id(7), propget] HRESULT IsTable([out, retval]BOOL* isTable);
[id(8), propget] HRESULT ValueIterator([out, retval]IXlsDynamicRangeValueIterator** valueIterator);
[id(9), propget] HRESULT Local([out, retval]BOOL* bLocal);
[id(9), propput] HRESULT Local([in]BOOL bLocal);
[id(10),propget] HRESULT Range([out, retval]IXlsRange** range);
[id(11),propput] HRESULT UserDefinedFunction([in]BOOL bUserDefinedFunction);
[id(12),propget] HRESULT Description([out, retval] BSTR* descr);
[id(12),propput] HRESULT Description([in] BSTR descr);
}
HRESULT Name([out, retval] BSTR* name);
retrieves the name of the dynamic range.
HRESULT Formula([out, retval] BSTR* formula);
retrieves the associated formula of the dynamic range.
HRESULT Formula([in] BSTR formula);
defines the formula of the dynamic range.
HRESULT Hidden([out, retval]BOOL* hidden);
returns whether the dynamic range should be hidden.
HRESULT Hidden([in]BOOL hidden);
sets whether the dynamic range should be hidden.
HRESULT Delete();
deletes the dynamic range.
HRESULT BuiltInNamedRange([in]enumBuiltInNamedRange type);
sets the built-in named range type, in case this named range must achieve a particular effect (print area, database, ...).
HRESULT Worksheet([out, retval]BSTR* worksheetname);
retrieves the worksheet name hosting the dynamic range if the dynamic range has a local scope, or an empty string otherwise.
HRESULT IsTable([out, retval]BOOL* isTable);
returns whether the dynamic range represents a table.
HRESULT ValueIterator([out, retval]IXlsDynamicRangeValueIterator** valueIterator);
returns the value iterator.
HRESULT Local([out, retval]BOOL* bLocal);
returns whether the dynamic range should be local to a worksheet.
HRESULT Local([in]BOOL bLocal);
sets whether the dynamic range should be local to a worksheet.
HRESULT Range([out, retval]IXlsRange** range);
returns the range object, if applicable, i.e. calculating the dynamic range returns one or more cell areas.
HRESULT UserDefinedFunction([in]BOOL bUserDefinedFunction);
sets whether the dynamic range should be seen as a user defined function (i.e. callable function).
HRESULT Description([out, retval] BSTR* descr);
retrieves the associated description of the dynamic range.
HRESULT Description([in] BSTR descr);
defines the description of the dynamic range. Excel limits it to less than 256 characters.