• Главная
• Smrf
• NodeXL
• ExcelTemplate
• DynamicFilterDialog

C# Класс Smrf.NodeXL.ExcelTemplate.DynamicFilterDialog

Показать файл Открыть проект Примеры использования класса

Защищенные свойства (Protected)

Свойство	Тип	Описание
m_bHandleControlEvents	Boolean
m_oChangeEventDelayTimer	Timer
m_oDynamicFilterDialogUserSettings	DynamicFilterDialogUserSettings
m_oDynamicFilterSettings	DynamicFilterSettings
m_oEdgeDynamicFilterColumnData	Microsoft.Office.Interop.Excel.Range
m_oExcelCalculationRestorer	ExcelCalculationRestorer
m_oVertexDynamicFilterColumnData	Microsoft.Office.Interop.Excel.Range
m_oWorkbook	Microsoft.Office.Interop.Excel.Workbook

Открытые методы

Метод	Описание
AssertValid ( ) : void
DynamicFilterDialog ( ) : System	Initializes a new instance of the class for the Visual Studio designer. Do not use this constructor. It is for use by the Visual Studio designer only.
DynamicFilterDialog ( Microsoft workbook ) : System	Initializes a new instance of the class with a workbook.
GetDynamicFilterRangeTrackBars ( ICollection &edgeDynamicFilterRangeTrackBars, ICollection &vertexDynamicFilterRangeTrackBars ) : void

Защищенные методы

Метод	Описание
AddDynamicFilterFormulaToTable ( String sWorksheetName, String sTableName, String sDynamicFilterFormula ) : Microsoft.Office.Interop.Excel.Range
AddDynamicFilterTableColumn ( Microsoft oTable ) : Microsoft.Office.Interop.Excel.Range
AddHistogramImageToPictureBox ( String sWorksheetName, DynamicFilterParameters oDynamicFilterParameters, PictureBoxPlus oPictureBox ) : void
AddHistogramToGroupBox ( String sWorksheetName, DynamicFilterParameters oDynamicFilterParameters, GroupBox oGroupBox, Int32 iX, Int32 &iY ) : PictureBox
AddLabelToGroupBox ( DynamicFilterParameters oDynamicFilterParameters, GroupBox oGroupBox, Int32 iX, Int32 iY ) : Label
AddRangeTrackBarToGroupBox ( NumericFilterParameters oNumericFilterParameters, String sTableName, GroupBox oGroupBox, StringBuilder oDynamicFilterConditions, Int32 iX, Int32 &iY ) : IDynamicFilterRangeTrackBar
AppendConditions ( StringBuilder oDynamicFilterConditions, String sColumnName, String sSelectedMinimumAddress, String sSelectedMaximumAddress ) : void
Dispose ( bool disposing ) : void	Clean up any resources being used.
EscapeColumnName ( String sColumnName ) : String
FireDynamicFilterColumnsChanged ( DynamicFilterColumns eDynamicFilterColumns ) : void
FireFilteredAlphaChanged ( ) : void
GetRangeTrackBarRanges ( NumericFilterParameters oNumericFilterParameters, String sTableName, Decimal &decAvailableMinimum, Decimal &decAvailableMaximum, Decimal &decSelectedMinimum, Decimal &decSelectedMaximum, String &sSelectedMinimumAddress, String &sSelectedMaximumAddress ) : void
InitializeAndRecalculateDynamicFilterColumns ( ) : void
InitializeDynamicFilters ( ) : void
InitializeDynamicFiltersForOneTable ( String sWorksheetName, String sTableName, GroupBox oGroupBox ) : Microsoft.Office.Interop.Excel.Range
OnClosed ( EventArgs e ) : void
OnLoad ( EventArgs e ) : void
OnSelectedRangeChanged ( IDynamicFilterRangeTrackBar oDynamicFilterRangeTrackBar ) : void
RangeTrackBar_SelectedRangeChanged ( object sender, EventArgs e ) : void
RecalculateDynamicFilterColumns ( DynamicFilterColumns eDynamicFilterColumns ) : void
ResetAllDynamicFilters ( ) : void
SetManualCalculation ( ) : void
StartChangeEventDelayTimer ( Object oChangedControl ) : void
m_oChangeEventDelayTimer_Tick ( object sender, EventArgs e ) : void

Приватные методы

Метод	Описание
InitializeComponent ( ) : void	Required method for Designer support - do not modify the contents of this method with the code editor.
btnClose_Click ( object sender, EventArgs e ) : void
btnReadWorkbook_Click ( object sender, EventArgs e ) : void
btnResetAllDynamicFilters_Click ( object sender, EventArgs e ) : void
chkDoNotFilterNonNumericCells_CheckedChanged ( object sender, EventArgs e ) : void
nudFilteredAlpha_ValueChanged ( object sender, EventArgs e ) : void

Описание методов

Описание свойств