Spread Windows Forms 9.0 Product Documentation
AggregationDataModel Class Members
Properties  Methods  Events


The following tables list the members exposed by AggregationDataModel.

Public Constructors
 NameDescription
Public ConstructorAggregationDataModel ConstructorOverloaded.   
Top
Public Properties
 NameDescription
Public PropertyCanSerializeXmlGets a value that indicates whether the specified AggregationDataModel object can serialize to XML.  
Public PropertyColumnCountOverridden. Gets the number of columns in the group.  
Public PropertyNonEmptyColumnCountOverridden. Gets the number of columns in the model that contain data (bound or unbound).  
Public PropertyNonEmptyRowCountOverridden. Gets the number of rows in the model that contain data (bound or unbound).  
Public PropertyReferenceStyleGets or sets the cell reference style for cells with formulas.  
Public PropertyRowCountOverridden. Gets or sets the number of rows in the group.  
Public PropertyTargetModelGets the sheet data model for the aggregation target.  
Public PropertyUnionedChangeCellRangeGets or sets whether the changed event occurs for each cell or for the union range. Works only if initialized from DefaultSheetDataModel. True if event occurs for union range.  
Top
Public Methods
 NameDescription
Public MethodAddColumnsAdds one or more columns to the data model at the specified position.  
Public MethodAddRowsAdds rows to the data model at the specified position.  
Public MethodClearRemoves all the data and formulas from the specified range of cells.  
Public MethodCopyCopies the data from a range of cells to a specified range of cells.  
Public MethodDeserializeLoads the settings from XML.  
Public MethodDisposeDisposes this object.  
Public MethodGetCelAggregationTypeGets the formula of the cell of the specified row and column.  
Public MethodGetCellAggregationFormatSets the format of the cell of the specified row and column.  
Public MethodGetExpressionGets the formula, as an expression value, for the cell of the specified row and column.  
Public MethodGetFormulaGets the formula, as a string value, for the cell of the specified row and column.  
Public MethodGetNoteOverridden. Gets a user-defined note value for the cell of the specified row and column.  
Public MethodGetObjectDataSerializes the AggregationDataModel to the SerializationInfo.  
Public MethodGetTagOverridden. Gets an application-defined tag value for the cell of the specified row and column.  
Public MethodGetValueOverridden. Gets the value from the cell in the group.  
Public MethodIsEditableOverridden. Determines whether the cell in the group is editable.  
Public MethodIsEmptyOverridden. Determines whether the data model is empty.  
Public MethodIsRowUsedOverridden. Determines whether the specified row has data (is not empty).  
Public MethodLoadFormulasLoads formulas that are deserialized but not parsed yet, to be used after all sheets have been created and deserialized or shared with the calculation controller.  
Public MethodMoveMoves the data from a range of cells to the specified location.  
Public MethodNextNonEmptyColumnInRowOverridden. Gets the index of the next column in a specified row that contains data.  
Public MethodNextNonEmptyRowOverridden. Gets the index of the next row that contains data.  
Public MethodRemoveColumnsRemoves one or more columns starting with the column at the specified position.  
Public MethodRemoveRowsRemoves one or more rows, starting with the specified row.  
Public MethodResumeFormulaParsingResumes parsing of formulas and parses all formulas set while parsing was suspended.  
Public MethodSerializeSaves the settings to XML.  
Public MethodSetCellAggregationFormatSets the format for the cell of the specified row and column.  
Public MethodSetCellAggregationTypeSets the formula for the cell of the specified row and column.  
Public MethodSetExpressionSets the formula, as an expression value, for the cell of the specified row and column.  
Public MethodSetFormulaSets the formula, as a string value, for the cell of the specified row and column. If you pass null, it clears the expression from that cell.  
Public MethodSetNoteOverridden. Sets a user-defined note value for the cell at the specified row and column.  
Public MethodSetTagOverridden. Sets an application-defined tag value for the cell of the specified row and column.  
Public MethodSetValueOverridden. Sets the value of the cell in the group.  
Public MethodSuspendFormulaParsingSuspends parsing of formulas.  
Public MethodSwapSwaps the specified ranges of cells.  
Top
Protected Methods
 NameDescription
Protected MethodOnChangedRaises the Changed event, and permits derived classes to handle the event without attaching a delegate. (Inherited from FarPoint.Win.Spread.Model.BaseSheetDataModel)
Top
Public Events
 NameDescription
Public EventChangedOccurs when the user makes a change to the model that affects the data of the sheet. (Inherited from FarPoint.Win.Spread.Model.BaseSheetDataModel)
Top
See Also

Reference

AggregationDataModel Class
FarPoint.Win.Spread.Model Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.