[]
        
(Showing Draft Content)

GrapeCity.Spreadsheet.Slicers.ISlicer

ISlicer Interface

Represents a slicer view to filter data.

Namespace: GrapeCity.Spreadsheet.Slicers
Assembly: GrapeCity.Spreadsheet.dll
Syntax
public interface ISlicer
Public Interface ISlicer

Properties

Name Description
Caption

Gets or sets the caption of the specified slicer.

ColumnWidth

Gets or sets the width, in pixels, of each column in the slicer.

DisableMoveResizeUI

Gets or sets whether the specified slicer can be moved or resized by using the user interface.

DisplayHeader

Gets or sets whether the header that displays the slicer Caption is visible.

Height

Gets or sets the height of the specified slicer, in pixels.

Left

Gets or sets the horizontal position of the specified slicer, in pixels, relative to the upper-left corner of cell A1 on a worksheet.

Locked

Gets or sets a value indicating whether the specified slicer can be modified when the sheet that contains it is protected.

Name

Gets or sets the name of the specified slicer.

NumberOfColumns

Gets or sets the number of columns in the specified slicer.

RowHeight

Gets or sets the height of each row in the specified slicer.

Shape

Gets the IShape object associated with the specified slicer.

SlicerCache

Gets the ISlicerCache object associated with the slicer.

Style

Gets or sets the style currently applied to the specified slicer.

Top

Gets or sets the vertical position of the specified slicer, in pixels, relative to the upper-left corner of cell A1 on a worksheet.

Width

Gets or sets the width of the specified slicer, in pixels.

Methods

Name Description
Copy()

Copies the specified slicer to the clipboard.

Cut()

Cuts the specified slicer and copies it to the clipboard.

Delete()

Deletes the slicer and removes it from the associated ISlicers collection.