private void addDataSetOfCurrentSelection() { _Worksheet workSheet = Globals.ExcelAddIn.getActiveWorksheet(); Range range = Globals.ExcelAddIn.getCurrentSelectionRange(); if (model.hasIntersectionWith(range)) { if (DataSetManagerForm.ignoreIntersection(model.getFirstIntersectingDataSetWith(range))) { return; } } if (range.Rows.Count == 1 && range.Columns.Count == 1) { range = Globals.ExcelAddIn.getExpandedCurrentRange(); range.Select(); } bool addNewDataSet = (range.Rows.Count != 1 || range.Columns.Count != 1) && DataSetManagerForm.addNewDataSet(range); if (!addNewDataSet) { return; } DataSet newDataSet = DataSetFactory.create(workSheet, range, "Data Set " + (model.numberOfDataSets() + 1), COLUMNS, true); model.addDataSet(newDataSet); view.selectDataSet(newDataSet); }
public void addNewDataSet() { DataSet newDataSet = DataSetFactory.create(Globals.ExcelAddIn.getActiveWorksheet(), null, "Data Set " + (model.numberOfDataSets() + 1), COLUMNS, true); model.addDataSet(newDataSet); view.selectDataSet(newDataSet); }
public void setVariableNamesInFirstRowOrColumn(DataSet dataSet, bool variableNamesInFirstRowOrColumn) { if (dataSet == null) { return; } DataSet newDataSet = DataSetFactory.create(dataSet.getWorksheet(), dataSet.getRange(), dataSet.getName(), dataSet.getRangeLayout(), variableNamesInFirstRowOrColumn); model.swapDataSets(dataSet, newDataSet); }