Property | Type | Description | |
---|---|---|---|
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 |
Method | Description | |
---|---|---|
AssertValid ( ) : void | ||
DynamicFilterDialog ( ) : System |
Initializes a new instance of the 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
|
|
GetDynamicFilterRangeTrackBars ( ICollection |
Method | Description | |
---|---|---|
AddDynamicFilterFormulaToTable ( String sWorksheetName, String sTableName, String sDynamicFilterFormula ) : Microsoft.Office.Interop.Excel.Range | ||
AddDynamicFilterTableColumn ( Microsoft oTable ) : Microsoft.Office.Interop.Excel.Range | ||
AddHistogramImageToPictureBox ( String sWorksheetName, |
||
AddHistogramToGroupBox ( String sWorksheetName, |
||
AddLabelToGroupBox ( |
||
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 |
Method | Description | |
---|---|---|
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 |
protected AddDynamicFilterFormulaToTable ( String sWorksheetName, String sTableName, String sDynamicFilterFormula ) : Microsoft.Office.Interop.Excel.Range | ||
sWorksheetName | String | |
sTableName | String | |
sDynamicFilterFormula | String | |
return | Microsoft.Office.Interop.Excel.Range |
protected AddDynamicFilterTableColumn ( Microsoft oTable ) : Microsoft.Office.Interop.Excel.Range | ||
oTable | Microsoft | |
return | Microsoft.Office.Interop.Excel.Range |
protected AddHistogramImageToPictureBox ( String sWorksheetName, |
||
sWorksheetName | String | |
oDynamicFilterParameters | ||
oPictureBox | PictureBoxPlus | |
return | void |
protected AddHistogramToGroupBox ( String sWorksheetName, |
||
sWorksheetName | String | |
oDynamicFilterParameters | ||
oGroupBox | GroupBox | |
iX | Int32 | |
iY | Int32 | |
return | PictureBox |
protected AddLabelToGroupBox ( |
||
oDynamicFilterParameters | ||
oGroupBox | GroupBox | |
iX | Int32 | |
iY | Int32 | |
return | Label |
protected AddRangeTrackBarToGroupBox ( NumericFilterParameters oNumericFilterParameters, String sTableName, GroupBox oGroupBox, StringBuilder oDynamicFilterConditions, Int32 iX, Int32 &iY ) : IDynamicFilterRangeTrackBar | ||
oNumericFilterParameters | NumericFilterParameters | |
sTableName | String | |
oGroupBox | GroupBox | |
oDynamicFilterConditions | StringBuilder | |
iX | Int32 | |
iY | Int32 | |
return | IDynamicFilterRangeTrackBar |
protected AppendConditions ( StringBuilder oDynamicFilterConditions, String sColumnName, String sSelectedMinimumAddress, String sSelectedMaximumAddress ) : void | ||
oDynamicFilterConditions | StringBuilder | |
sColumnName | String | |
sSelectedMinimumAddress | String | |
sSelectedMaximumAddress | String | |
return | void |
protected Dispose ( bool disposing ) : void | ||
disposing | bool | true if managed resources should be disposed; otherwise, false. |
return | void |
public DynamicFilterDialog ( Microsoft workbook ) : System | ||
workbook | Microsoft | /// Workbook containing the graph contents. /// |
return | System |
protected EscapeColumnName ( String sColumnName ) : String | ||
sColumnName | String | |
return | String |
protected FireDynamicFilterColumnsChanged ( DynamicFilterColumns eDynamicFilterColumns ) : void | ||
eDynamicFilterColumns | DynamicFilterColumns | |
return | void |
protected FireFilteredAlphaChanged ( ) : void | ||
return | void |
public GetDynamicFilterRangeTrackBars ( ICollection |
||
edgeDynamicFilterRangeTrackBars | ICollection |
|
vertexDynamicFilterRangeTrackBars | ICollection |
|
return | void |
protected GetRangeTrackBarRanges ( NumericFilterParameters oNumericFilterParameters, String sTableName, Decimal &decAvailableMinimum, Decimal &decAvailableMaximum, Decimal &decSelectedMinimum, Decimal &decSelectedMaximum, String &sSelectedMinimumAddress, String &sSelectedMaximumAddress ) : void | ||
oNumericFilterParameters | NumericFilterParameters | |
sTableName | String | |
decAvailableMinimum | Decimal | |
decAvailableMaximum | Decimal | |
decSelectedMinimum | Decimal | |
decSelectedMaximum | Decimal | |
sSelectedMinimumAddress | String | |
sSelectedMaximumAddress | String | |
return | void |
protected InitializeAndRecalculateDynamicFilterColumns ( ) : void | ||
return | void |
protected InitializeDynamicFilters ( ) : void | ||
return | void |
protected InitializeDynamicFiltersForOneTable ( String sWorksheetName, String sTableName, GroupBox oGroupBox ) : Microsoft.Office.Interop.Excel.Range | ||
sWorksheetName | String | |
sTableName | String | |
oGroupBox | GroupBox | |
return | Microsoft.Office.Interop.Excel.Range |
protected OnSelectedRangeChanged ( IDynamicFilterRangeTrackBar oDynamicFilterRangeTrackBar ) : void | ||
oDynamicFilterRangeTrackBar | IDynamicFilterRangeTrackBar | |
return | void |
protected RangeTrackBar_SelectedRangeChanged ( object sender, EventArgs e ) : void | ||
sender | object | |
e | EventArgs | |
return | void |
protected RecalculateDynamicFilterColumns ( DynamicFilterColumns eDynamicFilterColumns ) : void | ||
eDynamicFilterColumns | DynamicFilterColumns | |
return | void |
protected StartChangeEventDelayTimer ( Object oChangedControl ) : void | ||
oChangedControl | Object | |
return | void |
protected m_oChangeEventDelayTimer_Tick ( object sender, EventArgs e ) : void | ||
sender | object | |
e | EventArgs | |
return | void |
protected Boolean m_bHandleControlEvents | ||
return | Boolean |
protected Timer m_oChangeEventDelayTimer | ||
return | Timer |
protected DynamicFilterDialogUserSettings m_oDynamicFilterDialogUserSettings | ||
return | DynamicFilterDialogUserSettings |
protected DynamicFilterSettings m_oDynamicFilterSettings | ||
return | DynamicFilterSettings |
protected Microsoft.Office.Interop.Excel.Range m_oEdgeDynamicFilterColumnData | ||
return | Microsoft.Office.Interop.Excel.Range |
protected ExcelCalculationRestorer m_oExcelCalculationRestorer | ||
return | ExcelCalculationRestorer |
protected Microsoft.Office.Interop.Excel.Range m_oVertexDynamicFilterColumnData | ||
return | Microsoft.Office.Interop.Excel.Range |