コード例 #1
0
        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);
        }
コード例 #2
0
        public void addNewDataSet()
        {
            DataSet newDataSet = DataSetFactory.create(Globals.ExcelAddIn.getActiveWorksheet(), null, "Data Set " + (model.numberOfDataSets() + 1), COLUMNS, true);

            model.addDataSet(newDataSet);
            view.selectDataSet(newDataSet);
        }
コード例 #3
0
        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);
        }