SpreadsheetGear 2023
CustomLists Property (IWorkbookSet)

SpreadsheetGear Namespace > IWorkbookSet Interface : CustomLists Property
Gets or sets the custom lists used by IRange.AutoFill and IRange.DataSeries (null by default).
Property CustomLists As System.Collections.IList
Dim instance As IWorkbookSet
Dim value As System.Collections.IList
instance.CustomLists = value
value = instance.CustomLists
System.Collections.IList CustomLists {get; set;}

Property Value

Returns the currently set custom lists which are null by default.

The IRange.AutoFill and IRange.DataSeries methods support built-in lists consisting of long and short day and month names in the culture of the workbook set. These built-in custom lists may not be modified.

In addition, custom lists may be specified for the workbook set with this IWorkbookSet.CustomLists property. This can be a single list such as an array of strings or it can be a list of lists to specify more than one custom list.


Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also


IWorkbookSet Interface
IWorkbookSet Members
AutoFill Method
DataSeries Method