Spread WPF Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace
Inheritance Hierarchy
Provides the base classes, enumerations, and interfaces for the core document functionality.
Classes
 ClassDescription
ClassRepresents an automatic format.
ClassRepresents an average condition.
ClassRepresents an average condition rule.
ClassBase class for axes.
ClassRepresents the 3D axis class.
ClassProvides a container for a SeriesDataCollection of object.
ClassRepresents the base sparkline view information class.
ClassRepresents settings for the border line.
ClassRepresents data for the border line.
ClassRepresents a BorderLineLayoutEngine object.
ClassRepresents the text label element displayed for a data point value of the BubbleDataSeries.
ClassRepresents chart symbol of BubbleDataSeries.
ClassRepresents data points for BubbleDataSeries.
ClassRepresents a cell in the GcSpreadSheet component.
ClassRepresents the data for the CellChanged event.
ClassRepresents a selected range of cells for a sheet.
ClassRepresents a range of Cell objects.
ClassRepresents a cells enumerator for any area of the sheet.
ClassRepresents a skipped cell.
ClassRepresents a cell value condition rule.
ClassProvides a base class for event data of chart changed event.
ClassProvides data for the ChartChanged event.
ClassDefines how you want the chart label to appear.
ClassProvides data for the ChartSelectionChanged event.
ClassDefines how you want the chart symbol to look.
ClassRepresents an element that specifies how the title of a chart is painted.
ClassRepresents a color condition.
ClassRepresents a column in the control.
ClassRepresents a column header for the sheet.
ClassRepresents a range of Column objects.
ClassRepresents the base column sparkline view information class.
ClassRepresents the data for ColumnSwapped event during sorting.
ClassRepresents a format condition collection.
ClassRepresents a condition base object.
ClassRepresents a connection base for the data source.
ClassRepresents a data source class for Csv data binding.
ClassRepresents a data bar object for drawing.
ClassRepresents the data bar set rule.
ClassRepresents the text label element that displayed for a data point value.
ClassDefines the settings for data label.
ClassRepresents the base class for 2D chart symbols.
ClassRepresents the single data point that may have several data values.
ClassProvides a container for a collection of SpreadDataSeries.
ClassRepresents a data validator base.
ClassRepresents a date condition.
ClassRepresents a date condition.
ClassRepresents a date occurring rule.
ClassRepresents the document attachment for the PDF document.
ClassProvides a container for a SeriesDataCollection of double.
ClassRepresents a base drawing object for rules.
ClassRepresents a duplicate condition rule.
ClassInternal use only.
ClassProvides information when an error occurs during loading or saving an excel file.
Class 
ClassProvides data for the FloatingObjectSelectionChanged event.
ClassRepresents a collection for a floating object.
ClassProvides a container for a collection of FloatingObject.
ClassProvides data for the FloatingObjectSelectionChanged event.
ClassRepresents a base rule for conditional rules.
ClassRepresents a formula condition.
ClassRepresents a formula rule.
ClassRepresents a general formatter.
ClassRepresents a header for the sheet area base.
ClassRepresents a default row filter.
ClassRepresents icon criteria.
ClassRepresents an icon object for drawing.
ClassRepresents the icon set rule.
ClassRepresents the dimensions of borders and margins.
ClassRepresents a legend area in the chart.
ClassRepresents the legend for the 3D surface chart.
ClassRepresents metadata for a line object.
ClassRepresents the base line sparkline view information class.
ClassSpecifies the dimensions of the printed page margins.
ClassRepresents a custom named expression that can be used by formulas.
ClassRepresents a collection that notifies listeners of dynamic changes when items are added and removed or the entire collection object is reset.
ClassRepresents a base collection that notifies listeners of dynamic changes when items are added and removed or the entire collection object is reset.
ClassRepresents a number condition.
ClassRepresents the text label element displayed for a data point value of the OpenHighLowCloseDataSeries.
ClassRepresents chart symbol of OpenHighLowCloseDataSeries.
ClassRepresents data points for OpenHighLowCloseDataSeries.
ClassSpecifies the paper size.
ClassRepresents the settings for the PDF exporter.
ClassRepresents a picture in spread.
ClassProvides data for the PictureChanged event.
ClassProvides data for the PictureSelectionChanged event.
ClassRepresents the plot areas for the chart.
ClassRepresents the information to use when printing a Worksheet.
ClassRepresents the printer settings for the PDF viewer.
ClassRepresents a preset print range.
ClassRepresents a range group for the worksheet.
ClassRepresents state information of the range group.
ClassRepresents the range grouping information.
ClassRepresents a relation condition.
ClassRepresents a row in the component.
ClassRepresents a row filter base that supports row filters for filtering rows in a sheet.
ClassRepresents a row header for the sheet.
ClassRepresents a range of Row objects.
ClassRepresents the data for RowsSwapped event during sorting.
ClassRepresents a general scale rule.
ClassRepresents a scale value.
ClassThe Serializer class.
ClassProvides a base collection for series data.
ClassRepresents the data with a specified change type for the CellChanged event.
ClassRepresents the event data for the Changed event of the worksheet selection.
ClassRepresents the full (concrete) implementation of the ISheetSpanModel interface for a worksheet span model, which represents cell spans.
ClassInterface that supports creating a model that represents cell spans.
ClassRepresents span model event data.
ClassRepresents a table which can be added in a sheet.
ClassRepresents the information related to sorting columns, rows, or a range of cells.
ClassRepresents the Sparkline object.
ClassRepresents a group of Excel-like sparklines.
ClassRepresents a setting of an Excel-like sparkline.
ClassRepresents a text condition rule.
ClassThe BubbleSeries can contain values that specify the symbol size for each data point. Use BubbleSeries to create bubble charts.
ClassRepresents a chart instance in Spread.
ClassRepresents the base chart implementation.
ClassA base class for all the elements of the chart.
ClassRepresents a strongly typed collection for SpreadChartElement.
ClassProvides a container for a collection of SpreadChart.
ClassRepresents the base chart and shape implementation.
ClassA spread chart element that displays text.
ClassRepresents a data series which contains a group of data values.
ClassRepresents a data series with x, y, high, and low values.
ClassRepresents an open-high-low-close series in a Y plot area.
ClassProvides a container for a collection of Picture.
ClassRepresents a surface chart instance in spread.
ClassA spread chart element that represents a surface chart.
ClassProvides a container for a collection of SpreadSurfaceChart.
ClassRepresents a spread theme class.
ClassRepresents all built-in themes.
ClassRepresents data series with X- and Y-values.
ClassRepresents data series that contains collection of 3D points.
ClassProvides a container for a SeriesDataCollection of string.
ClassRepresents the set of cell-level style settings for objects.
ClassRepresents a collection of custom styles (StyleInfo objects).
ClassRepresents the event data for the NamedStyleCollection object's Changed event.
ClassProvides data for the SurfaceChartChanged event.
ClassProvides data for the SurfaceChartSelectionChanged event.
ClassRepresents table style settings.
ClassRepresents a TableStyleInfo object.
ClassRepresents a built-in table style collection.
ClassRepresents a text condition.
ClassRepresents a number condition.
ClassRepresents the theme color class.
ClassRepresents the theme color of built-in themes.
ClassRepresents the three color scale rule.
ClassRepresents a time condition.
ClassRepresents a top 10 condition.
ClassRepresents a top 10 rule.
ClassRepresents the two color scale rule.
ClassRepresents a unique condition rule.
ClassDefines how you want the 3D chart to look.
ClassRepresents a ViewportInfo object.
ClassRepresents the winloss line sparkline view information class.
ClassRepresents a workbook for the component.
ClassRepresents a sheet.
ClassRepresents a sheet collection.
ClassRepresents the text label element displayed for a data point value of the XYDataSeries.
ClassRepresents chart symbol of XYZDataSeries.
ClassRepresents data points for XYDataSeries.
ClassRepresents the text label element displayed for a data point value of the XYZDataSeries.
ClassRepresents chart symbol of XYZDataSeries.
ClassRepresents data points for XYZDataSeries.
Interfaces
 InterfaceDescription
InterfaceRepresents an actual value object.
InterfaceDefines the interface for BubbleDataPoint.
InterfaceRepresents an object that can evaluate an expression or a function.
InterfaceRepresents a CellRange object.
InterfaceInterface that supports cell, column, and row operations.
InterfaceInterface that defines the methods and properties required by objects used to format foreground values.
InterfaceDefines the interface for DataPoint.
InterfaceRepresents the interface for the floating object.
InterfaceInterface that defines the methods and properties required by objects used as formatters.
InterfaceRepresents an object that provides data to a sparkline.
InterfaceRepresents a sheet that hosts the sparkline.
InterfaceRepresents an interface for supporting a theme context.
InterfaceRepresents an interface for supporting a theme.
InterfaceAn interface that executes code from the UI.
InterfaceDefines the interface for XYDataPoint.
InterfaceDefines the interface for XYZDataPoint.
Delegates
 DelegateDescription
DelegateThe skip handler.
Enumerations
 EnumerationDescription
EnumerationRepresents the type of drag fill.
EnumerationSpecifies the type for the average condition.
EnumerationSpecifies how the axis crosses the perpendicular axis.
EnumerationSpecifies the position of the axis labels.
EnumerationSpecifies the axis position.
EnumerationSpecifies the axis tick position.
EnumerationSpecifies the unit of time.
EnumerationSpecifies the axis type.
EnumerationSpecifies the direction of the data bar.
EnumerationSpecifies the line drawing style for the border.
EnumerationSpecifies the horizontal alignment of the cell.
EnumerationSpecifies vertical alignment for the cell.
EnumerationSpecifics the type of centering for the printed page.
EnumerationSpecifies how to change the chart position when cells move.
EnumerationSpecifies what data is pasted from the Clipboard.
EnumerationSpecifies how a cell style compares to a specified style.
EnumerationSpecifies the conditional format operators.
EnumerationRepresents which type of cell data is copied when invoking the worksheet's Copy or Move method.
EnumerationSpecifies the criteria type of the data validator.
EnumerationSpecifies the custom cell value type.
EnumerationSpecifies the position of the axis.
EnumerationRepresents the orientation of the range.
EnumerationSpecifies the date comparison type.
EnumerationSpecifies a condition for when a date occurs.
EnumerationSpecifies the destination types for internal and external links.
EnumerationSpecifies how to show an empty value from a data series in the chart.
Enumeration 
EnumerationSpecifies the icons used in the error alert.
EnumerationThe type of Excel workbook.
EnumerationSpecifies what part of the Excel-compatible file to load into the spreadsheet.
EnumerationSpecifies what part of the spreadsheet to export to an Excel-compatible file.
EnumerationRepresents the fill data time policy.
EnumerationSpecifies the direction of the fill in the view.
EnumerationRepresents the series type of fill data.
EnumerationSpecifies the format string mode for a formatter.
EnumerationSpecifies the comparison type for data.
EnumerationSpecifies the background gradient style.
EnumerationSpecifies the status of an outline (range group).
EnumerationSpecifies which default labels are displayed in headers.
EnumerationSpecifies the icon set.
EnumerationSpecifies the scale type for the value.
EnumerationSpecifies how to align the legend.
EnumerationSpecifies the labels' position relative to the legend.
EnumerationSpecifies the position of the legend.
EnumerationSpecifies the data point marker type.
EnumerationSpecifies the month in which the date occurs.
EnumerationIndicates how to serialize the picture.
EnumerationOptions for ceil and floor appearance.
EnumerationSpecifies the order in which pages are printed.
EnumerationSpecifies the page orientation used for printing.
EnumerationSpecifies in which quarter of the year the date occurs.
EnumerationSpecifies the display state of the label in radar chart.
EnumerationSpecifies the status of a range group summary row or column position.
EnumerationSpecifies the reference style in formulas and custom names in the sheet.
EnumerationSpecifies the relation operator.
EnumerationSpecifies the scale type for the value.
EnumerationSpecifies the type of search flags.
EnumerationSpecifies where the search string is found.
EnumerationSpecifies the type of search direction.
EnumerationSpecifies how users can select items in the control.
EnumerationSpecifies the smallest unit users or the application can select.
EnumerationSpecifies various display options for the data series.
EnumerationSpecifies the options for the border setting.
EnumerationSpecifies the area in the sheet.
EnumerationSpecifies the type of sheet event.
EnumerationSpecifies the type of Change event that has occurred for a span model for the sheet.
EnumerationDefines how the resize tip is shown for a GcSpreadsheet control.
EnumerationSpecifies how the scroll tip is shown for a GcSpreadsheet control.
EnumerationIndicates the sort state.
EnumerationAn enumeration that specifies information about how the vertical axis minimum or maximum is computed for this sparkline group.
EnumerationRepresents the sparkline type.
EnumerationSpecifies the type of date value.
EnumerationSpecifies the chart type.
EnumerationSpecifies the type of surface chart.
EnumerationSpecifies the type of storage data.
EnumerationSpecifies the dash type.
EnumerationSpecifies the type of change event that has occurred for the style in the collection.
EnumerationSpecifies the comparison type for text data.
EnumerationSpecifies the text comparison operator.
EnumerationSpecifies how to process the data when saving to a text file.
EnumerationSpecifies the import flags.
EnumerationSpecifies the export flags.
EnumerationDefines the tick appearance.
EnumerationSpecifies the title type.
EnumerationSpecifies the type for the top 10 condition.
EnumerationSpecifies whether this is a unique condition.
EnumerationSpecifies the unit of measurement.
EnumerationSpecifies whether the area is visible.
See Also

Reference

GrapeCity.WPF.SpreadSheet.Data Assembly