FlexSheet for WPF | ComponentOne
C1.WPF.FlexGrid Namespace / C1FlexSheet Class


In This Topic
    C1FlexSheet Class Methods
    In This Topic

    For a list of all members of this type, see C1FlexSheet members.

    Public Methods
     NameDescription
    Public MethodOverloaded.  (Inherited from System.Windows.UIElement)
    Public MethodOverloaded. Adds a new sheet to this book.  
    Public Method (Inherited from System.Windows.UIElement)
    Public MethodOverloaded.  (Inherited from System.Windows.UIElement)
    Public Method (Inherited from System.Windows.FrameworkElement)
    Public Method (Inherited from System.Windows.UIElement)
    Public MethodResizes a column to fit its visible contents. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public MethodOverloaded. Resizes a column range to fit their visible content. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public MethodResizes a fixed column to fit its visible contents. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public MethodOverloaded. Resizes a range of fixed columns to fit their visible contents. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public MethodResizes a fixed row to fit its visible contents. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public MethodOverloaded. Resizes a range of fixed rows to fit their visible contents. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public MethodResizes a row to fit its visible contents. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public MethodOverloaded. Resizes a row range to fit their visible contents. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public MethodOverloaded.  (Inherited from System.Windows.UIElement)
    Public Method (Inherited from System.Windows.FrameworkElement)
    Public MethodOverloaded.  (Inherited from System.Windows.FrameworkElement)
    Public MethodOverloaded.  (Inherited from System.Windows.FrameworkElement)
    Public Method (Inherited from System.Windows.UIElement)
    Public Method (Inherited from System.Windows.UIElement)
    Public Method (Inherited from System.Windows.UIElement)
    Public MethodClears all nullable/editable cells in a given range.  
    Public MethodClears all nullable cells in the selection.  
    Public MethodOverloaded.  (Inherited from System.Windows.DependencyObject)
    Public Method (Inherited from System.Windows.DependencyObject)
    Public MethodCollapses all the group rows to a given level. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public MethodOverridden. Overridden to copy editor content if the editor is active.  
    Public MethodOverridden.   
    Public Method (Inherited from System.Windows.FrameworkElement)
    Public Method (Inherited from System.Windows.DependencyObject)
    Public MethodEvaluates an expression and returns the result.  
    Public MethodFind all values according to user inputted.  
    Public Method (Inherited from System.Windows.Media.Visual)
    Public Method (Inherited from System.Windows.FrameworkElement)
    Public MethodFind the value according to user inputted.  
    Public Method (Inherited from System.Windows.FrameworkElement)
    Public MethodOverloaded. Commits any pending edits and exits edit mode. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public Method (Inherited from System.Windows.UIElement)
    Public MethodGets the address of a range using Excel notation (e.g. A1).  
    Public MethodCalculates aggregate statistics for a cell range. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public Method (Inherited from System.Windows.UIElement)
    Public Method (Inherited from System.Windows.FrameworkElement)
    Public MethodGets the ICellFactory class responsible for creating and destroying System.Windows.FrameworkElement objects used to represent grid cells. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public MethodOverloaded. Gets the current selection as a string suitable for copying to the clipboard. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public MethodGet comment from cell.  
    Public MethodReturns index of data item in the items source for the specified row index. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public MethodOverloaded. Gets a System.Windows.FrameworkElement that represents a given part of the grid. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public Method (Inherited from System.Windows.DependencyObject)
    Public Method (Inherited from System.Windows.DependencyObject)
    Public MethodOverloaded. Gets a list of elements that represent parts of the grid fit for rendering into pages of a document. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public MethodReturns index of row representing data item with the specified index. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public MethodGets a SelectedState value that indicates the selected state of the cells in a CellRange. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public Method (Inherited from System.Windows.DependencyObject)
    Public MethodGroup rows and create an outline.  
    Public MethodOverloaded. Gets a HitTestInfo object that contains information about the grid at a given location. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public MethodGets a value that determines whether a cell should be included in the aggregates calculated with the GetAggregate method. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public Method (Inherited from System.Windows.UIElement)
    Public MethodInsert chart to FlexSheet.  
    Public MethodInsert comment.  
    Public MethodInsert image to FlexSheet  
    Public MethodInsert SparkLine to C1FlexSheet  
    Public MethodOverloaded. Forces the grid to re-create all visible elements. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public Method (Inherited from System.Windows.UIElement)
    Public Method (Inherited from System.Windows.UIElement)
    Public Method (Inherited from System.Windows.DependencyObject)
    Public Method (Inherited from System.Windows.UIElement)
    Public Method (Inherited from System.Windows.Media.Visual)
    Public Method (Inherited from System.Windows.Media.Visual)
    Public MethodLoad file to C1FlexSheet.  
    Public MethodLoads a column layout from an System.Xml.XmlReader. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public Method (Inherited from System.Windows.UIElement)
    Public Method (Inherited from System.Windows.FrameworkElement)
    Public MethodOverridden. Builds the visual tree for the C1FlexSheet control when a new template is applied.  
    Public MethodOverridden. Overridden to enable undoing paste actions.  
    Public Method (Inherited from System.Windows.Media.Visual)
    Public Method (Inherited from System.Windows.Media.Visual)
    Public Method (Inherited from System.Windows.FrameworkElement)
    Public MethodOverloaded. Prints the grid. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public MethodOverloaded. Displays the window with the print preview content. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public Method (Inherited from System.Windows.UIElement)
    Public Method (Inherited from System.Windows.DependencyObject)
    Public MethodRepeats the last action (valid only when CanRedo returns true).  
    Public Method (Inherited from System.Windows.FrameworkElement)
    Public Method (Inherited from System.Windows.UIElement)
    Public Method (Inherited from System.Windows.UIElement)
    Public Method (Inherited from System.Windows.UIElement)
    Public Method (Inherited from System.Windows.UIElement)
    Public MethodRemove comment  
    Public MethodDelete duplicated rows.  
    Public Method (Inherited from System.Windows.UIElement)
    Public MethodOverloaded. Saves the contents of the grid to a System.IO.StreamWriter. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public MethodSaves the current column layout to an System.Xml.XmlWriter. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public MethodSave html file to stream.  
    Public MethodSaves the grid to a PDF stream.  
    Public MethodSave txt file to stream.  
    Public MethodSave xls file to stream.  
    Public MethodSave xlsx file to stream.  
    Public MethodScrolls the grid to bring a specific cell into view. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public MethodOverloaded. Selects a given cell. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public MethodSelects all cells. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public MethodOverloaded.  (Inherited from System.Windows.FrameworkElement)
    Public MethodSet rotate text for cell  
    Public MethodSet format for cell. eg:SetCellFormat(flex.Selection.Cells, C1.WPF.FlexSheet.CellFormat.Background, new SolidColorBrush(Colors.Red));  
    Public MethodSet text indent for cell  
    Public MethodParses a string into rows and columns and applies the content to a given range. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public Method (Inherited from System.Windows.DependencyObject)
    Public Method (Inherited from System.Windows.FrameworkElement)
    Public MethodOverloaded.  (Inherited from System.Windows.DependencyObject)
    Public MethodShow the filter editor for the currently selected column.  
    Public MethodOverloaded. Starts editing the cell that is currently selected. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Public Method (Inherited from System.Windows.Controls.Control)
    Public MethodOverloaded.  (Inherited from System.Windows.Media.Visual)
    Public Method (Inherited from System.Windows.Media.Visual)
    Public Method (Inherited from System.Windows.Media.Visual)
    Public Method (Inherited from System.Windows.UIElement)
    Public Method (Inherited from System.Windows.FrameworkElement)
    Public MethodUndoes the last action (valid only when CanUndo returns true).  
    Public MethodUngroup rows and create an outline.  
    Public Method (Inherited from System.Windows.FrameworkElement)
    Public MethodUpdate comment  
    Public Method (Inherited from System.Windows.FrameworkElement)
    Public Method (Inherited from System.Windows.UIElement)
    Top
    Protected Methods
     NameDescription
    Protected Method (Inherited from System.Windows.Media.Visual)
    Protected Method (Inherited from System.Windows.FrameworkElement)
    Protected MethodOverridden. Overridden to update the layout of the panel with sheet tabs and horizontal scrollbar.  
    Protected MethodOverridden. Create a row bound to the data item.  
    Protected MethodCreates rows bound to each data item in the current data source. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Protected MethodCreates a details row bound to a given data item. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Protected MethodOverloaded. Creates group rows for the items in the current data source. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Protected Method (Inherited from System.Windows.FrameworkElement)
    Protected MethodFills the lists of row and column breaks used to generate the pages. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Protected Method (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Protected Method (Inherited from System.Windows.FrameworkElement)
    Protected MethodCalculates the zoom factor to use based on the size of the range to print, scale mode, and page size. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Protected MethodOverloaded.  (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.FrameworkElement)
    Protected Method (Inherited from System.Windows.Controls.Control)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected MethodRaises the AutoGeneratingColumn event. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Protected MethodOverridden. Invalidate all formula cells after any edits.  
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.FrameworkElement)
    Protected Method (Inherited from System.Windows.FrameworkElement)
    Protected MethodGets an AutomationPeer object used for testing the control. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Protected Method (Inherited from System.Windows.Media.Visual)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.FrameworkElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.FrameworkElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected MethodRaises the ItemsSourceChanged event. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Protected MethodOverridden. Raises the ItemsSourceChanging event.  
    Protected MethodRaises the System.Windows.UIElement.KeyDown event. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.Controls.Control)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected MethodOverridden. Overridden to handle keyboard shortcuts.  
    Protected MethodOverridden.   
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.Controls.Control)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.FrameworkElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected MethodRaises the ScrollingDeferred event. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Protected MethodRaises the ScrollPositionChanged event. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Protected MethodRaises the ScrollPositionChanging event. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Protected MethodRaises the SelectedItemChanged property. (Inherited from C1.WPF.FlexGrid.C1FlexGrid)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.Controls.Control)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.FrameworkElement)
    Protected Method (Inherited from System.Windows.FrameworkElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.UIElement)
    Protected Method (Inherited from System.Windows.Media.Visual)
    Protected MethodOverridden.   
    Top
    See Also