Altaxo user manual and class reference
Altaxo class reference
Altaxo Namespaces
Altaxo.Worksheet Namespaces
Altaxo.Worksheet.Commands
AbstractWorksheetControllerCommand Class
AddDataColumns Class
AddPropertyColumns Class
AltaxoProvokeException Class
Analysis2DCenteredFFT Class
Analysis2DFFT Class
AnalysisDifferentiateSmooth Class
AnalysisExportPLSCalibration Class
AnalysisFFT Class
AnalysisInterpolation Class
AnalysisMasterCurveCreation Class
AnalysisMultiplyColumnsToMatrix Class
AnalysisMultivariateLinearRegression Class
AnalysisPCAOnCols Class
AnalysisPCAOnRows Class
AnalysisPLSOnCols Class
AnalysisPLSPredictOnCols Class
AnalysisPronyRelaxationFrequencyDomain Class
AnalysisPronyRelaxationTimeDomain Class
AnalysisPronyRetardationFrequencyDomain Class
AnalysisPronyRetardationTimeDomain Class
AnalysisStatisticsCreateHistogram Class
AnalysisStatisticsOnColumns Class
AnalysisStatisticsOnRows Class
ChangeRowsToPropertyColumns Class
ColumnCommands Class
Convolute Class
Correlate Class
CreatePropertyColumnOfColumnNames Class
DataSourceCommands Class
DataTablesAggregationCreation Class
DecomposeByColumnContent Class
DecomposeCyclingIndependentVariable Class
EditClean Class
EditCommands Class
EditCopy Class
EditPaste Class
EditRemove Class
EditTableDataSource Class
ExportAscii Class
ExportGalacticSPC Class
ExportRamanCHADA Class
ExtractPropertyValues Class
FillWithValue Class
GotoTableRow Class
ImportAnyDataFile Class
ImportAscii Class
ImportAsciiInSingleWorksheetHorizontally Class
ImportAsciiInSingleWorksheetVertically Class
ImportBrukerOpus Class
ImportDatabase Class
ImportDataFileCommandBase<TImporter> Class
ImportGalacticSPC Class
ImportImage Class
ImportJcamp Class
ImportNexus Class
ImportOmnicSPA Class
ImportOmnicSPG Class
ImportOrigin Class
ImportPrincetonInstrumentsSPE Class
ImportRamanCHADA Class
ImportRenishawWdf Class
ImportWiTec Class
InsertDataRows Class
InsertOneDataRow Class
OpenDataColumnScriptDialog Class
OpenExtractTableDataScriptDialog Class
OpenFileImportScriptDialog Class
OpenProcessSourceTablesScriptDialog Class
OpenPropertyColumnScriptDialog Class
OpenTableScriptDialog Class
PlotBarChartNormal Class
PlotBarChartRelativeStack Class
PlotBarChartStack Class
PlotColumnChartNormal Class
PlotColumnChartRelativeStack Class
PlotColumnChartStack Class
PlotCommands Class
PlotCommands3D Class
PlotCommonColumnsCommand Class
PlotDensityImage Class
PlotDensityImageFromXYZ Class
PlotLine Class
PlotLineAndScatter Class
PlotLineArea Class
PlotLinePolar Class
PlotLineRelativeStack Class
PlotLineStack Class
PlotLineWaterfall Class
PlotScatter Class
PLSModelConditionEvaluator Class
PLSPlotCrossPredictedVersusActualYIndividually Class
PLSPlotCrossPRESSValue Class
PLSPlotPredictedVersusActualYIndividually Class
PLSPlotPredictionScores Class
PLSPlotPreprocessedSpectra Class
PLSPlotPRESSValue Class
PLSPlotXCrossResidualsIndividually Class
PLSPlotXLeverage Class
PLSPlotXResidualsIndividually Class
PLSPlotYCrossResidualsIndividually Class
PLSPlotYResidualsIndividually Class
PLSQuestPreferredNumberOfFactors Class
RemoveAllButSelected Class
RenameColumn Class
RequeryTableDataSource Class
RowCommands Class
SaveAs Class
SaveAsTemplate Class
SelectColumns Class
SelectedDataConditionEvaluator Class
SelectedPropertyConditionEvaluator Class
SetColumnAsError Class
SetColumnAsLabel Class
SetColumnAsNegativeError Class
SetColumnAsPositiveError Class
SetColumnAsValue Class
SetColumnAsX Class
SetColumnAsY Class
SetColumnGroupNumber Class
SetColumnPosition Class
SetColumnValues Class
SetRowPosition Class
SortColumnsByPropertyColumnAscending Class
SortColumnsByPropertyColumnDescending Class
SortTableAscending Class
SortTableDescending Class
SpectroscopyFitPeaksInMultipleSpectra Class
SpectroscopyPeakFindingFitting Class
SpectroscopyPreprocessing Class
SpectroscopyRamanNeonCalibration Class
SpectroscopyRamanSiliconCalibration Class
SpectroscopyYCalibration Class
TableDataSourcePresentConditionEvaluator Class
TableShowProperties Class
WorksheetClearDataAll Class
WorksheetClearDataOnly Class
WorksheetClearDataTableShowDialog Class
WorksheetCommands Class
WorksheetDuplicate Class
WorksheetMoveTo Class
WorksheetRemoveDataAndPropertyColumns Class
WorksheetRemoveDataColumnsOnly Class
WorksheetRemovePropertyColumnsOnly Class
WorksheetRename Class
WorksheetTranspose Class
XYVToMatrix Class
Click or drag to resize

Altaxo.Worksheet.Commands Namespace

Contains worksheet commands for editing, plotting, data sources, and files.
Classes
 ClassDescription
Public classAbstractWorksheetControllerCommand Provides an abstract base class for commands that apply to worksheet controllers.
Public classAddDataColumns Adds data columns to the active worksheet.
Public classAddPropertyColumns Adds property columns to the active worksheet.
Public classAltaxoProvokeException Menu point to provoke an exception.
Public classAnalysis2DCenteredFFT Performs a centered two-dimensional Fourier transform on the active worksheet data.
Public classAnalysis2DFFT Performs a two-dimensional Fourier transform on the active worksheet data.
Public classAnalysisDifferentiateSmooth Differentiates and smooths the selected data.
Public classAnalysisExportPLSCalibration Exports a partial least squares calibration.
Public classAnalysisFFT Performs a Fourier transform on the active worksheet data.
Public classAnalysisInterpolation Interpolates the selected data.
Public classAnalysisMasterCurveCreation Opens the master-curve creation dialog.
Public classAnalysisMultiplyColumnsToMatrix Multiplies selected columns to form a matrix.
Public classAnalysisMultivariateLinearRegression Performs multivariate linear regression.
Public classAnalysisPCAOnCols Performs principal component analysis on columns.
Public classAnalysisPCAOnRows Performs principal component analysis on rows.
Public classAnalysisPLSOnCols Performs partial least squares analysis on columns.
Public classAnalysisPLSPredictOnCols Predicts values by using a partial least squares model on columns.
Public classAnalysisPronyRelaxationFrequencyDomain Performs Prony relaxation analysis in the frequency domain.
Public classAnalysisPronyRelaxationTimeDomain Performs Prony relaxation analysis in the time domain.
Public classAnalysisPronyRetardationFrequencyDomain Performs Prony retardation analysis in the frequency domain.
Public classAnalysisPronyRetardationTimeDomain Performs Prony retardation analysis in the time domain.
Public classAnalysisStatisticsCreateHistogram Creates a histogram from the selected data.
Public classAnalysisStatisticsOnColumns Calculates statistics on columns.
Public classAnalysisStatisticsOnRows Calculates statistics on rows.
Public classChangeRowsToPropertyColumns Converts selected rows into property columns.
Public classColumnCommands Contains static functions for handling column commands.
Public classConvolute Convolves the selected worksheet data.
Public classCorrelate Correlates the selected worksheet data.
Public classCreatePropertyColumnOfColumnNames Creates a property column that contains the data column names.
Public classDataSourceCommands Contains commands for working with worksheet data sources.
Public classDataTablesAggregationCreation Creates a table aggregation data source from the active worksheet.
Public classDecomposeByColumnContent Decomposes selected data by column content.
Public classDecomposeCyclingIndependentVariable Decomposes a cycling independent variable into separate columns.
Public classEditClean Cleans the selected worksheet content.
Public classEditCommands Contains worksheet edit commands.
Public classEditCopy Copies the current worksheet selection.
Public classEditPaste Pastes clipboard content into the active worksheet.
Public classEditRemove Removes the selected worksheet content.
Public classEditTableDataSource Opens the data source editor for the active worksheet.
Public classExportAscii Exports the active worksheet as ASCII text.
Public classExportGalacticSPC Exports the active worksheet as a Galactic SPC file.
Public classExportRamanCHADA Exports the active worksheet as a Raman CHADA file.
Public classExtractPropertyValues Extracts property values into worksheet data.
Public classFillWithValue Opens a dialog to select a value (text, numeric, or DateTime), then fills the selected cells or the entire table with it.
Public classGotoTableRow Opens a dialog to enter a row number, and then jumps to that row in the worksheet view.
Public classImportAnyDataFile Opens a reduced import dialog for any supported data file type.
Public classImportAscii Imports ASCII data into the active worksheet.
Public classImportAsciiInSingleWorksheetHorizontally Imports ASCII data horizontally into a single worksheet.
Public classImportAsciiInSingleWorksheetVertically Imports ASCII data vertically into a single worksheet.
Public classImportBrukerOpus Imports Bruker OPUS files.
Public classImportDatabase Imports database data into the active worksheet.
Public classImportDataFileCommandBaseTImporter Provides a generic base class for data-file import commands.
Public classImportGalacticSPC Imports Galactic SPC files.
Public classImportImage Imports image files.
Public classImportJcamp Imports JCAMP files.
Public classImportNexus Imports NeXus files.
Public classImportOmnicSPA Imports Omnic SPA files.
Public classImportOmnicSPG Imports Omnic SPG files.
Public classImportOrigin Imports Origin files.
Public classImportPrincetonInstrumentsSPE Imports Princeton Instruments SPE files.
Public classImportRamanCHADA Imports Raman CHADA files.
Public classImportRenishawWdf Imports Renishaw WDF files.
Public classImportWiTec Imports WITec files.
Public classInsertDataRows Inserts multiple data rows.
Public classInsertOneDataRow Inserts a single data row.
Public classOpenDataColumnScriptDialog Opens the data-column script dialog.
Public classOpenExtractTableDataScriptDialog Opens the extract-table-data script dialog.
Public classOpenFileImportScriptDialog Opens the file-import script dialog.
Public classOpenProcessSourceTablesScriptDialog Opens the process-source-tables script dialog.
Public classOpenPropertyColumnScriptDialog Opens the property-column script dialog.
Public classOpenTableScriptDialog Opens the worksheet table script dialog.
Public classPlotBarChartNormal Plots the selected data as a normal bar chart.
Public classPlotBarChartRelativeStack Plots the selected data as a relative stacked bar chart.
Public classPlotBarChartStack Plots the selected data as a stacked bar chart.
Public classPlotColumnChartNormal Plots the selected data as a normal column chart.
Public classPlotColumnChartRelativeStack Plots the selected data as a relative stacked column chart.
Public classPlotColumnChartStack Plots the selected data as a stacked column chart.
Public classPlotCommands PlotCommands contains methods for creating different plot types.
Public classPlotCommands3D PlotCommands contains methods for creating different plot types.
Public classPlotCommonColumnsCommand Saves the options for the 'Plot common columns' command and contains the logic to execute that command with the stored options.
Public classPlotDensityImage Plots the selected data as a density image.
Public classPlotDensityImageFromXYZ Plots the selected XYZ data as a density image.
Public classPlotLine Plots the selected data as a line plot.
Public classPlotLineAndScatter Plots the selected data as a combined line and scatter plot.
Public classPlotLineArea Plots the selected data as a line-area plot.
Public classPlotLinePolar Plots the selected data as a polar line plot.
Public classPlotLineRelativeStack Plots the selected data as a relative stacked line plot.
Public classPlotLineStack Plots the selected data as a stacked line plot.
Public classPlotLineWaterfall Plots the selected data as a waterfall plot.
Public classPlotScatter Plots the selected data as a scatter plot.
Public classPLSModelConditionEvaluator This condition is true if the active view content is a worksheet which contains PLS model data.
Public classPLSPlotCrossPredictedVersusActualYIndividually Plots cross-predicted versus actual Y values for a PLS model.
Public classPLSPlotCrossPRESSValue Plots the cross-validated PRESS value for a PLS model.
Public classPLSPlotPredictedVersusActualYIndividually Plots predicted versus actual Y values for a PLS model.
Public classPLSPlotPredictionScores Plots prediction scores for a PLS model.
Public classPLSPlotPreprocessedSpectra Plots preprocessed spectra for a PLS model.
Public classPLSPlotPRESSValue Plots the PRESS value for a PLS model.
Public classPLSPlotXCrossResidualsIndividually Plots X cross-residuals for a PLS model.
Public classPLSPlotXLeverage Plots X leverage values for a PLS model.
Public classPLSPlotXResidualsIndividually Plots X residuals for a PLS model.
Public classPLSPlotYCrossResidualsIndividually Plots Y cross-residuals for a PLS model.
Public classPLSPlotYResidualsIndividually Plots Y residuals for a PLS model.
Public classPLSQuestPreferredNumberOfFactors Queries the preferred number of PLS factors.
Public classRemoveAllButSelected Removes all worksheet content except the current selection.
Public classRenameColumn Renames the selected column.
Public classRequeryTableDataSource Requeries the data source of the active worksheet.
Public classRowCommands Contains static functions for handling row commands.
Public classSaveAs Saves the active worksheet.
Public classSaveAsTemplate Saves the active worksheet as a template.
Public classSelectColumns Selects columns based on properties of the currently selected data column.
Public classSelectedDataConditionEvaluator Evaluates conditions that depend on the number of selected data columns. Valid values are all (all columns must be selected), none (no column must be selected), one (exactly one column must be selected), any (one or more columns must be selected), or a numeric column count.
Public classSelectedPropertyConditionEvaluator Evaluates conditions that depend on the number of selected property columns. Valid values are all (all columns must be selected), none (no column must be selected), one (exactly one column must be selected), any (one or more columns must be selected), or a numeric column count.
Public classSetColumnAsError Marks the selected column as an error column.
Public classSetColumnAsLabel Marks the selected column as a label column.
Public classSetColumnAsNegativeError Marks the selected column as a negative error column.
Public classSetColumnAsPositiveError Marks the selected column as a positive error column.
Public classSetColumnAsValue Marks the selected column as a value column.
Public classSetColumnAsX Marks the selected column as an X column.
Public classSetColumnAsY Marks the selected column as a Y column.
Public classSetColumnGroupNumber Sets the group number of the selected columns.
Public classSetColumnPosition Sets the position of the selected column.
Public classSetColumnValues Sets values of the selected data or property column.
Public classSetRowPosition Sets the position of the selected row.
Public classSortColumnsByPropertyColumnAscending Sorts columns by the selected property column in ascending order.
Public classSortColumnsByPropertyColumnDescending Sorts columns by the selected property column in descending order.
Public classSortTableAscending Sorts the table in ascending order.
Public classSortTableDescending Sorts the table in descending order.
Public classSpectroscopyFitPeaksInMultipleSpectra Opens the peak finding and fitting dialog for multiple spectra.
Public classSpectroscopyPeakFindingFitting Opens the spectroscopy peak finding and fitting dialog.
Public classSpectroscopyPreprocessing Opens the spectroscopy preprocessing dialog.
Public classSpectroscopyRamanNeonCalibration Calibrates Raman data by using a neon spectrum.
Public classSpectroscopyRamanSiliconCalibration Calibrates Raman data by using a silicon spectrum.
Public classSpectroscopyYCalibration Calibrates the Y axis by using an intensity spectrum.
Public classTableDataSourcePresentConditionEvaluator Evaluates whether a data source is present for the active table.
Public classTableShowProperties Shows the properties of the active worksheet.
Public classWorksheetClearDataAll Clears all worksheet data.
Public classWorksheetClearDataOnly Clears only the data values of the active worksheet.
Public classWorksheetClearDataTableShowDialog Opens the worksheet cleaning dialog.
Public classWorksheetCommands WorksheetCommands contain operations concerning the worksheet itself, such as rename.
Public classWorksheetDuplicate Duplicates the active worksheet.
Public classWorksheetMoveTo Moves the active worksheet to another project folder.
Public classWorksheetRemoveDataAndPropertyColumns Removes all data and property columns from the active worksheet.
Public classWorksheetRemoveDataColumnsOnly Removes all data columns from the active worksheet.
Public classWorksheetRemovePropertyColumnsOnly Removes all property columns from the active worksheet.
Public classWorksheetRename Renames the active worksheet.
Public classWorksheetTranspose Transposes the active worksheet.
Public classXYVToMatrix Converts selected X-Y-value data into a matrix.